Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+...
2015-03-04
287 reads
SQL Code Guard v2.7 and SQL Server 2008R2: bad news and good news
Hi all!
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I...
2015-03-04
665 reads
Data Size – LEN() vs DATALENGTH() - WaterOx Consulting
Reading Time: 3 minutes No. It isn’t just the way you use your data that...
The post Data Size – LEN() vs...
2015-03-13 (first published: 2015-03-04)
7,126 reads
I want to blog but …
I don’t know how to get started.
Pretty simple. There are a number of free blogging sites out there. Personally I...
2015-03-04
673 reads
Latches, Spinlocks & Lock-Free Data Structures – my SQLRally Nordic session
Whew, this was an intensive session about Latches, Spinlocks & Lock-Free Data Structures at the SQLRally Nordic conference in Copenhagen. I...
2015-03-04
590 reads
Small presenter tip: changing display mode automatically after presenter view
This morning Adam Machanic (blog | twitter) asked the following question on Twitter:
Anyone know if it's possible to configure PowerPoint 2013...
2015-03-04
691 reads
Kill–use this weapon carefully in SQL SERVER . TIP #90
When we heard “Kill” then first impression of this word is very bad. We always scare with this word.
In...
2015-03-03
670 reads
2015-03-03
5 reads
2015-03-03
6 reads
2015-03-03
5 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers