What were you thinking (hidden relationship)???
What were you thinking?
Have you ever been working on some code from another person, and you end up scratching your...
2018-12-05 (first published: 2018-11-20)
2,245 reads
Blog Posts
Azure SQL Database – Firewall Rules
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
231 reads
Azure SQL Database Managed Instance Business Critical Tier Now Available
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high...
2018-12-04
39 reads
High CPU and Query Store, A Story of Spinlock Heartache
This is going to be a quick look at an issue that we recently encountered, I’m not going to go...
2018-12-04 (first published: 2018-11-20)
2,360 reads
SQL Date functions in SQL Server
SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many...
2018-12-04
661 reads
SQL in the City is Next Week
Next Wednesday, Dec 12, I’ll be back in the UK with Kathi, Kendra, and Grant for SQL in the City...
2018-12-04
800 reads
System Variables in Azure Data Factory: Your Everyday Toolbox
(2018-Nov-20) After working and testing the functionality of variables within Azure Data Factory pipelines, I realized that it's worth to explore...
2018-12-04 (first published: 2018-11-20)
2,855 reads
T-SQL Tuesday 109: Influence Somebody Invite
How have you impacted somebody in the community?
It has now been 28 months since the last time I hosted a...
2018-12-04
225 reads
T-SQL Tuesday 109: Influence Somebody Invite
Building on the work of these three fine individuals, here comes the difficult task. You have been the benefactor of some awesome help from somebody else. You even wrote...
2018-12-04
3 reads
Two Words For Faster Scalar Functions
Watch this week’s episode on YouTube.WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why...
2018-12-04
228 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