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

T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026

Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would have guessed that T-SQL Tuesday would still be going strong years later? Other attempts at similar recurring themed posts have been attempted (I can’t even remember their names), but none…

Read more

T-SQL Tuesday #99 – What’s Behind Door #1

It’s hard to believe that we have reached T-SQL Tuesday #99 already. This month’s host is Aaron Bertrand (blog|@AaronBertrand), and he is giving us 2 choices to choose from for the theme of our posts. Door #1 is about #sqlibrium or what you are passionate about outside of SQL Server…

Read more

New Year’s Resolutions for this DBA

It’s a new year, and if you read my post almost 2 week’s ago, you know that I’ve already started making changes. What you may not have realized is that the job change was an important step in realizing the changes I had resolved to make. This list is a…

Read more

How Not to Sell Software: a Tale of Bad Sales

Naming no names here, but I want to talk about a really horrible sales call I had recently. Well, the horribleness started with the call, but continued afterward. There was part of me that wanted to tell the vendor during the call to put their software someplace protected from the…

Read more

Westbound and down, roll ’em up and truckin’

A little less than 2 years ago, my wife and I loaded up our cats and dog and moved from the Seattle area on the west coast to New York City on the east coast. It was quite an experience. Turns out the old saying was true. More money did…

Read more

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

Older posts