Defining FKs in CREATE TABLE–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-05-14 (first published: 2018-05-03)
2,922 reads
Blog Posts
Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,415 reads
Handy TSQL for Azure SQL Database
I do not always use the Azure portal to make database changes or to check for certain information. I use...
2018-05-14
322 reads
I’m speaking: SQL Saturday Los Angeles 06-09-18
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...
2018-05-14
238 reads
Microsoft Azure – Azure Mobile App is available now
Hello friends, Please check the below link for my new post on Microsoft Azure Mobile App. https://social.technet.microsoft.com/wiki/contents/articles/51525.microsoft-azure-mobile-app-is-available-now.aspx
2018-05-14
691 reads
Monday morning comic 2018-05-18
Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.
2018-05-14
339 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
107 reads
Reaching the Refactoring Redoubt with #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-14
299 reads
SQL Server Building On Calculations With APPLY
I find myself using Apply more and more in my queries, aside from the usual reasons I’ve been finding I...
2018-05-14
39 reads
Day 13 MySQL Performance_Schema
performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear....
2018-05-13
248 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
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
The Side Job
Comments posted to this topic are about the item The Side Job
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