Omaha BI/SQL User Group – What?
I recently received an email from this guy named John Morehouse (blog | twitter) about the Omaha SQL/BI User Group Meeting in May. Imagine my surprise when reading the email...
2014-05-07
9 reads
Omaha BI/SQL User Group – What?
I recently received an email from this guy named John Morehouse (blog | twitter) about the Omaha SQL/BI User Group Meeting in...
2014-05-07
772 reads
Another User Has Locked My File!
I had an SSIS package fail in a script task this morning. As part of the why process I opened...
2014-05-07
347 reads
Does SQL Server do a CHECKDB during an instance restart?
When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server...
2014-05-13 (first published: 2014-05-07)
2,398 reads
Speaking at SQLBits 2014: PreCon on In-Memory OLTP and Security session
Sprecher auf der SQLBits 2014 zu In-Memory OLTP und Sicherheit
(DE)
Nachdem ich letztes Jahr das erste Mal als Teilnehmer auf...
2014-05-07
844 reads
Migrating SQL Server logins
Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During...
2014-05-15 (first published: 2014-05-07)
9,691 reads
Searching SSIS Packages or searching XML In General
Today I'm posting a small script with a simple purpose. I wanted to search all of my SSIS packages in...
2014-05-07
786 reads
I’ve Written a Book…Getting Started with SQL Server 2014 Administration
That’s folks you heard it here first. Since the end of 2013 through to April this year I have been...
2014-05-14 (first published: 2014-05-07)
2,242 reads
What’s Happening at the PASS Business Analytics Conference?
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week...
2014-05-07
456 reads
SQLSaturday #308 Houston, TX Saturday May 10th
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans...
2014-05-07
458 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