If you work in the world of SQL Server you’ve almost certainly heard of dbatools. For those who haven’t, it’s an open source PowerShell module for automating literally hundreds...
2021-04-20 (first published: 2021-02-15)
251 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-20
(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you...
2021-04-20 (first published: 2021-02-17)
182 reads
I am excited to share an important milestone in my life. My third book, “Administering Relational Databases on Microsoft SQL“, is released. Co-authored with Ahmad Yaseen and Rajendra Gupta,...
2021-04-19 (first published: 2021-03-09)
388 reads
This is one way to create a polling loop in PowerShell. I’m sure there are several options, but this one works well for the use case. Backstory I needed...
2021-04-19 (first published: 2021-02-16)
674 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-19
5 reads
Knowledge of how your system behaves is vital to better control, maintain, and grow the system. While Azure provides all sorts of wonderful assistance within Azure SQL Database, you’re...
2021-04-19
5 reads
The WordPress mobile apps are the best way to manage your site from anywhere. If you’re already using the app, you might have noticed a new visual design that’s...
2021-04-19
The other day I got a note from Ben Weissman the other day that he was running a new event, http://dativerse.io/. Not much information, but I liked this list...
2021-04-19
3 reads
This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 4. Part 1 This is an...
2021-04-16
3 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Knowledge of how your system behaves is vital to better control, maintain, and grow...
Hi, How can we automatically remove people from report subscriptions when they are disabled...
Hi - we have 2 SQL Server 2019 instances, both with Polybase installed. I...
Hello~ I administer a database application (Azure SQL Server Back End/MS Access Front End)...
Ask SSC