Pop Quiz, Hotshot!
Pop Quiz, hotshot. A vendor installed a maintenance plan on one of your SQL Servers. It looks like this: What do you do?
Category: SQLServerPedia Syndication
Database Administrator Rated One Of The Fastest Growing Careers Through 2020
An article on Yahoo Education recently ranked Database Administrator as the second fastest growing career through 2020, with a projected job growth of 31%. The piece lists a couple of reasons for this, most of which I agree with. Then I read the last line of the article: “Companies with large databases may prefer those […]
Why Is That Delete Statement Taking So Long?
My phone rag at 4 AM last Sunday morning, which is never a good sign. It was a member of our IT team who was doing an upgrade to some software. He was concerned because a particular SQL statement had been running for 30 minutes so far and when this person performed the upgrade on […]
SQL Saturday #193 Coming to Chandler, AZ
Sorry for the lack of posts lately. I took a 2 week cruise to Hawaii for my tenth wedding anniversary and am currently trying to catch up with everything that piled up while I was away. During the cruise, I also got a kidney stone and had to go to the hospital in Kauai for […]
Enabling Data Compression In SQL Server
SQL 2008 saw the introduction of data compression to SQL Server. (I’m referring specifically to data compression, not backup file compression.) This Enterprise-only feature allows SQL Server to store data on disk and in memory in a compressed format. SQL can perform three types of data compression – no compression, row compression, or page compression. […]