The Power of Git–Getting Code
I find git to be incredibly useful, and this is a quick example of one of the ways that this matters to me. This post is also available in...
2020-04-08 (first published: 2020-04-01)
649 reads
The Voice of the DBA
Daily Coping 1 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-01
15 reads
Goal Progress Report for March 2020
I made goals at the end of February, when I returned from sabbatical. Since then, the world has been turned upside down with a pandemic, and I’ve been struggling...
2020-03-31
6 reads
Daily Coping 31 Mar 2010
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-31
8 reads
Charting in Azure Data Studio
The March 2020 release of Azure Data Studio (ADS) includes a charting feature for SQL queries. This is a quick look at the feature, which I think will have...
2020-04-10 (first published: 2020-03-30)
549 reads
T-SQL Tuesday Live–31 Mar 2020
I’m hosting another live T-SQL Tuesday event tomorrow, which is really just a casual video meeting for anyone that wants to join and take a break from work, life,...
2020-03-30
9 reads
Daily Coping 30 Mar 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-30
2 reads
Going Dark in SSMS
I haven’t been a big fan of dark mode in many tools, but I’ve been giving it a try in some applications as my eyes age. I decided to...
2020-03-27
410 reads
Daily Coping 27 Mar 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-27
9 reads
Moving to a New SqlClient
DotNet developers, if you’re using the System.Data.SqlClient, stop. Move over to Microsoft.Data.SqlClient now. It’s easy to do, well, it’s relatively easy to say that. The actual work isn’t that...
2020-04-02 (first published: 2020-03-26)
1,264 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
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