Escaping from a runaway Logon trigger
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...
2014-05-27 (first published: 2014-05-19)
1,758 reads
Database Backup Encryption with SQL Server 2014
A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...
2014-05-26 (first published: 2014-05-19)
5,754 reads
PASS Business Analytics Conference 2014 Recap, part 2
These are my impressions from the PASS Business Analytics Conference 2014 in San José, California.
The first part of this series...
2014-05-19
339 reads
Building The SQLSaturday Orlando Marketing Plan–Part 8
One of things I wish PASS provided was at least one template for an event flyer, something that is basically...
2014-05-18
506 reads
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections are part of the Business Connectivity Services (BCS) that can be...
2014-05-18
1,262 reads
PASS Business Analytics Conference 2014 Recap, part 1
PASS Business Analytics Conference is not a new kid on the block anymore – happening for the second year in a...
2014-05-18
254 reads
Developer’s Life – Every Developer is a Spiderman
Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero. The most...
2014-05-17
785 reads
What Does it Cost to Implement a Business Intelligence Project?
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This...
2014-05-17
989 reads
The Tipping Point – by Malcolm Gladwell
The latest book that I finished reading was The Tipping Point, written by the Malcolm Gladwell. I would recommend this...
2014-05-16
186 reads
Reblog: May 9 to May 15
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-05-16
713 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