SQL Saturday Exeter
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time,...
2014-04-07
575 reads
Decode SQL Server Job Schedules
As once a data architect, I cannot help but admiring and appreciating the data model behind the sql server job...
2014-04-07
1,571 reads
SQL Server Filtered Index
What is a SQL Server Filtered Index
A SQL Server Filtered index is a nonclustered indexes that can be used to...
2014-04-05
1,353 reads
New Extended Events for Tracing in SQL Server 2014
Neue “Erweiterte Ereignisse” (XEvents) für Tracing in SQL Server 2014
(de)
Dieser Artikel enthält eine Liste der neuen Erweiterte Ereignisse (“Extended Events”),...
2014-04-04
3,060 reads
Changing SQL Server Agent Jobs Ownership: Who should own SQL Server Agent Jobs
I writing this blog post as a result of the following two questions, which I’ve been asked by one of...
2014-04-04
2,185 reads
Don’t Be an Arse
In deference to my British employers, I’ll use their word.
It constantly strikes me how rude, stupid, and unfriendly people can...
2014-04-04
986 reads
Great Companies – Spotify
I don’t know anyone at Spotify, nor have I worked there. However when I see descriptions and explanations like this...
2014-04-04
696 reads
Data Collector in SQLServer 2014 – What’s New !
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,794 reads
Monthly Reflections – March 2014
After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my...
2014-04-04
677 reads
Using BMC Control-M to Automate Tasks
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our...
2014-04-14 (first published: 2014-04-04)
4,006 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