SQLKonferenz 2015
If you are looking for one of the most awesome and most import conferences in Europe, then surely you need...
2014-12-04
431 reads
Blog Posts
INSERT INTO SELECT vs SELECT INTO
INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and...
2014-12-03
15,745 reads
Outlier Detection with SQL Server, part 3.1: Grubbs’ Test
By Steve Bolton
…………In the last two installments of this series of amateur self-tutorials, I mentioned that the various means of...
2014-12-03 (first published: 2014-11-29)
11,086 reads
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
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,696 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,980 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
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers