Archives: February 2012
The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version here for AdventureWorks. This download gives you an mdf, and that’s it. You can’t directly attach that in SSMS, but you can use T-SQL to do it.
CREATE DATABASE… Read more
I saw a note about an outage on Windows Azure, apparently one that’s been going on for seven hours. Once again it seems that February 29 has struck again with a computer issue, and it makes me worry that if we mess with daylight savings time, we might have… Read more
If you create your own certificate in SQL Server, you need to make sure that you back it up immediately. Once you start to encrypt anything with a certificate, you increase the risk that you’ll lose your data if an catastrophic event occurs. In this case, if you lose the… Read more
On the corner of my rather messy desk is little recognition item in the image to the right. It’s a 5 year marker, representing my 5 years as a Microsoft MVP. I’m honored that they think I’m doing enough for the community to be recognized.
Next week is the annual… Read more
Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect my test machines were mostly SQL Server 2008 or SQL Server 2012, and I hadn’t been paying attention to the changes in SP1.
You can now use T-SQL to check… Read more
You can cause yourself problems if you don’t know where your backups are stored, and how they are being made. It also helps to understand the defaults of how your backups are created in files.
Here’s a short story to illustrate an issue you might encounter as a beginner if… Read more
Why you would want to do this is a longer discussion, but suffice it to say that… Read more
This has been a bit of a hardware week for me, which is strange. I used to love hardware, building my own computers, picking out the components, and making something work out of a pile of parts.
Now I just want my tools to work.
Our Windows Home Server died… Read more
I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and UDFs in computed columns, but there was another use that someone pointed out to me recently: catching divide by zero errors.
Suppose you have a column that… Read more
Have you ever needed to do a quick time calculations of the amount of hours/minutes/seconds that have passed? Suppose you needed to get the total number of minutes that have passed for a total time of ‘2:24’.
There are some easy ways to do this, and the normal calculation that… Read more