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...

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...

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...

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,...

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...

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 (...

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...

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...

ExpressProfiler - new build published

Just published new signed build of ExpressProfiler - few nice improvements like advanced search, stay on top window, transparency - just to make...

Part 3 Adding Tab Controls – Create your own SQL tools with PowerShell and windows forms

Steve:
James recently published part 3 of his PowerShell and Windows Forms series for creating your own SQL Tools. In this...