Professional Microsoft SQL Server 2008 Administration
When I came home from work tonight, there waiting on my was my copy of Professional Microsoft SQL Server 2008...
2008-11-03
1,159 reads
Databases – Infrastructure – Security
Auditing for Blank Passwords
Auditing blank passwords in SQL Server 2005 and 2008 proves a bit more challenging than in SQL Server 2000. In...
2008-11-01
1,227 reads
Miramar User Group and SQL Saturday Presentations
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,560 reads
Out of Band Security Bulletin Release for Microsoft Windows
Microsoft tries to stick with the second Tuesday for security bulletin releases and has only released out-of-band a handful of...
2008-10-23
1,506 reads
"The work never matches the dream of perfection the artist has to start with."
I know, another non-technical blog post. But this one is career-related as well.
In high school I was introduced to...
2008-10-20
1,332 reads
"To Lead Is To Follow"
I first ran across these words as a Citadel cadet. Now those who know of my days at El Cid...
2008-10-19
821 reads
Speaking in West Palm Beach and Orlando
I have two speaking engagements for the week of October 19:
South Florida SQL Server User Group - West Palm Beach - October...
2008-10-18
689 reads
Red Gate SQL Response Review is up
Full Disclosure: I did receive a trial version of the software and payment for the review. I am also a...
2008-10-08
950 reads
What I'm Reading (5 Oct 2008)
Technical:Counter Hack Reloadedby Ed Skoudis with Tom Liston
It's a security book and I'm rather late getting a review of it...
2008-10-05
721 reads
Thanks to Andy Leonard
Midlands PASS was privileged to host SQL Server MVP Andy Leonard (Blog #1, Blog #2, his VSTS site, Twitter) tonight...
2008-10-03
720 reads
Blogs
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...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
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