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,901 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
254 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,076 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,124 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
561 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,385 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,634 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,383 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)
3,168 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,328 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Can/Can't Do/Don't
Comments posted to this topic are about the item Can/Can't Do/Don't
Strange String Splits
Comments posted to this topic are about the item Strange String Splits
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers