(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)
545 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-02-17
25 reads
When you are making changes to an existing Non-Clustered index SQL Server provides a wide variety of options. One of the more frequently used methods is DROP EXISTING; in...
2021-02-17
29 reads
When you are making changes to an existing Non-Clustered index SQL Server provides a wide variety of options. One of the more frequently used methods is DROP EXISTING; in...
2021-02-24 (first published: 2021-02-17)
470 reads
In this video we start exploring some of the simple actions that are available within the Power Automate Desktop to create a solution that can
2021-02-23 (first published: 2021-02-16)
452 reads
The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of...
2021-02-16
13 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-02-16
20 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,075 reads
The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of...
2021-02-19 (first published: 2021-02-16)
847 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-02-16
19 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Comments posted to this topic are about the item Forward Deployed Engineers
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers