Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
691 reads
Blog Posts
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
1,001 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
710 reads
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
548 reads
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
311 reads
Heartbleed bug: immediate security threat for both IT, and consumer sites and services
“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has...
2014-04-10
694 reads
I’m a Traveling Man
We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing...
2014-04-10
790 reads
Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
799 reads
Smart Moves with SQL Server VMs – Data Movement
Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to...
2014-04-10
962 reads
Webcast Follow-Up: Introduction to Columnstore Indexes
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-04-10
838 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