-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Time Zones are a Drag … Seriously

Time Zones were definitely being a drag today. I got an email from one of the developers at work asking about the performance difference between 2 queries. The only difference between the 2 queries is that one of them uses the AT TIME ZONE clause that was added in SQL…

Read more

T-SQL Tuesday #96: Thank You for Taking the Time

A lot of people have made a difference in my career. A LOT! I don’t think we ever thank those that make a difference as much as we should. Often, it’s not until years later when you look back on your career and reflect on how you got from where…

Read more

Presentation Files for my Webcast on Troubleshooting Connection Problems

Thanks to everybody who attended my webcast Troubleshooting SQL Server Connection Issues yesterday. If you missed it, the recording will be available soon on the MSSQL Tips website. The slide deck and demo code will also be available with the recording, or you can download it below. Slide deck: TroubleshootingSQLServerConnectionIssues.

Read more

Check out my Tips for Friday Blog Series

In case you missed, I started a new blog series several weeks ago called 5 Tips for Friday on SQL Server Best Practices. Every Friday I post a set of 5 best practices on a particular topic. The topic changes from week-to-week. This week’s topic is database configurations: 5 Tips…

Read more

Necessity is the Mother of Automation

If you have worked with me or are a frequent reader of my blogs or a frequent attendee of my presentations, you know I hate doing things manually. Over my career, I have found that one of the biggest enemies of automation is being able to get someone else to…

Read more

Webcast: Troubleshooting SQL Server Connection Issues

I will be doing a live webcast on Thursday, November 9th 2017 at 3 PM Eastern Time (8 PM UTC time) on Troubleshooting SQL Server Connection Issues. The description for the presentation is below. Hope to you all there. Registration is required to attend. Description Whenever a connection to SQL…

Read more

Podcast with SQL Data Partners on Patching Best Practices

Recently, I joined Carlos L Chacon (site|@CarlosLChacon), Steve Stedman (blog|@SqlEmt), and the rest of the SQL Data Partners Podcast team for their podcast show and the episode went live earlier this month. We talked about best practice and the reality of patching SQL Server. Check out the podcast to get…

Read more

Checklist: DR Plan Sanity Check

If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count the number of times something happened, and I thought that I should have been able to anticipate that. It can be a big benefit to get another viewpoint on your…

Read more

31 Days of Disaster Recovery Revisited

A few years ago, I did a blog post series dedicated to disaster recovery (backups, restores, corruption, etc). 31 blog posts dedicated to the topic (though not 31 days in a row) have been compiled into a 75 page eBook that can be downloaded from the new website SQL Server…

Read more

Patching SQL Server and SSMS? Order matters.

If you’ve been living under a rock, you may not have noticed how frequently SSMS is getting updated. The SQL Team is really rocking over at Microsoft putting out fixes and enhancements fast and furious. When CUs (cumulative updates) and SPs (service packs) come out, it makes sense to install…

Read more

T-SQL Tuesday #93: 3 Jobs I Didn’t Take and 1 I did

It’s T-SQL Tuesday again, and this month’s host is Kendra Little (blog|@), and the excellent topic selected by Kendra is Interviewing Patterns & Anti-Patterns. When I logged on to Twitter this morning, the first tweet I saw was for Brent Ozar’s (@BrentO) post The DBA Job I Turned Down. It…

Read more

Real-life SQL Server Performance Troubleshooting at SQLSaturday Columbus

Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting as part of SQLSaturday Columbus at Otterbein University Campus Center in Columbus, OH. Register for SQLSaturday Columbus before it fills up, and check out the early bird pricing for the pre-conference sessions the day before.…

Read more

T-SQL Tuesday #90: The Death of the DBA in a DevOps World Has Been Greatly Exaggerated

It’s time for another iteration of the blog party known as T-SQL Tuesday. This month’s theme is Shipping Database Changes hosted by James Anderson (|@). Head on over to John’s announcement post and join in with the party by writing your own post or by just reading those that are…

Read more

Why Log Shipping is Better than Database Mirroring for Migrations

This topic has come up several times recently, so I feel the need to blog on it. As the person who wrote the book on Database Mirroring, it will probably come as a surprise to many of you that I believe that log shipping is a much better tool for…

Read more

24 Hours of PASS: Security: Session Files

Thanks to everyone who attended my presentation for the 24 Hours of PASS event on May 3rd. This iteration of the event was wholly focused on security, and my presentation was Securing SQL Server Processes with Certificates. If you missed it, the sessions were recorded and will be posted on…

Read more

T-SQL Tuesday #88: My Top WTF Moments

Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily (database-related) WTF”, and I want to share some of my top WTF moments. If you would like to participate in this month’s blog party, go to Kennie’s invitational blog post:…

Read more

2016/2017 Whitepaper Updates

One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them regularly to keep them relevant. A few of my older whitepapers have been updated by my friend and colleague Kenneth Fisher (blog|@sqlstudent144). I helped with some technical review and provided…

Read more

The Costs of Hiring Cheaper Consultants

From time to time, I see posts in forums from people complaining about how much some consultants charge. A really good consultant is never going to be cheap. That’s just the law of supply and demand at work right there. When I was consulting, I had plenty of people balk…

Read more

T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query

Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems with Shiny New Toys”. The old problem I’m going to talk about is seeing what wait types are experienced by a particular query. If you would like to participate in…

Read more

Warning: Not a valid checkpoint file name

One of the other DBAs I work with noticed a warning message that was flooding the log files on one of our servers. He asked me to look into it. I did a Bing search for the warning message and found no useful links. This is the warning message: [WARNING]…

Read more

Older posts