Detecting Encryption
I ran across an article recently from MSSQLTips by my friend, Brian Kelley. It talks about the ways you can...
2015-02-11
1,354 reads
Blog Posts
Get Out There and Challenge Yourself
It’s been almost five months since I posted my last article, and so much has changed since then. I have...
2015-02-11 (first published: 2015-02-03)
6,571 reads
Standard SQL Server Build
Often I’m asked what is the best practice for a single SQL Server installation. Well, that is a tricky questions and the answer is it always depends. Let’s discuss...
2015-02-11
5 reads
Standard SQL Server Build
Often I’m asked what is the best practice for a single SQL Server installation. Well, that is a tricky questions...
2015-02-11
484 reads
What is Advanced Analytics?
Advanced Analytics, or Business Analytics, refers to future-oriented analysis that can be used to help drive changes and improvements in...
2015-02-11
1,567 reads
A VR Wielding Mentee
Hello!
This post is my submission to become one of Paul Randal’s mentee(s) in 2015: http://www.sqlskills.com/blogs/paul/want-mentored/
As I write this blog post,...
2015-02-10
433 reads
Managing Security – TSQL2sday # 63
A big thank you goes out to Kenneth Fisher ( b | t ) for hosting this month’s TSQL2sday party. Security is a...
2015-02-10
504 reads
Security as a Fleeting Thought
Today we have another installment in what is known as TSQL Tuesday. This month we have an invitation and topic given to us by the infamous Kenneth Fisher (...
2015-02-10
5 reads
Storage Benchmarking with SQLIO Batch
The goal of the storage performance analysis is to identify the performance characteristics of a target storage device. To determine...
2015-02-10 (first published: 2015-02-03)
6,902 reads
T-SQL – Query to get Distinct,Sorted, Comma Separated values in to a variable
CREATE TABLE #temp(name char(3))
INSERT INTO #temp VALUES ('CD')
,('AB')
,('LM')
,('BC')
,('GH')
,('KJ')
,('AB')
DECLARE @cols AS NVARCHAR(MAX);
SELECT @COLS = substring(list, 1, len(list) - 1)
FROM (SELECT list =
(SELECT DISTINCT...
2015-02-10 (first published: 2015-02-02)
10,409 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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