My PASS Summit 2011 Experience
The 2011 PASS Summit is in the rear view mirror (has it really been almost three weeks now?)...and as always...
2011-11-02
931 reads
Blog Posts
Presenting at SQL Saturday #96
I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC...
2011-11-02
789 reads
Presenting Tomorrow (Thursday) via Webinar - SQL Server Security
I have the privilege of being able to give a webinar tomorrow, November 3, at 11 AM EDT. It will...
2011-11-02
1,087 reads
Salaried employee vs contractor
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and...
2011-11-02
4,120 reads
SQL Saturday #87 Report
I drove the over 250 miles from my home in Edwardsville, IL, to attend the SQL Server 87 in Louisville,...
2011-11-02
1,320 reads
WAN Optimization Solutions–Input Needed Please!
I was just wondering if anyone has a WAN optimization solution as part of their infrastructure. I have a few...
2011-11-02
756 reads
10 More Days Until Inspiration! - SQLInspireNYC 2011
Can't believe we're ONLY 10 days out from what's shaping up to be quite an extraordinary awesome event! We've been...
2011-11-01
1,294 reads
Backup/restore/checkdb/shrinkfile progress
Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you...
2011-11-01
1,112 reads
Being an Effective DBA Remotely
Do not let the phrase “out of sight, out of mind” apply to you.
As Data Professionals a lot of us...
2011-11-01
1,128 reads
BI Pyramid (read categories of users in a BI solution)
Purpose of any business intelligence solution is to provide users information and enable them to make intelligent decisions that benefit their...
2011-11-01
810 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