March 15, 2012 2:00 PM
Posted by: Denny Cherry
Beta,
Windows 8So I've taken the plunge and installed Windows 8 Client Preview on one of my laptops. The install process was pretty simple and straight forward. The installer found my WiFi card so I was able to get everything up and running right out of the box. The next thing to do was to install SQL 2012...
March 15, 2012 3:40 AM
Posted by: Denny Cherry
Beta,
Start Menu,
Windows 8Everyone says that Windows 8 doesn't have a start menu, and it's true there's no Start Button on the task bar like in the last several versions of Windows. However if you press <Windows>+W you'll get a sort of start menu.
February 6, 2012 2:00 PM
Posted by: Denny Cherry
In Person Events,
Performance,
Query tuning,
SQL Server,
Tech Ed,
Tech Ed 2012,
Tech Ed Europe,
Tech Ed North AmericaIf you are headed to Microsoft's Tech Ed North America or Tech Ed Europe you should really look at signing up for a SQL Server Pre-Con. The pre-cons are full day sessions focusing on a specific topic, led by an industry expert. In the case of the SQL Server pre-con "Microsoft SQL Server...
February 6, 2012 2:00 PM
Posted by: Denny Cherry
Distaster Recovery,
Laptop,
SQL,
SQL ServerThe other day I had a VERY unpleasant situation happen. I managed to dump a basically full 64oz (1.8 liter) cup of iced tea all over my desk. In theory this shouldn't be a problem but it landed right on top of one of my laptops. Thankfully the laptop was off but it was plugged in when this...
January 16, 2012 2:00 PM
Posted by: Denny Cherry
SQL Server,
TestingWithout a proper QA process things can end up going a little bit wrong. Even the most basic of processes need to be checked and controlled, if they aren't then things can end up going a little wrong. Just like these
November 7, 2011 2:00 PM
Posted by: Denny Cherry
Development,
Indexing,
SQL ServerLast week on Wednesday night I had the privilege of presenting a session to the Buena Park .NET User Group. The session that I gave was "Indexing for the .NET Developer". The abstract for the session is:
"In this session we will be looking at the...
February 8, 2010 11:00 AM
Posted by: Denny Cherry
Functions,
T/SQL,
XMLRecently one of my developers asked me to begin returning data from a function as XML instead of a comma separated list. My thoughts on this was awesome, another cursor getting removed from the system. I'll write a quick FOR XML AUTO, ROOT('root') at the bottom of the SELECT statement being...
February 2, 2010 11:00 AM
Posted by: Denny Cherry
Backup & recovery,
BACKUP DATABASE,
Restore Database,
TestingI bet that if asked when the last time the database backup was taken and if it succeeded you would know off of the top of your head when that was. But if I asked you when the last time your database was restored successfully would you know?
December 28, 2009 11:00 AM
Posted by: Denny Cherry
Clustering,
SQLThis question has come up a couple of times on various forums on the Inter-webs so I figured I'd write up something a little more in-depth than I'd be able to do on a forum.
There's no way to easily flip a standalone SQL Server instance to a clustered instance. However moving a standalone...
