SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville
Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21,...
2010-08-24
1,202 reads
Blog Posts
SSSOLV: Twitter Compliant
This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter). I am not certain...
2010-08-24
503 reads
Twitter: The Next Best Thing To Being There
Why do DBAs want to go to PASS, TechEd, or SQLConnections? If asked, I suppose that many would point to...
2010-08-24
739 reads
Use ReadOnlyVariables and ReadWriteVariables properties in Scripts
For those of you just starting out with SQL Server Integration Services, you'll find a LOT of information out there...
2010-08-24
6,543 reads
DMV Emergency Queries From SQL Saturday #51 in Nashville
I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This...
2010-08-23
1,715 reads
Estimating Data Compression Savings in SQL Server 2008 and 2008 R2
Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008...
2010-08-23
3,113 reads
Fall Speaking Schedule
I just got back from speaking at SQL Saturday #51 in Nashville, which was a lot of fun. I’ll write...
2010-08-23
803 reads
Free SQL Server Training for the Week of August 23, 2010
Note: I got some of the dates mixed up, so I'm re-publishing this post.
Monday
SQL Lunch - Troubleshooting SSIS Package Development - Dustin...
2010-08-23
939 reads
Getting Drive Info Part 2, DTS
In this installment of the drive info series we will gather the drive information via a DTS package. Part 1...
2010-08-23
1,092 reads
Incremental Load - TSQL
For my first technical post in a short while I thought I would look at something I have worked on...
2010-08-23
11,038 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...
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