2012-02-17
4 reads
Blog Posts
2012-02-17
7 reads
Building Visual Studio Deployment Projects With MSBuild
I recently hit what I would call a fairly serious limitation of MSBuild and that is that it cant build...
2012-02-17
103 reads
Coca-Cola and #SQLSat 111
Got some great news today! Turns out Sarah (Blog | @DanceM0m) and I will be heading to Atlanta in a couple...
2012-02-17 (first published: 2012-02-14)
1,603 reads
Performance VC Feb Meeting
Jes Borland will be speaking for the Performance Virtual Chapter this month. Don’t miss out on this free training. Here...
2012-02-17
752 reads
Re-blog – February 10 – February 16
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-17
613 reads
Speaking at MagicPASS on February 22, 2012
Next Wednesday I’ll be returning to MagicPASS to do a presentation on SQL security for developers. It’s an interesting topic,...
2012-02-17
682 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
45 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor...
2012-02-17
1,416 reads
SQL Server – read only database status
This post describes how to return the database read-only status via T-SQL .
The system view – sys.databases returns a column called...
2012-02-17
1,119 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