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
824 reads
Blog Posts
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
Capturing DB Usage stats – sp_spaceused simulation using DMV’s.
SP_SPACEUSED
sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by...
2014-12-01 (first published: 2014-11-24)
6,825 reads
Creating Placeholder Files
I recently wrote about placeholders for disk space. While you can use any file, like large images, video, etc., I’ve...
2014-12-01
999 reads
Drill-through to Details from Reporting Services to Excel
Can an SSRS report be designed to drill-through to an Excel workbook in-context (showing only the same filtered detail data)?...
2014-12-01
1,610 reads
Gmail and Match.com are Conspiring to Breakup My Marriage
My wife and I are happily married. Both of us were surprised the other day when she started getting Match.com...
2014-12-01
684 reads
Last Weeks Top “Reading” Links #111
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-12-01
523 reads
SQLFamily.Org
Back in March 2013 I wrote We Need A Place For SQLFamily News after the death of the spouse of...
2014-12-01
516 reads
You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without...
2014-12-01 (first published: 2014-11-19)
9,657 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