Some Jargon from the SQL Server World
Not long ago I wrote about how to write well about SQL Server, and one major point was that jargon...
2012-09-04
1,131 reads
Blog Posts
SSMS Report Error – Index(zero based) must be greater than or equal to zero and less than the size of argument list !
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information...
2012-09-04
4,717 reads
The Field Museum – SQL in the City 2012 – Chicago
Chicago is a neat down. My first PASS Summit was in Chicago, back in 1999. My wife joined me with...
2012-09-04 (first published: 2012-08-29)
2,411 reads
Windows Server 2012
I haven’t paid too much attention to this version of windows yet, but I have just been reading up on...
2012-09-04
740 reads
Am I Following Your Blog?
As I sat around this past weekend I was left wondering… am I missing any good blogs out there? With...
2012-09-03
897 reads
Capture SQL Server Deadlocks using Extended Events
Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...
2012-09-03
1,533 reads
How To Simply Say You’re a DBA
Have you ever looked back on a conversation where someone asked you “what do you do?” and felt disappointed with your reply?...
2012-09-03
980 reads
Quick T-SQL Performance Comparison
I’m not a T-SQL guru. When I have something that will run often, or I have performance concerns, I’ll ask...
2012-09-03
1,294 reads
sp_helptext
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,127 reads
Demonstration of a simple dashboard created with the Tableau Software
Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve...
2012-09-01
1,874 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