SQLSaturday #164 – Cleveland – Touchdown!!
SQLSaturday #164 is in the books and the months of work and planning that went into putting this event together...
2012-08-20
837 reads
Blog Posts
Status Reports
I like a good status report. It may contain a few sentences or a page full of data and gauges,...
2012-08-20
3,999 reads
Why I Like My Job – #Meme15
A while back, Kevin Conan (Blog | @ConanTheCDN) emailed me about this months #meme15 topic. He thought it would be good...
2012-08-20
1,029 reads
Boyce - Codd Normal Form (BCNF)
Boyce - Codd Normal Form (BCNF) :- A normal form is said to be a Boyce - Codd Normal Form if it is in...
2012-08-19
4,249 reads
Isolation levels in SQL Server
Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with...
2012-08-19
22,113 reads
PASS Virtual Chapter August presentations
If you do not know by now, PASS has many virtual chapters that give free webcasts all month long. I...
2012-08-19
773 reads
Would You Listen To The Steve & Andy Radio Show?
My friend Steve Jones and I have talked every week for a long time, close to ten years now. On...
2012-08-18
975 reads
Database Corruption, Transparent Data Encryption, and Trace Flag 5004
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,740 reads
Different ways to audit SQL Server security
Today, my first article (ie. Different ways to audit SQL Server security) published on SearchSQLServer.com. In this article, I discussed...
2012-08-17
1,094 reads
Home Backup for the DBA
I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed...
2012-08-17
1,519 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers