Building a foundation for a Windows SQL Server lab on Linux First of all, this will be a blog post series. There is simply too much to cover in one blog post and expect people to read it. This blog post is going to be about how I laid the foundation …
I started blogging back in 2015. At first, I was fairly consistent, but as I’ve learned from other bloggers, posting has seasons where writing comes easy and others where life and other things just get in the way. For me, I did ok until 2022 and then …
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 …
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 …
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 …