Come to Us or We’ll Come to You
No, that’s not a threat. It’s an offer to help out.
Redgate Software is very serious about the efforts we’re putting...
2015-06-01 (first published: 2015-05-18)
1,423 reads
Extending your metadata with Extended Properties
Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on...
2015-05-28 (first published: 2015-05-18)
5,968 reads
How to Move MSDB & Model SQL Server system Databases ?
Steps of Moving MSDB & Model SQL Server system Database to new locaation:-
1) Check current location of MSDB & Model Databases by...
2015-05-18
3,286 reads
Outlier Detection with SQL Server, part 6.3: Visual Outlier Detection with Reporting Services Plots and SSDM Clustering
By Steve Bolton
…………When the goal is to illustrate how just how outlying an outlier may be, the efficiency with which...
2015-05-17
1,153 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training is second to none in its quality and intensity....
2015-05-16
16 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training...
2015-05-16
644 reads
Carving up CHECKDB
This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...
2015-05-16
183 reads
Quick Installs with Chocolatey–Screen Capture
I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight...
2015-05-15
914 reads
003 – The Data Guild - WaterOx Consulting
Reading Time: 5 minutesAre you an Apprentice DBA? in WOxPod!, episode # 003 – The...
The post 003 – The Data Guild appeared first...
2015-05-15
510 reads
I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
507 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