SQLBits Friday and Saturday
By David Postlethwaite
The last two days of SQL Bits provide opportunities to hear short 50 minutes presentations from experts
on a...
2011-10-06
729 reads
Gethyn Ellis
SQL Bits Training Day
By David Postlethwaite
Just spent a day with Allen White, a SQL MVP from Ohio, USA learning about automating and managing...
2011-09-29
1,590 reads
David’s SQLBITS Day 1–The Travel Day
Just had a pleasurable 5 hours watching the Autumn countryside go by on a glorious sunny day (in fact its...
2011-09-28
733 reads
Sharon Dooley’s Lightening Talk and the WIT Luncheon
At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her...
2011-08-31
2,529 reads
Using PowerShell to Monitor SQL Server
By Ian Treasure
Over the past few years, I have used a number of approaches to monitor SQL Server. For example,...
2011-08-30
7,347 reads
VMFS LUN resizing options in vSphere
Introduction
First off, many thanks to Gethyn for the opportunity to post on his excellent blog.
I’m Christian Dadswell and I...
2011-08-24
1,851 reads
Get your AD information with .NET
.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve...
2011-08-22
951 reads
Another New Contributor–Christian Dadswell
This is just a short post to introduce you all to my good friend Christian Dadswell who has kindly agreed...
2011-08-17
865 reads
Auditing SQL Logins Addendum
One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....
2011-08-16
794 reads
Auditing SQL Logins Part II
Written by David Postlethwaite
In a previous blog I talked about how to audit successful logins. So what about failed logins?
As...
2011-08-15
1,484 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