Office 2010 and Windows XP (64 bit)
I wanted to install Microsoft Office 2010 on an old Windows XP (64 bit) laptop. I tried running the setup...
2012-09-18
1,615 reads
Blog Posts
SQL in the City – US 2012 Tour
Last year I had the pleasure of speaking at two SQL in the City events: London and Los Angeles. It...
2012-09-18
1,391 reads
SQL Saturday #149 and CodeMastery–Minnesota Events
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
526 reads
SQL Saturday #171 Pittsburgh, the Schedule is Up!
SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you're anywhere in the...
2012-09-18
753 reads
SQL Server Quickie #3 – Allocation Units
Today
I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking
about Allocation Units in SQL Server....
2012-09-18
1,587 reads
SQL Server Quickie #3 – Allocation Units
Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in...
2012-09-18
611 reads
SQL Server: Part 1 : Approaching Database Server Performance Issues
When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...
2012-09-18
1,414 reads
A Job Done Quietly and Well
My current client has a five story building, two break rooms and two sets of bathroom per floor, with I’m...
2012-09-17
630 reads
An Introduction to SQL Server
I will be delivering Learning Tree course 137 SQL Server 2008 a Comprehensive Hands-On Introduction in London this December (18th...
2012-09-17
751 reads
How to Connect PerfMon to a Remote Server ?
Till now, we do not have any third party tool to monitor the SQL server, but we have implemented many custom...
2012-09-17
4,976 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