Will GDPR cause a “Database Run”?
What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...
2018-02-05 (first published: 2018-01-23)
2,404 reads
Solomon Rutzky
- Interests: Computers (duh ;-), religion, sarcasm, chocolate covered raisins
- Website: https://SqlQuantumLeap.com/
- LinkedIn: https://www.linkedin.com/in/srutzky/
Server Audit Mystery 1: Filtering class_type gets Error Msg 25713
The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...
2018-02-01 (first published: 2018-01-22)
1,381 reads
Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used
SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...
2018-01-09
798 reads
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”)
(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...
2018-01-04 (first published: 2017-12-08)
2,687 reads
PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining
(last updated: 2018-03-27)
Despite features added in SQL Server 2005 (yes, 2005!) that allow for very flexible, granular, and robust security,...
2017-12-30
3,265 reads
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)
(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...
2017-12-28 (first published: 2017-12-11)
1,819 reads
Sessions, Temporary Objects, and the Afterlife
For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some...
2017-11-30 (first published: 2017-11-20)
1,994 reads
Line-Continuation in T-SQL
Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e....
2017-11-08 (first published: 2017-10-27)
9,428 reads
All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters
As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist...
2017-10-31 (first published: 2017-10-16)
2,270 reads
SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing
“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...
2017-10-09 (first published: 2017-09-29)
2,309 reads
Blogs
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Using ChatGPT for Writing
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Forums
Advanced SQL query help
Hi, I am looking for some help with two queries using the following table/data....
Happy Memorial Day 2023
Comments posted to this topic are about the item Happy Memorial Day 2023
Install SQL Server using Powershell Desired State Configuration (DSC)
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Install SQL Server using Powershell...
Ask SSC