Mission Accomplished – Well sort of …
Did you ever set a goal and then sort of … demolish it without realizing it? That has happened this year....
2010-08-26
342 reads
Blog Posts
N Things Worth Knowing About CTEs
If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) - new in SQL Server 2005...
2010-08-26
1,293 reads
SQL Saturday #28 - Keynote
I was honored to be asked to do the keynote for SQL Saturday #28 in Baton Rouge recently. It’s taken...
2010-08-26
869 reads
SQL Saturday #28 - Slides and Impressions
I’m late, I suck, but here’s some things I started in Baton Rouge and am just now getting out.
First, I’ll...
2010-08-26
953 reads
Book Review: The Secret Service: The Hidden History of an Engimatic Agency
I picked up The Secret Service: The Hidden History of an Engimatic Agency $13 @ Amazon) from the library, had been...
2010-08-25
643 reads
Changing of the Guard
A few weeks ago Andy Leonard (Blog | Twitter) announced that he was stepping down from his position as PASS Regional...
2010-08-25
379 reads
MDX Puzzle #6
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are...
2010-08-25
625 reads
Memory
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,415 reads
Mission Accomplished... Well sort of..
Did you ever set a goal and then sort of … demolish it without realizing it?
That has happened this year....
2010-08-25
358 reads
PASS Elections Portal
I think the shirt says it all
If you’ve been under a rock the last few weeks you may not know...
2010-08-25
526 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