Resources for Those Dealing with Security Patches
It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...
2012-08-24 (first published: 2012-08-21)
2,571 reads
Databases – Infrastructure – Security
Rant: Applying Common Sense in IT
I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...
2012-08-23 (first published: 2012-08-17)
4,595 reads
PowerShell Saturday in Charlotte, NC
If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...
2012-08-15
1,345 reads
Speaking Tomorrow for Professional Development VC
As I blogged about previously, tomorrow (Wednesday) I will be speaking for the PASS Professional Development virtual chapter. My talk will...
2012-08-14
1,130 reads
Audit Yourself Regularly
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...
2012-08-13
1,703 reads
Speaking for PASS Professional Development Virtual Chapter
This coming Wednesday I will be speaking for the PASS Professional Development virtual chapter. My talk will be on my...
2012-08-10
2,113 reads
Don't Use Passwords That Can Be Social-Engineered
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,946 reads
Learn to Use Books Online
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...
2012-08-06
2,049 reads
Stop Storing Unencrypted Passwords!
I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...
2012-07-30 (first published: 2012-07-26)
2,740 reads
Cross-Post: Set Milestones for Little Victories
This seemed appropriate to cross-post from Goal Keeping DBA given the editorial for today:
One of the first pieces of advice...
2012-07-25
1,088 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