PowerShell Split-Path Bug And A Workaround
Split-Path is a cmdlet built into Windows PowerShell that returns a specific part of a path, e.g. a parent directory...
2012-09-05
2,757 reads
Blog Posts
Cisco VPN Client 5 on Windows 8
NOTE: Always create a backup before doing any type of Windows registry modifications!!!!
With the full public release of Windows 8...
2012-09-04
1,473 reads
2012-09-04
672 reads
Error: No mapping between account names and security IDs was done
I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a...
2012-09-04
11,179 reads
Normalization & Denormalization
Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should...
2012-09-04
1,347 reads
Our weekly webshow starts Friday! #DBAsAtMidnight
Let’s pretend we’ve never met. Depending on who you are, maybe we haven’t. It’s beside the point, really.
So hi, I’m...
2012-09-04
924 reads
PASS SQL Saturday - September 2012
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2012-09-04
638 reads
PASS Virtual Chapter Events - September 2012
PASS DBA Fundamentals Virtual Chapter
fundamentals.sqlpass.org / Twitter: @DBAFundVC
September 4, 2012 - 11:00 a.m. CST
Introduction to SQL Server Service Broker
Speaker: Adam Belebczuk
In this...
2012-09-04
1,069 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session...
2012-09-04
891 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session and the SQL Community is still busy. With that,...
2012-09-04
8 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