sometimes, you have to piss people off
Just a quick note today on being effective.
For better or for worse, I was raised by parents who had me...
2014-01-16
678 reads
SQL Server Row- and Cell-Level Security – Disclosure vulnerability // Schwachstellen in Zeilen-basierter Sicherheit
(de)
Es ist Zeit für einen weiteren Artikel zum Thema Sicherheit.
Und durch einen Forum Thread zu „Datengesteuerter Sicherheit“ mittels der...
2014-01-16
1,056 reads
[SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!
To snack lovers every where now you can consume SQL Learning the same way, in Snack Size! Introducing the new...
2014-01-16
572 reads
Powershell in a Month Day 10 – Formatting
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-15
1,068 reads
PASS SQLSaturday Events: February 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-01-15
665 reads
A Server Bench
This past weekend I was doing some early Spring cleaning and decided it was time to throw out two old...
2014-01-15
639 reads
Database in Source Control
Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me,...
2014-01-15
1,204 reads
Cleveland Rocks! (and does SQL Server)
My first flight of 2014 will be to Cleveland to run a SQL in the City seminar and then speak...
2014-01-15
844 reads
Should You Run For the PASS Board? How Do You Decide?
Here are some of the questions I ask when someone is thinking about running for the Board:
Are you eligible? Read...
2014-01-15
548 reads
sp_SrvPermissions & sp_DBPermissions V4.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
907 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers