Proper Usage of MAXDOP Setting When Compressing Indexes in SQL Server 2008/2008 R2
I am a pretty big fan of SQL Server Data Compression, especially the enhanced version found in SQL Server 2008...
2010-08-17
2,316 reads
Blog Posts
Random Fun – Password Rules Cheatsheet
Piggybacking tangentially off of Tim Mitchell’s (blog, Twitter) SSC editorial Turn a Bad Job into a Good Experience…yesterday I got...
2010-08-17
669 reads
SQL Saturday 28 was extraordinary!!!!
Folks, I have to tell you that this event was great!! It was really well organized, with great speakers. Personally, I...
2010-08-17
628 reads
SQL Server 2005 SP3 Cumulative Update 11 (CU11) Available
Microsoft has released Cumulative Update 11 for SQL Server 2005 SP3, which is Build 9.0.4309. There are only four fixes...
2010-08-17
827 reads
SQL Server 2008 R2 RTM Cumulative Update 3 (CU3) Available
Microsoft has released Cumulative Update 3 for SQL Server 2008 R2 RTM, which is Build 10.50.1734. I count 29 fixes...
2010-08-17
892 reads
SQLSaturday #51 in Nashville
SQLSaturday is coming to Nashville this weekend, Saturday August 21st at 8:00am in the Student Services building of Nashville State...
2010-08-17
317 reads
Star Struck
Have you ever run into an error and been puzzled as to why that error occurred?
Recently I have been working...
2010-08-17
770 reads
August PASSMN Meeting This Week
It’s that time of the month and that time of the years. Time for another PASSMN meeting. Also, time for...
2010-08-16
426 reads
Automation: Granting Read Perms for Developers
Yeah, you heard me.
Do you like to read?
“But Kendra, why would we want to grant developers read permissions? And why...
2010-08-16
941 reads
Integration Services vNext Coming Soon?
That title may be a little premature - but I've recently seen a (relative) boatload of Connect submissions getting resolved, either...
2010-08-16
498 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers