Placeholders for Emergencies
A long time ago I worked in a large corporation where we managed lots of servers, each of which performed...
2014-12-03 (first published: 2014-11-24)
6,813 reads
Blog Posts
SQL Saturday NYC Update 1
It has been one week now since SQL Saturday NYC was announced and the planning committee and myself are very...
2014-12-03
367 reads
SSRS SharePoint Integrated Mode – Report Server URL
This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...
2014-12-03
2,697 reads
Clustered Columnstore Indexes – part 45 (“Multi-Dimensional Clustering”)
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
362 reads
Exam Prep 70-463: Just the facts, ma’am
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-02 (first published: 2014-11-24)
7,981 reads
Get Information on Current Traces Running
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
939 reads
More Notes From The PASSWatch Project And Thoughts on Transparency
It’s been just over two months since I wrote the first post for PASSWatch. I’m trying hard to keep PASSWatch...
2014-12-02
548 reads
Preparing a Technical Session Part 1: Picking a Topic
So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you...
2014-12-02
826 reads
Review: Ghost of My Father
I finished reading Ghost of My Father by Scott Berkun over the holiday weekend. It’s an intense read about the...
2014-12-02
539 reads
SQL Server 20082008 R22012 || Remove Node from failover cluster
Steps to remove node from failover cluster for SQL Server 2008 onwards :-
Note :-
a) Same process will be used to...
2014-12-02
1,107 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers