All About Execution Plans
If you’re attending the PASS Summit this October, I’d like to make a suggestion. The Summit itself is only three...
2011-08-03
861 reads
Blog Posts
Applying a Snapshot -AltSnapshotFolder Parameter
Did you know a snapshot can be applied using the Distribution and Merge Agent –AltSnapshotFolder parameter? This means that after...
2011-08-03
544 reads
Detecting Fake Reviews
I saw this write up about Cornell coming up with a way to detect fake online reviews with about 90%...
2011-08-03
856 reads
How to Run Programs as a Domain User from a Non-domain Computer
As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must...
2011-08-03
1,404 reads
I’m A Part Of Things Greater Than Myself, The POSSE Is Here.
Something Is Missing…
Some of you know I have a deep passion for the SQL Server community. I’ve always been extremely...
2011-08-03
836 reads
My SQLbits sessions
Since today its official, I'm presenting 2 sessions at the SQLbits conference in Liverpool
(http://www.sqlbits.com) from September 30 –
October 1. Here...
2011-08-03
862 reads
Presenting Hardware 301 at 24 Hours of PASS on September 7
PASS just announced today the next occurrence of 24 Hours of PASS (24HOP), which is called the Summit Preview version....
2011-08-03
770 reads
Rant: Security Isn't Sexy and It's a Shame
I grew up immersed in security. My father was a US Marine and going on and off base meant... security....
2011-08-03
1,232 reads
Register for 24 Hours of PASS NOW! #sqlpass
Do you need to perfect your SQL Server skills? Would you like to get 24 hours of free SQL Server...
2011-08-03
577 reads
SQL Saturday #79 South Florida
SQL Saturday in South Florida is quickly approaching in just 2 short weeks. As usual, if you are in the...
2011-08-03
649 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