ScaleIO SAN - Great for VMware, Not so great for SQL Server
Hello, we have a new miniseries coming up, we haven't decided on formats (Blog, Youtube, podcast...) but, we've recently gained a good...
IsDST function for SQL Server
I've seen my share of in-house logics to detect if a given day falls under daylight saving time or not, and the conclusion I've come to...
Finally, a mirrored drive!
Lacie came up with a hard drive that actually looks like a mirror ball. Now we challenge them to come up with mirrored *AND* striped model.
Deciding between Availability Group and Clustering - Episode IV: Software side of the story
Hello all - we hope all is well with your SQL server. In this post - we're going to talk a bit about software side of the story when...
Availability Group is a Klingon Warrior
One thing you should know about AG is that it carries the sign of house it was born in, like a Klingon Warrior. One of the cool features...
Out of space? SQL dead? Here's what you do.
Microsoft makes it pretty easy to run a SQL database - and of course, the flip side of it is that there are gazillion improperly managed...
Yep. We are SQL consultants, and are telling you to stop using SQL.
Sounds stupid, right? Have we lost our minds? Well, as a matter of fact, occasionally we do suggest our clients to move some stuff out of...
MiniMe to the rescue - Simple but effective performance tuning trick
Happy Thanksgiving! We wish everyone a great thanksgiving and if you are stuck babysitting SQL server, we salute you! You suppor the...
SQL Server Simple Facts
You know, in those blog pages of consulting firm like ours, people tend to brag about their expertise, uncovering tidbits about DMVs...
Quick query to return currently restoring databases
People need weird thigns for weird reasons. Well, if the thing you need just happens to be: List of databases that are currently in...
