Efficient calculation of an ISBN-13 check digit
I thought I might pass along, what I have found to be, the most efficient way to validate the check digit within Azure SQL Server. I was looking to...
2023-07-17 (first published: 2023-07-10)
370 reads
Blog Posts
SQL Server on VMware Accelerator now free!
My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason...
2023-07-17 (first published: 2023-07-07)
382 reads
A New Word: Exulansis
exulansis – n. the tendency to give up trying to talk about an experience because people are unable to relate to it – whether through envy or pity or...
2023-07-14
93 reads
Demonstrating How I Use Voice Access
As part of my effort to inform people on how to use tools with their disabilities and continue working, I created a series of videos that demonstrate how I...
2023-07-14 (first published: 2023-07-05)
127 reads
Exciting New Adventures Ahead
Some of you may know that I went to work for BlueGranite a little over four years ago. It was humbling to be part of such a talented team...
2023-07-14
48 reads
Three more chapters of my data architecture book are available!
As I have mentioned in a prior blog post, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering...
2023-07-14 (first published: 2023-06-28)
686 reads
Azure Data Studio Schema Compare Extension
A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so...
2023-07-13
76 reads
A Barebone Script To Generate SQL Script to Create Synonyms
A Barebone Script To Generate SQL Script to Create Synonyms
This stored procedure can be used to generate a SQL script to create synonyms for all tables in...
2023-07-12 (first published: 2023-07-10)
101 reads
Generate SQL Script to Allow or Disallow Access To All Data
I had a requirement to temporarily prevent access, read or write, to a particular database for all users except 2 users. There were hundreds of SQL Logins with access...
2023-07-12 (first published: 2023-07-11)
133 reads
Heraflux and Rubrik Webinar – July 25
Heraflux is returning to deliver a new webinar with Rubrik and ActualTech Media titled “How to Secure Your Azure SQL Data.” With Azure SQL Server offerings continuing to grow...
2023-07-12 (first published: 2023-06-27)
79 reads
Blogs
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers