A summary of the SQL Server security #datachat is live
Recently I posted about participating in a #datachat about SQL Server security. As it turned out, we didn’t talk about...
2014-03-12
643 reads
Why Did My Job Fail Anyway?
One of my biggest pet peeves when I check a new SQL Server for a client is the fact that...
2014-03-12
1,067 reads
Schema & Renaming Fun
I wrote the SQLServerCentral question of the day that is live today called Schema & Renaming Fun. Mildly interesting, but looking...
2014-03-12
468 reads
T-SQL Tuesday #52 – Arguments
It’s time for T-SQL Tuesday, this month hosted by Michael J Swart, our artistic DBA in the community. I love...
2014-03-11
949 reads
Why worry about CXPACKET
Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...
2014-03-11
1,620 reads
SQL Jobs – Complete Information – SQL 2000/2005/2008/R2
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...
2014-03-11
412 reads
SQL Jobs – Complete Information – SQL 2000/2005/2008/R2
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...
2014-03-11
779 reads
Local TempDB on SQL 2012
This post has been sitting in the draft folder for way too long, March of last year to be precise....
2014-03-11
1,772 reads
Call For Speakers for SQLSaturday Houston (Before TechEd)
SQLSaturday returns to Houston this year, this time at San Jacinto College on May 10, 2014. That’s the Saturday just...
2014-03-11
396 reads
Changing the 1000 separator in Power View
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box,...
2014-03-11
1,005 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