Looking Forward to Getting My Kindle 2
When the Kindle 2 was first announced, I debated about whether or not to get it. Then I realized I...
2009-02-21
1,367 reads
Databases – Infrastructure – Security
You Must Trust Your DBAs
This is a follow-on post to You Must Trust Someone. My point in that post was to establish that being...
2009-02-20
1,945 reads
Adobe Acrobat/Reader 0day - Disable JavaScript
There is an active attack in the wild for the newly announced Adobe Acrobat and Adobe Reader vulnerability. While the...
2009-02-20
2,063 reads
You Must Trust Someone
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across...
2009-02-20
3,077 reads
The Limited Usefulness of Encrypting File System (EFS) and Transparent Data Encryption (TDE)
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...
2009-02-18
4,092 reads
Another Reason to Avoid Cross-Database Ownership Chaining
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,155 reads
Counterpoint: Against Specialization
Brent Ozar wrote his Things you know now and in it he says this under his first point, Pick one...
2009-02-11
2,226 reads
New Security Bulletin for SQL Server 2000/2005 (MS09-004)
Affected Versions:
SQL Server 2000 SP4SQL Server 2005 SP2Unaffected Versions:
SQL Server 2005 SP3 SQL Server 2008Original Vulnerability Report:http://www.securityfocus.com/archive/1/archive/1/499042/100/0/threaded
Microsoft Security Bulletin Link:http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx
Brief Analysis:
The...
2009-02-11
889 reads
Things you know now...
This was the brainchild of Mike Walsh, who asked, "What do you wish you knew when you were starting?" I...
2009-02-10
1,264 reads
SQL Server 2008 Enterprise Edition install - use the "right" version of the Microsoft .NET 3.5 SP1 install
This is something that bit us over the weekend as we attempted to install two new SQL Server 2008 Enterprise...
2009-02-09
1,788 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