T-SQL Tuesday #53: Why so serious
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....
2014-04-08
394 reads
T-SQL Tuesday #53: Why so serious
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....
2014-04-11 (first published: 2014-04-08)
1,632 reads
Why So Serious? – #TSQL2sDAY #53
As a child/pre-teen/teenager/young adult, OK, most of my life, I’ve been labeled as “serious” or “grumpy”. Maybe I deserve it...
2014-04-11 (first published: 2014-04-08)
1,499 reads
Improving Query Performance by using correct Search Arguments
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-18 (first published: 2014-04-08)
6,578 reads
Antivirus Exclusion Policy for SQL Server
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...
2014-04-08
13,153 reads
The One Million Row T-SQL Test Harness
So far in our blogs, we have talked a bit about performance, but today we’re going to show you a...
2014-04-17 (first published: 2014-04-08)
4,681 reads
SSIS Performance Testing
I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I...
2014-04-16 (first published: 2014-04-08)
3,313 reads
One week to SQL Intersection
You still have time to grab the boss and convince him to invest in you. Show what you’ve learned in...
2014-04-08
745 reads
Last Weeks Top “Reading” Links #78
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-07
692 reads
Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
567 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