What’s the big deal with moving a DB to another server? Detach it, move it, and then reattach it, right? Easy peasy! But what if it’s a whopping 20tb? Can your company handle the DB going offline for that long? Fear not, here’s the scoop on how to make that happen with just a few minutes of downtime.
Continue reading
As a DBA, you are responsible for ensuring the smooth functioning of databases that store critical business data. To perform your job efficiently, you need a set of tools and utilities that can help you monitor and manage databases. That’s where a DBA Toolbox DB comes into play.
Continue reading
Happy Birthday! What’d I get you for your birthday? Ummm I got…. a fun experiment. Yeah yeah, let’s do a thought experiment, shall we? Close your eyes… no really go ahead and close them, I’ll watch your cake so no one takes it… I promise.
Development has come a long way over the last several decades. One of the biggest advancements is Source control. But its not just for developers.
Continue reading
One of the best parts of the SQL Server community is the abundance of those willing to help others. I don’t know how many times I’ve posted on Slack, Stack Exchange, or other sites asking for assistance and received a prompt well informed reply. There are so many free scripts and tools out there written by some of the best of our brethren that you would be surprised they are giving away for free!
NULL values can sometimes confuse SQL developers when they first start to write queries. In this article, we’ll review some of nuances of NULL values that you should be aware of in your queries.
So you have started running queries in SQL Server. You are becoming a master at joining tables and getting the data you want. But have you given any thought to where/how all this information is stored? Sure, its housed in tables on your server’s data drive. Yet, knowing exactly how this data is stored will help you better understand why running
SELECT {every field}
FROM SomeTable
takes just as long as
SELECT {single char field}
FROM SomeTable
And also knowing how to set up the right indexes can tremendously speed up queries.
SQLCwby - Chris Woods 