What Would I Do With a Week?
After my editorial this week on Coding By the Sea, my boss actually pinged me to say that I could...
2010-02-03
388 reads
Blog Posts
“Building a Better Blog” with Steve Jones
I recently watched Steve Jones’ (Blog | Twitter) "Building a better blog" presentation from the 24 hours of PASS virtual conference...
2010-02-02
848 reads
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:
T-SQL Tuesday Participation Over the Years December 19, 2018
T-SQL Tuesday #104: Just Can't Cut That Cord...
2010-02-02
9 reads
Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-02
1,706 reads
PASS Acquires SQLSaturday
I’ll write more about this tomorrow, but for now I’m reposting the release from Rushabh Mehta, President, PASS:
It gives me...
2010-02-02
314 reads
Providing Online Help for Powershell Modules
As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of...
2010-02-02
2,003 reads
RedGate Releases SQLSearch - FREE!
RedGate Releases SQLSearch - FREE!
SQL Search - Released
My friends at RedGate have released a new FREE Tool. Please read on to learn...
2010-02-02
803 reads
Reflections on ‘Visibility, the Art of Being Noticed’ by Phil Factor
If you have not read the Master of Phrenetic Phoughts’ article, please do so here. I enjoyed very much the...
2010-02-02
966 reads
SQLSaturday Bequeathed to PASS
I guess you could look at this one of two ways. Either PASS acquired SQL Saturday, or we (Andy, Brian,...
2010-02-02
580 reads
Three Engine Improvements in SQL Server 2008 R2
The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area...
2010-02-02
953 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