Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a fairly simple construct, but I...
2021-04-21 (first published: 2021-04-14)
432 reads
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)
487 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
8 reads
(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)
542 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)
607 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)
1,049 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
7 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
7 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
26 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-16
21 reads
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
Because we are NABL Accredited Laboratories, our personal care and cosmetics research center provides...
hi, need to known weather fast farwand cursor is faster than a while loop...
Comments posted to this topic are about the item Economics of AI: What is...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers