Thanks For Stopping By
Yesterday I passed 300,000 views on the blog. Recently I went over 1,000 comments. My little joke on Tuesday garnered...
2014-04-03
641 reads
The Scary DBA
SQL Server 2014 New Defaults
Today, April 1st, 2014, marks the release of SQL Server 2014. There are tons and tons of great new methods...
2014-04-01
973 reads
Save Money On Your Training Server
You can spend less money. Some of us are lucky. We work for very large corporations who can easily set...
2014-03-31 (first published: 2014-03-25)
2,193 reads
PASS DBA Virtual Chapter Talk
I almost forgot to tell you about the Database Administration Virtual Chapter meeting next week, March 26th, 2014. I’ll be...
2014-03-21
635 reads
Query Tuning Near You
It really is so much easier to just throw hardware at badly performing databases. Just buy a bigger, faster server...
2014-03-19
1,183 reads
Finding Mistakes
Ever had that moment where you start getting errors from code that you’ve tested a million times? I had that...
2014-03-18
777 reads
SQL Saturday: You can’t have it all.
SQL Saturday’s are awesome! Let’s get that clear up front. The organizers of SQL Saturday events are glorious individuals. Let’s...
2014-03-17
667 reads
sp_updatestats Is Not Smart
No, I don’t mean the use of sp_updatestats is not smart. It’s a fine, quick mechanism for getting statistics updated...
2014-03-11
1,087 reads
Speaker of the Month, March 2014
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
871 reads
Let’s Talk Query Tuning
I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively...
2014-02-27
1,278 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Rebuild Index Job on a Large DB
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
Authentication Error 0x8009030c
Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....
how to stop command prompt window from appearing when running PowerShell script?
Hi everyone I have a PowerShell script that is run by Execute Process Task...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers