SQL Server 2019 CU5 is out
Earlier this week Microsoft released the latest cumulative update for SQL Server 2019 and as you can expect there are quite a few items addressed including a fix for...
2020-06-24
26 reads
Blog Posts
Unsupported but working versions of SQL Server on Windows Server 2019
One of my hobbies is trying to break technology so that you don’t have to. I don’t consider myself a professional or hobbyist hacker, though if the shoe fits…...
2020-06-24
12 reads
Power BI FAQ
Power BI has become hugely popular and I find common questions about functionality and features, so I thought I would put in this blog some of those questions with...
2020-06-23 (first published: 2020-06-08)
611 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-06-23
22,609 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ‘em all over the place...
2020-06-23
3 reads
T-SQL Tuesday #127 – Non SQL Tips and Tricks, Referencing Multiple PowerShell Array Elements
This month’s T-SQL Tuesday invitation is from Ken Fisher and he’s asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into...
2020-06-23 (first published: 2020-06-09)
348 reads
Azure Platform Series: How to setup Azure Cloud Shell
This blog post will be a series on the Azure Platform and some things we can use it for. Background: I run a consultancy company – and sometimes I...
2020-06-22 (first published: 2020-06-06)
234 reads
Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism
We have seen how we can export and save the results to a folder and commit them to a GIT repository on my last blog post Backup your SQL...
2020-06-22 (first published: 2020-06-04)
389 reads
Being seen and why PASS helped
One of my colleagues/friends read my earlier blog post on the future of PASS and said he was not aware that being seen as a minority person was among...
2020-06-22
7 reads
Prevent the next data breach – a MinionWare snippet
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
8 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
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...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
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...
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