Helping Database Administrators
Let’s be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on...
2013-06-07 (first published: 2013-06-04)
1,761 reads
The Scary DBA
Using PowerShell to move files to Azure Storage
I was searching all over the place to try to find out how to move files into Azure Storage. Most...
2013-06-03
2,356 reads
Microsoft Teched 2013 Keynote
Welcome to Teched 2013
We’re starting off with some type of James Bond video. Chase scene with a really cool car....
2013-06-03
872 reads
Painting the US Red
We are bringing Red Gate, through the free SQL in the City event, to the United States again this year.
This...
2013-05-29
814 reads
SMO vs Invoke-Sqlcmd in Azure
I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be...
2013-05-28
1,068 reads
A Little Azure Fun on Friday
You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions...
2013-05-24
725 reads
PASS Summit 2013 is Looking Cloudy
No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be...
2013-05-22
651 reads
Microsoft Lync Through the Web
Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...
2013-05-21
780 reads
Azure does Powershell too
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...
2013-05-23 (first published: 2013-05-20)
1,933 reads
Book Review: Business in the Trenches
I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to...
2013-05-09
730 reads
Blogs
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
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...
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