Parsing Windows event logs with PowerShell
Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that...
2012-09-20
7,536 reads
Blog Posts
SQL Server 2012 Upgrade
SQL Server 2012 has been in RTM since the 1st April 2012. Many of my clients have been evaluating the...
2012-09-20
1,110 reads
tablediff Utility
I recently stumbled across a little gem of a utility called tablediff. I have been working a lot with replication...
2012-09-20
6,748 reads
24 Hours of PASS
Tomorrow Brian Knight and I will kick off 24 hours of PASS with a session on Choosing a Microsoft Reporting...
2012-09-19
1,187 reads
Creating a User Defined Table Type
I saw a post about a user defined table type in SQL Server and I was sure it was a...
2012-09-19
148,202 reads
Database Recovery Advisor feature of SQL Server 2012
SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases...
2012-09-19
2,395 reads
Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2012-09-19
759 reads
Lenovo–Three Strikes
Last Friday Lenovo told me my new laptop would ship this Monday, or “much much sooner”. Monday I called to...
2012-09-19
808 reads
Master Data Services: Expand the Leaf member attributes box
In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member...
2012-09-19
816 reads
Master Data Services: Versioning
In Master Data Services (MDS), you can create multiple versions of the master data within a model. When you create...
2012-09-19 (first published: 2012-09-17)
3,329 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