Ola Hallengren, who we meet every so often at SQL Connections, has a great script that helps automate consistency checking, backups, and index maintenance. He's constantly updating it and it's good quality code. Check out the latest version for SQL Server 2005 and 2008:
Enjoy!
iAI is obviously the hot new thing and prognostications for the future range from the unicorns-and-rainbows life of idleness for us all to the post-apocalyptic
(This was the editorial for my 300th SQLskills Insider newsletter last week, that I’ve been producing since March 2011! See bottom of browser window to
I’m excited to be presenting at the Pass Summit in November! My pre-con workshop is my absolute favorite to teach Performance Tuning with Waits and
Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: Check It Out! SQL Server Jumpstart+ Bundle $4,070.00 Original price
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore from and no ability to fail over
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.