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 …
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 …
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 …
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. …
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 …
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 …
You know you need to be thinking about SQL Server security, but maybe you’re not sure where to start. Topics like firewalls and ports and port scanners and such may be dancing your mind. Those are good things to think about, but they are not under …
You’re a data professional and you’ve been given the keys to a new SQL Server environment. You know you need to build a SQL Server inventory so you know what is in your environment, but how do you get that information? One of the things I have talked …
You need to create a SQL Server inventory. Without this information, you’ll be unaware of critical information about the environment your responsible to manage. We’re on a journey to make sure that you as a DBA know what SQL Servers are in your …
I was recently thinking of SQL Server temporal tables and how there is a perspective that you shouldn’t use proprietary features of a product because it locks you into that product. I want to be your guide on this matter. Database platforms are …