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,407 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,664 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
923 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,690 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
4,189 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,824 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)
2,007 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)
11,259 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,597 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,323 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers