How SQL Server stores data types: floating points
In this post we are looking at how SQL Server stores floating point values (FLOAT and REAL). If you’d like to read the previous posts in this series of...
2020-06-10
189 reads
Blog Posts
Next week is EightKB–The SQL Server Internals Conference
Next week, on Wednesday, June 17, 2020, the EightKB conference takes place. As with other events, it’s online, and it is full of high level content. It looks to...
2020-06-10
37 reads
Remote communication for fun and profit! – a MinionWare snippet
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
9 reads
Remote communication for fun and profit! – a MinionWare snippet
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
12 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-06-10 (first published: 2020-05-23)
424 reads
Webcast – Principles of Data Modeling
Tomorrow, June 11, 2020, at 3 PM Eastern I’m giving a webcast on the Principles of Data Modeling. Sign up link: https://www.mssqltips.com/sql-server-webcast-signup/?id=822 Here’s what we’ll be covering: You’ve been...
2020-06-10
46 reads
Adding the Social Headline Topic
The world is changing, and the activism is infectious. I’ve tried to be fairly apolitical and unoffensive for most of my career. I definitely have not always succeeded, but...
2020-06-09
9 reads
Daily Coping 9 June 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-09
13 reads
Export Deadlocks to file from system_health Extended Event using PowerShell
Just a quick post as may help any of you searching for this. Scenario Client wants to analyze most recent deadlocks that happened on a specific instance. They asked...
2020-06-09 (first published: 2020-05-25)
1,475 reads
OPENJSON and CROSS APPLY
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-09
15 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