Creating a SQL Agent Job Wrapper with PowerShell and SMO
Some Background
“Is there any way to start a SQL Agent job using a script or program?”
I’ve seen this question asked...
2015-05-22 (first published: 2015-05-13)
6,906 reads
How to Find Objects that Contain a Certain String in SQL Server
Let’s say you remember a piece of code you need to optimize or take a look at, but you don’t...
2015-05-13
626 reads
ASP.NET 5 On OS X : Getting Started
This post is part of a series of posts on ASP.NET 5 the series index can be found here ASP.NET...
2015-05-13
55 reads
SQL Server Reference Architecture on SimpliVity
Recently, I was able to help SimpliVity work to develop a reference architecture document for running resource-intensive SQL Server virtual machines on...
2015-05-13
1,231 reads
TSQL Tuesday #66: Monitoring
If a user is going to call me about problem, I’d much rather know about it ahead of time. In...
2015-05-21 (first published: 2015-05-12)
4,902 reads
Monitoring SQL Server
Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related meme in the blogosphere – TSQLTuesday. This month we...
2015-05-12
6 reads
Monitoring SQL Server
Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related...
2015-05-12
556 reads
Monitoring Your Backups [T-SQL Tuesday #66]
Cathrine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday, and the topic she chose is monitoring. All of us, whether...
2015-05-12
1,118 reads
T-SQL Tuesday #66 - Monitoring for a healthy SQL environment
Just heard
that today was T-SQL Tuesday #66! Well,
I knew it was Tuesday, and T-SQL comes into play once a month,...
2015-05-12
2,188 reads
Office Hours Webinar: Is Biml Right for You?
If you’ve read my blog or attended one of my presentations before, you almost certainly know that I’m a huge...
2015-05-21 (first published: 2015-05-12)
4,372 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