Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
564 reads
Blog Posts
SQL Server Filtered Index
What is a SQL Server Filtered Index
A SQL Server Filtered index is a nonclustered indexes that can be used to...
2014-04-05
1,351 reads
Analyzing CXPACKET waits
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This wait...
2014-04-04
525 reads
Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,861 reads
Changing SQL Server Agent Jobs Ownership: Who should own SQL Server Agent Jobs
I writing this blog post as a result of the following two questions, which I’ve been asked by one of...
2014-04-04
2,149 reads
Don’t Be an Arse
In deference to my British employers, I’ll use their word.
It constantly strikes me how rude, stupid, and unfriendly people can...
2014-04-04
975 reads
Follow Up To A Questionable Trigger
This question of the day didn’t turn out well at all – required too big a leap the way it was...
2014-04-04
500 reads
Friday Followup For April 4, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-04
467 reads
Great Companies – Spotify
I don’t know anyone at Spotify, nor have I worked there. However when I see descriptions and explanations like this...
2014-04-04
693 reads
Monthly Reflections – March 2014
After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my...
2014-04-04
670 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