Blogs

SQL Server Indexing Basics - 7 Lessons Learned

SQL Server indexing basics are critical to query and server performance. Resources, like CPU and disk, are affected by the indexes that you have, or the ones you’re missing. In the StackOverflow2013 database we’re going to look at Badges and users. …

Continue reading

6 Reasons to Learn PowerShell

 SQL Server professionals may be reluctant to start using PowerShell. After all, you already know T-SQL well and can do a lot with that to manage SQL Server. I’ve been using PowerShell to manage SQL Server for the last 5 years and it has …

Continue reading

Getting Started With SQL Server

I see a lot of questions on data related Reddit forums and data science groups on LinkedIn about how to get started with SQL. Certainly these people mean that they want to learn the SQL language. I don’t think you can do that long term without …

Continue reading

SQL Server 2019 CU 16 Introduces Problems for Log Shipping

 As a data professional managing SQL Servers, you need to be thinking about Windows and SQL Server patching. You want to stay up to date, but you also have to be careful because sometimes staying fully up to date comes with the risk that a new patch …

Continue reading

One Key Mistake When Installing SQL Server

There’s one sure-fire way to set yourself and your applications up for failure when using SQL Server. I’ve seen all kinds of people do this. It will cost you performance and create maintenance headaches down the road. Let me explain what it is and …

Continue reading

3 ways to verify that a backup has taken place

 As data professionals responsible for SQL Server, it is drilled into our heads that we need to take backups. But, how do we know we actually have backups available to us when we need them? How can we verify that a backup has been taken? Some types …

Continue reading

SQL Server 2012 End of Support Migration Plan

 Today is end of support for SQL Server 2012. May it rest in peace. Migrating a SQL Server can be a lot of work. There are so many things to think about. It’s a pain. Live view, upgrading SQL Server Let me offer you a template of steps to get you …

Continue reading

A Look Back at SQL Server 2012

 SQL Server 2012 extended support ends July 12, 2022 – no more patches of any kind. I hope this isn’t news to you, and you’re already planning a migration. Before I post about a migration plan, though, I’d like to take a look back at SQL Server 2012. …

Continue reading

How To Read The SQL Server Error Log

 Reading the SQL Server Error Log is important when troubleshooting many issues for SQL Server. Some example issues would be errors related to Always On Availability Groups, long IO occurrence messages, and login failures. Unfortunately, the SQL …

Continue reading

3 Tips for Writing Good Code as a SQL Developer

 SQL Server Developers are under-rated. That’s right! I’m a DBA and I said, “SQL Developers are under-rated.” Dedicated SQL Developers help I.T. teams by writing efficient code that gets just the data that is needed and in a way that leverages how …

Continue reading