Why Format TSQL?
Recently I had the chance to help a student debug a problem on a production server. It appeared to be...
2008-06-29
1,453 reads
SQLAndy
Volunteering
Recently I was visiting with an old acquaintance and one of the topics that came up was volunteers. At some...
2008-06-26
2,214 reads
SQLSaturday Call for Speakers - Cleveland & Olympia
Call for speakers is open for SQLSaturday #5 in Olympia, WA on Oct 10 (note that the MS BI conference...
2008-06-25
1,463 reads
Employee or 1099?
My friend Wes Dumey does a lot of work in the business intelligence sector as a contract employee and has...
2008-06-24
1,614 reads
Microsoft BI Conference Oct 6-8, 2008
Had missed the announcement, came up in conversation yesterday with a friend, the BI conference will be Oct 6-8 in...
2008-06-23
1,637 reads
Notes on My Visit to Birmingham SQL Group
Spent last Tues/Wed in Birmingham, speaking at the user group Tuesday night and then presenting a seminar on Wed. Attendance...
2008-06-22
1,395 reads
Transparent, Translucent, or Opaque? Whats Your Strategy?
It's a couple weeks old, but there was a mild blog roar over some comments from Microsoft about wanting to...
2008-06-19
1,549 reads
SQLSaturday #4 Lessons Learned
Earlier in the week I posted a quick & positive note about the event, today I'll add some notes about things...
2008-06-18
1,385 reads
Link: Killing Terminal Service Connections
Needed to kill a connection so I get could logged on recently to a server and didn't have the server...
2008-06-17
1,392 reads
Community Speakers/Leaders - Where's the ROI?
I participated in a lunch meeting recently with a number of people from MS that work on their community efforts,...
2008-06-16
1,781 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