sp_BackupDatabases v1.3
New version of sp_BackupDatabases released this morning, first update that I’ve made available in a while. I’ve been running this...
2014-12-08
877 reads
Blog Posts
Speaker of the Month: December 2014
For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...
2014-12-08
551 reads
SQLSat in DC – it’s a wrap
This past weekend I had the opportunity to go visit Washington DC. It was just the second time I got to stay in the Nation’s capitol for more than just...
2014-12-08
3 reads
SQLSat in DC – it’s a wrap
This past weekend I had the opportunity to go visit Washington DC. It was just the second time I got to...
2014-12-08
548 reads
Starbucks Clover
I recently read Onward: How Starbucks Fought for Its Life without Losing Its Soul by Howard Schultz. Not bad reading...
2014-12-08
848 reads
T-SQL Tuesday #61 – Giving Back
The Season of Giving
The annual PASS Summit (otherwise known as the #SQLFamily reunion) is over. Here in the United States,...
2014-12-08 (first published: 2014-12-02)
6,435 reads
Using a date or int column as the clustered index.
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on...
2014-12-08 (first published: 2014-12-01)
6,988 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or articles - if you have anything that you think...
2014-12-07
5 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
46 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
89 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