What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...
2018-04-18 (first published: 2018-04-09)
2,893 reads
Solomon Rutzky
- Interests: Computers (duh ;-), religion, sarcasm, chocolate covered raisins
- Website: https://SqlQuantumLeap.com/
- LinkedIn: https://www.linkedin.com/in/srutzky/
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
(last updated: 2018-04-18)
This is Part 3 of 2. Yes, you read that correctly. You see, way back at the very...
2018-04-16
238 reads
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2
(last updated: 2018-04-28)
Recap
In Part 1 of this 2 part series, I started with the loose definition in Microsoft’s documentation for...
2018-04-11 (first published: 2018-04-06)
2,024 reads
Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?
(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:
SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...
2018-04-09
1,113 reads
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...
2018-04-03
505 reads
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level
Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...
2018-03-15 (first published: 2018-03-05)
2,345 reads
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level
Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...
2018-02-28 (first published: 2018-02-15)
2,599 reads
SQLCLR vs. SQL Server 2012 & 2014 & 2016, Part 7: “CLR strict security” – The Problem Continues … in the Past (Wait, What?!?)
If the new “CLR strict security” Server-level configuration option in SQL Server 2017 hasn’t caused enough confusion and pain, then,...
2018-02-23
1,374 reads
Server Audit Mystery 2: Filtering action_id gets Error Msg 25713
(last updated: 2018-06-05)
This post is, for the most part, a continuation of Server Audit Mystery 1: Filtering class_type gets Error...
2018-02-12 (first published: 2018-01-30)
2,747 reads
SQL# Version 4.1 is released!!
Version 4.1 of SQL# has just been released!
New functionality available only in Full version
Sys_LockResourceReturns the name of the specified Lock...
2018-02-12
1,320 reads
Blogs
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks
I’ve been using Azure SQL Database for quite some while and have set up...
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Forums
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC