You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...
2013-08-29 (first published: 2013-08-27)
2,344 reads
I know what y'all are thinkin', what's Charlotte got to do with SQL Server? Just hear me out. There's a...
2013-08-20
1,274 reads
UPDATED -- Jul 3, 2015 -- To verify database exists, per comments by Konstantinos Katsoridis. Thanks for finding the bug!
In my recent adventures...
2013-07-23
1,617 reads
Before we get started, I want to make it clear this is NOT how you would normally configure all these...
2013-07-16
2,365 reads
Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...
2013-06-25
4,173 reads
SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory. However, it can...
2013-05-28
1,129 reads
Sometimes rapid code development doesn't always produce the most efficient code. Take the age old line of code SELECT COUNT(*)...
2013-05-07
5,260 reads
With opening day of Major League Baseball season finally here, I thought I’d take the time to cover two of...
2013-04-02
1,263 reads
Database mirroring has been around since SQL Server 2005, and it's turned out to be an excellent step up from...
2013-03-26
2,434 reads
T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter). The topic is about File and Filegroup...
2013-03-15 (first published: 2013-03-12)
2,883 reads
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Welcome to Trikago, your ultimate Travel, Travel Guide companion on a journey to explore the...
Comments posted to this topic are about the item A Partial Count
Comments posted to this topic are about the item The Stagnant Career
Ask SSC