Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
2009-06-12
1,034 reads
Articles
Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
2009-06-12
1,024 reads
Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
2009-06-12
1,028 reads
Gathering in the Corner - SQLSaturday #14
I'm done with SQLSaturday #14, actually stuck in Pensacola for an extra night, but that's another story. It was a great event, and I have to say I was very surprised at the number and variety of speakers that came to contribute to the event
2009-06-12
1,022 reads
Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008
This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.
2009-06-12
2,093 reads
Notes on SQLSaturday #14 in Pensacola
I'm just back from the event and it turned out very well, just over 170 attendees attending their choice of 30 sessions. Pensacola is a lot smaller than some cities so the 170 is an amazing turnout, and unusually there was only about a 10% no show...
2009-06-12
909 reads
SQL Saturday 14 - Pensacola
I’ve just arrived home from a quick trip to Pensacola to speak at SQL Saturday 14 in Pensacola, FL. I’m quite happy with the event; the planning and organization was handled very well, and I believe the event was a big success in the eyes of the...
2009-06-12
1,124 reads
SQL Saturday Pensacola pics
The SQL Saturday Pensacola pics are up! Visit the SQL Saturday Facebook group at
2009-06-12
1,244 reads
Using authenticators with SQL Server encryption
Authenticators are additional data that gets encrypted along with the data to be stored in an encrypted manner. When it comes to decrypt the data, if the right authenticator isn't specified, SQL Server doesn't return the data in the decrypted form. Rather, a NULL value is returned, just as if the wrong key was used.
2009-06-12
2,384 reads
Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
2009-06-11
832 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