Archives: May 2012
I’ve done quite a bit of speaking over the last few years, which has required a lot of travel. I had 15 events that I attended last year, only one of which was in Denver, so I spent quite a few days on a plane.
This year I’ve cut back… Read more
I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow runner and one of the smartest SQL people using a treadmill desk. I saw it in his office at SQLSentry a few years ago, and was… Read more
One of the keys to managing a large production SQL Server environment is being aware of changes that are taking place in the environment, and preventing potentially harmful changes. There are any number of ways to do this: triggers, auditing, PMB, third party monitoring, and more.
In this post, I… Read more
This article about exercising when you can is really interesting. It contains a number of hints about exercising and fitting it in, but fitting it into your life, as you live it. I especially like the note about the fact that you will lose time in your life every month… Read more
Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.
It’s trivial to switch the database online.
Not trivial to recover from an accidental restore with RECOVERY (the default)
Filed under: Blog Tagged: Backup/Recovery, disaster recovery, sql server, syndicated
I read the confessions of a recovering Lifehacker and thought it was an interesting read. It seems that the author has started to realize that while you can make some differences in the small stuff in your life, it’s just small stuff. It’s also important not to let the organization,… Read more
Suppose you had some data like this:
But what you really want is this:
Where you have a placeholder for each student. This is a… Read more
I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used to certain shortcut combinations that make it easy for me to write T-SQL quickly and get information on parameters without opening Books Online. It’s works better than the native intellisense… Read more
My fourth visit to the Rocky Mountain Tech Trifecta will be tomorrow where I’ll deliver two talks:
Branding Yourself for a Dream Job – 9:30am, Rm 1130
Unstructured Data in SQL Server – 3:15, Rm 1402
There’s still time to register if you’re in the Denver area, and you will… Read more
Cloud computing doesn’t seem to have any great definition. Like the physical structures is is named for, it is amorphous, with no defined boundaries, and often, without a recognizable shape. There are even a whole host of different acronyms (IaaS, PaaS, SaaS), which attempt to provide… Read more
Once you’ve enabled filestream, the next step is to add a filegroup to your database to hold the filestream data. This is pretty easy to do, and I’ll show you the SSMS and code versions.
Change Tracking (CT) and Change Data Capture (CDC) were both added to SQL Server in 2008. At first it seems like these two items ought to be synonyms, but they’re separate features. They are similar, but there are some differences, and you might choose to use them in different situations. Read more
A post more for me than for anyone else, since I’ll look for something in the default trace and I often need this snippet of code:
select path from sys.traces where is_default = 1
That returns something like this:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\log_92.trc
This is… Read more
It was a little over a year ago that I stood on stage at the Rocky Mountain Tech Trifecta and gave a keynote speech in which I said these words:
“My wife works in the mobility/cellular phone industry right now, but she really wants to train horses for a living. … Read more
Update: This is confirmed by Snopes.
A NYC Taxi driver wrote:
I arrived at the address and honked the horn. After waiting a few minutes I honked again. Since this was going to be my last ride of my shift I thought about just driving away, but instead I… Read more
Sequences are a new object in SQL Server 2012 that generate just what the name implies: a sequence of numbers.