Next Gen File System ReFS(Resilient File System) and SQLServer !
“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server...
2012-12-13
1,105 reads
SQLSailor.com
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,457 reads
PASS Summit 2012 News – Check- in Experience!
Registration and Check in for PASS Summit 2012 was opened yesterday (Nov 4th), and I decided to utilize this opportunity...
2012-11-05
789 reads
PASS Summit 2012 Countdown Begins !!!
All roads lead to Seattle!
If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical...
2012-10-23
1,206 reads
Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,282 reads
Backing up the “log” of a database which is in Simple recovery model ! – Watch out for this!
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a...
2012-10-01
1,090 reads
Cannot assign a default value to a local variable !
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...
2012-09-27
2,925 reads
Max Text Replication Size – When you might have to care about this number !
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...
2012-09-24 (first published: 2012-09-18)
6,895 reads
You don’t want to miss this out,Serious SQLServer training – 24 Hours of PASS event !
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all...
2012-09-13
736 reads
Installing SQLServer for SCCM 2012 – Some points to note on patch levels
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For...
2012-09-05
1,683 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers