Install product update during SQL 2012 installation
SQL Server 2012 setup program has 2 new installation parameter
1. /UpdateEnabled:
Specify whether SQL Server setup should discover and include...
2012-08-30
3,652 reads
Blog Posts
Invited to the PASS Summit Blogger Table
Earlier this week I RSVP’d to an invitation to sit again at the bloggers table at the Summit. It was...
2012-08-30
1,540 reads
SQL Server 2012 RTM Cumulative Update 3
Microsoft has released SQL Server 2012 RTM Cumulative Update 3, which is Build 11.00.2332. There are 36 fixes (by my...
2012-08-30
3,331 reads
Windows 8 and Hyper-V: It’s that easy!
First, I need to set the record straight – I am not a systems guy. When I need work done to...
2012-08-30
1,365 reads
Free Second Shot offer for Microsoft Certification Exams
Nothing for me to really say except if you mess up, you get a free second chance Click HERE to see...
2012-08-29
1,144 reads
Misc Links for Aug 29,2012
Sword fighting. A friend sent me this, debunks the movie view we have of sword fighting. I can’t say I...
2012-08-29
1,630 reads
PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it
I recently had the need to script the execution of a command-line utility and thought it would be a good...
2012-08-29 (first published: 2012-08-28)
28,612 reads
Reporting on common code smells : A POC
Over the past few blog entries, I’ve been looking at parsing TSQL scripts in a variety of ways for a...
2012-08-29
1,899 reads
September 2012 Speaking Events
September is another busy month of speaking events for me and I thought I’d share them with you so maybe...
2012-08-29
1,731 reads
Southwest Missouri SQL Server Users Group to Have First Meeting in October
The Southwest Missouri SQL Server Users Group (SWMOSSUG) is dedicated to providing SQL Server Education and Career Guidance for IT...
2012-08-29
1,821 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