I’ve been doing migrations fairly continuously for the past 18 months. PowerShell has been my primary mechanism for many parts of the process, including copying jobs from the source SQL Server to the target. That has worked almost without incident …
In the previous two parts we’ve reviewed investigating logins to SQL Server, which operate at the top server level. We’ve also reviewed looking at logins at the database level. Today, I’ll be showcasing another couple of ways to view SQL Server …
In a previous post we started reviewing SQL Server security at the server level by looking at Logins. Is that enough though? It definitely isn’t! We need to look at the users at the database level as well. So, let’s do that. Again, the internet is …
My favorite thing that happened this year was that I was a speaker at the PASS Data Community Summit in November. I presented an online live stream at the world’s largest SQL Server conference, and I did it while in-person at the conference in …
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. …
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 …
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 …
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 …