Last Weeks Top “Reading” Links #106
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-27
442 reads
Blog Posts
Minion Reindex is here
We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite...
2014-10-27
700 reads
Reducing the size of the distribution database & improving transactional replication performance: Part 3
Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the...
2014-10-27 (first published: 2014-10-20)
6,811 reads
Remove Witness from SQL Server Database Mirroring
1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server...
2014-10-27
7 reads
Oh! I forgot When I took last Database Backup ? How to determine this? TIP # 66
In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can...
2014-10-25
286 reads
Be Careful! Backups Can Bite You!
Here is a riddle for you…
You are requested to move a database from an old server to a new server....
2014-10-24 (first published: 2014-10-20)
7,593 reads
Find all triggers in a SQL Server Database
Reading Time: 2 minutes
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce...
2014-10-24
513 reads
Overview of Published Articles – 2014Q3
Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...
2014-10-24
781 reads
Reblog: October 17 to October 23
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-10-24
785 reads
Clustered Columnstore Indexes – part 42 (“Materialisation”)
Continuation from the previous 41 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Important Disclaimer – I have started writing this blog post over 1 months...
2014-10-23
343 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
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
The Side Job
Comments posted to this topic are about the item The Side Job
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