Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
13 reads
I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development...
2019-04-23
8 reads
There are many great resources out there for data visualization. Some of my favorite data viz people are Storytelling With Data (b|t), Alberto Cairo (b|t), and Andy Kirk (b|t)....
2019-04-23 (first published: 2019-04-11)
502 reads
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
40 reads
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data. When the data types do not match, SQL Server has to...
2019-04-22 (first published: 2019-04-09)
686 reads
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...
2019-04-22 (first published: 2019-04-10)
625 reads
Coming up in just a couple of weeks, I’ll be presenting my session, Power BI Governance 101, at SQL Saturday #820 in Jacksonville, Florida on May 4th. The event...
2019-04-22
28 reads
I am happy to announce that I will be speaking at SQL Saturday Raleigh this Saturday, April 27, 2019. I have been part of the organizing team for this...
2019-04-22
9 reads
It was an Easter Monday yesterday and I thought it was not a good time to prepare a blog post. It was a time to rest with the family...
2019-04-22
14 reads
It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...
2019-04-19
6 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
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