Naked Conversations
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
354 reads
SQLAndy
Renaming Databases Posted on SQLServerCentral.com
Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly...
2008-09-04
293 reads
Vacations
If all has gone well I've been on vacation this week, enjoying the world class quartz sand at Siesta Key...
2008-09-04
1,107 reads
Performance Tuning Tips From the Consultant Perspective
I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain...
2008-09-03
292 reads
Creating Databases Posted on SQLServerCentral.com
Creating Databases was actually posted last week, but got distracted with some other stuff. A basis walk through of creating...
2008-09-02
395 reads
Speakers/Presenters, Can You Answer ALL The Questions?
When I teach my introductory (and free) Successful Technical Speaking class to try to help beginners enter the world of speaking,...
2008-09-01
404 reads
Labor Day
It's Labor Day here in the US today, a holiday that is tribute to those of us that work, the journey to...
2008-08-31
1,767 reads
Insufficient Space for a Side by Side Restore - What Do You Do?
I was recently working with a student in a one on one format and one the scenarios he wanted to...
2008-08-28
1,421 reads
Reminder: Upcoming SQL Launch Event in Jacksonville, FL on Sep 12, 2008
The Jacksonville SQL Server Users Group (www.jssug.com) is hosting a SQL 2008 launch event on Friday, Sep 12, 2008 in downtown...
2008-08-27
1,367 reads
Comments on a Recent Visit to Boston
Slightly off topic today.
It's fair to say I'm not a great traveler. Waiting for planes, dealing with the hassles of...
2008-08-26
1,528 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