SQL 2008 Row and Page compression – or SQL 2005 (post SP2) vardecimal conversion
One of the great new features in SQL 2008 is Row and/or Page Compression. Plus, still good news for those...
2009-01-02
1,766 reads
Blog Posts
How Certification Can Help You Stay Current with Technology, as well as Continuing Your Education
If you'd like to keep up with your profession as a SQL DBA, I thoroughly recommend certification. It has certainly...
2009-01-01
1,990 reads
Meeting Goals
I'm not a big goals person. I think it's a good idea to set goals, and they can help you,...
2009-01-01
446 reads
MVP 2009
I was re-awarded MVP status from Microsoft for 2009. Since I didn’t hear anything to the contrary in the last...
2009-01-01
455 reads
MVP Award
Received my notification via email this morning that I've been recognized as a Microsoft MVP for SQL Server. It's been...
2009-01-01
736 reads
PASS Update #1
As many of you know I'm joining the PASS Board of Directors for a two year term beginning yesterday. I'm...
2009-01-01
381 reads
Thoughts for 2009
Only a few changes planned for this coming year to the blog (so far), none of them huge:
I plan to...
2008-12-31
1,411 reads
Another Use of XML
XBRL is yet another use of XML, this time for financial reporting. It is supposed to be in place for...
2008-12-30
1,724 reads
End of 2008 Wrap Up Post
Something new for the end of the year - a recap of everything I posted for 2008. 303 posts if the...
2008-12-30
1,542 reads
SQL Server 2005 SP3 - Released! - quick Info
Till know everyone has the information for the SQL Server 2005 SP3 for all versions!
Download info here
What's new in SP3!...
2008-12-30
1,428 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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...
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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers