(last updated: 2021-09-01 @ 14:18 ET / 2021-09-01 @ 18:18 UTC ) In my previous post, SSMS and SQLCMD: Prevent T-SQL Batch From Not Only Executing, but Also From Parsing (Cruel Joke #3), I talked about voiding an entire query batch in SQL Server Management Studio (SSMS), the sqlcmd utility, and Visual Studio. I discovered… Continue reading SQLCMD: Prevent an Entire Batch From Even Parsing With One Magical Character (Cruel Joke #4)
Category: General
Error -2068643839 / 1602 Installing msoledbsql.msi, msodbcsql.msi, and sqlncli.msi for SQL Server 2019 (CTP or RTM)
Installing SQL Server 2019 CTP 2.5 fails with almost no useful info. Searching on code or message finds nothing. This post fixes that 😎
SSMS Tip #3: Easily Access/Research ALL Unicode Characters (Yes, Including Emojis 😸)
Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.
Cruel Joke: Prevent SQL Server From Starting, and With (Almost) No Indication Why
Come see how to prevent SQL Server from starting, and in an easy-to-fix-yet-impossible-to-find way! 😈
Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition
(last updated: 2020-07-05 @ 12:45 EST / 2020-07-05 @ 16:45 UTC ) Occasionally I want / need to change a Windows setting that is not configurable via Control Panel or Settings. For example: Enabling long-path support (long = paths over 259 characters) Disabling all Live Tiles The instructions usually require using Group Policy Editor (gpedit.msc).… Continue reading Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition
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 of laws that governs the collection, retention, and use of personal information for EU (European Union) and UK citizens. It's the topic "flavor of the month" due to it going into effect on… Continue reading Will GDPR cause a “Database Run”?
Hello 🌎
This is a test of the Sql Quantum Leap broadcast system. Had this been a real post, there would (hopefully) be some useful information here :-).