Writing Technical Articles - A Few Simple Tips
A few simple tips that I've learned over the years. Keep these in mind as you write your next article.
That...
2009-08-26
1,038 reads
Blog Posts
Continuous Integration in a Development Environment using Red Gate Backup and SQL Compare
My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes...
2009-08-25
1,109 reads
Database Mirroring Across Domains, Using Certificates.....
Database Mirroring w/o a Domain, Can be a Pain - but it can be done......
Have you ever had to setup mirroring...
2009-08-25
6,536 reads
Examing database shared locks using sys.dm_tran_locks
If you’ve worked with Microsoft SQL Server for any length of time, you’re probably already aware that SQL Server uses...
2009-08-25
690 reads
Featured Blogger: Alexander Kuznetsov
I’ve been reading his blog for a while and getting consistently good value. I’d categorize it as a SQL blog...
2009-08-25
720 reads
Kalen Delaney Joins The SQLSaturday Advisory Council
Last but certainly not least we’ve just announced Kalen Delaney as a member of the Advisory Council. Now that we...
2009-08-25
575 reads
New Book
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
563 reads
PASS Board Nominations
I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...
2009-08-25
669 reads
PASS Board of Directors - Call for Nominations
Well I feel a little strange making an announcement about this since I'm not running. A number of people have...
2009-08-25
1,619 reads
PASS Connector Editorial for August 26, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-25
548 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