(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
My latest Pluralsight course has been published – SQL Server: Understanding and Performing Backups. It’s 2.5 hours long, and from the course description: It’s really impossible to escape
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see
As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
There’s a persistent myth that you cannot upgrade a database to a version more that is more then two versions newer. It’s not true. You
In the last IEHADR class we just had in Chicago, I was doing a demo of looking in the transaction log to find the point
It’s been a bit light on technical posts here over the last few months but now that summer’s over I’ll be ramping up again with
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
A while back I kicked off a survey asking what mechanism you use for running your regular SQL Server database maintenance. Here are the results:
A couple of weeks ago I kicked off a survey asking how often you perform full backups of your databases. Here are the results: The
A couple of weeks ago I kicked off a survey about where you store your backups. Here are the results: The’Other’ responses are: 8 x
In this survey, I'm interested in how often you perform a full database backup of your production databases. I'll editorialize the results in a week
In this survey I'd like to know where you store your SQL Server backups. If a disaster occurs, where do you get them from? It
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
The September SQL Server Magazine articles are now available on the web and include my latest feature article on Using Database Repair for Disaster Recovery.
The July edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
The June SQL Server Magazine articles are now available on the web and include my latest feature article on Advanced BACKUP and RESTORE Options. Rather
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) One of
Next Wednesday, June 9th, I'll be presenting at the monthly meeting of the PASS DBA virtual chapter. The Live Meeting starts at 11am PST and
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
The March edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
Happy New Year! The January edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A
Earlier today there was a question on SQL Server Central where someone wanted to know what could be causing so many reads on their transaction
The November 2009 edition of TechNet Magazine is up on the web and contains my latest feature article, the second in a 3-part series on
One of the perennial problems facing both experienced and involuntary DBAs is how to tell whether a database is really in the Full recovery model
The 35-page whitepaper on high availability I wrote for the SQL team over the summer has been published on MSDN. It’s a 2-300 level whitepaper
The July 2009 edition of TechNet Magazine is available on the web and include a feature article I wrote explaining backups. It's the first in
Chad Miller over on SQLServerCentral has put together a really great collection of scripts that allow you to easily monitor and report on what backups
There’s still a widely held misconception that when properly in the FULL or BULK_LOGGED recovery models that full or differential backups can truncate the log.
About a year ago, I blogged a cool script that would work out how much of a database has changed since the last full backup
This week's survey is inspired from many stories I saw on the forums and Twitter this week – mostly bad, one good (someone I'm following
Last week’s survey was on what kind of backups you take, along with the recovery model used (see here for the survey). Here are the
In this week's survey I'm interested in what kind of backups you take, and also what recovery model you mostly use. If you have multiple
A short post to start the day (in India) and then at lunchtime I'll do how it works: FILESTREAM garbage collection. This is a question
Last week's survey was on how *you* manage the size of your transaction log (see here for the survey). Here are the results as of 4/10/2009
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.