Tool Review: Hamachi VPN
Maybe I haven't looked at the right products, but two years ago when we needed a VPN solution there wasn't...
2008-07-31
1,445 reads
SQLAndy
Operation Hands Free
Recently I was driving home and as I made that turn into the sub-division where I live, over the course...
2008-07-30
1,353 reads
Blogging on SQLServerCentral.com
Recently my friend Steve (managing editor of SSC) posted to his blog about The Bad Karma Project that has to...
2008-07-30
1,366 reads
Tool Review: Servers Alive
Not all of us work at companies big enough to justify the expense/time it takes to implement something like MS...
2008-07-29
1,436 reads
Rebuilding Stats: Twice or Not at All Posted on SSC
Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the...
2008-07-29
1,467 reads
IP6 Addresses Could Break Your DB
I saw this post from Rick Strahl about IP6 Addresses in Vista breaking some code, and it immediately made sense...
2008-07-28
1,439 reads
Tool Review: Microsoft Virtual CD-ROM Control Panel
It's downright common these days to download programs as ISO images, but XP doesn't have a native viewer for them....
2008-07-27
1,681 reads
Blogging Thoughts - Part 2
Earlier I wrote Blogging Thoughts - Part 1 where I discussed the various approaches I've seen in blogs (blogging when you...
2008-07-24
1,341 reads
Tool Review: TaskSwitchXP
For longer than I care to count I've used the Alt-Tab Powertoy from MS to get a nicer view of...
2008-07-23
1,289 reads
Blogging Thoughts - Part 1
One of the things I've been looking at is different blogging styles and trying to figure out which to recommend...
2008-07-22
1,325 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