Confessions of a DBA – Part 2
How I caused a fifteen minutes of blocking.
This particular incident happened when I joined this company. I joined this company...
2011-04-12
1,345 reads
Blog Posts
Corporate Staffers = Second Class Citizens?
Earlier today I read a blog post that compares consultants with corporate staff members. The author unashamedly compares consultants to...
2011-04-12
1,319 reads
Corporate Staffers = Second Class Citizens?
Earlier today I read a blog post that compares consultants with corporate staff members. The author unashamedly compares consultants to...
2011-04-12
776 reads
It's not about whether you're a consultant or full-time staff...
There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...
2011-04-12
1,339 reads
PASS SQLRally–Thoughts from an Organizer
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the...
2011-04-12
844 reads
PASS SQLRally–Thoughts from an Organizer
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the organizers. As today (April 12th) is the last day...
2011-04-12
10 reads
PASS Women in Technology
The Professional Association for SQL Server (PASS) Women in Technology group first caught my attention at the PASS Summit in 2009...
2011-04-12
1,004 reads
Powershell Day 12
Day 12 ADSI Using Powershell you can work on Active directory as well. Active directory is introduced in windows 2000....
2011-04-12
482 reads
SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported
Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it....
2011-04-12
2,892 reads
T-SQL Tuesday - Using APPLY to find out which queries are running on which CPU...
When I saw that Matt Velic's is hosting T-SQL Tuesday, and he has invited the SQL commmunity to participate, I was very...
2011-04-12
2,921 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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