Building The SQLSaturday Orlando Marketing Plan–Part 9
I’ve heard more than once that Meetup.com is a good way to reach new people so we’re looking at how...
2014-05-21
700 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
565 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
1,205 reads
Quick Tips – SQL Prompt Stop the Yelling
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-21
2,013 reads
DBA Myths: A table with a primary key is not a heap
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,653 reads
Why Won't My Clustered Instance Start?
Last weekend I had a client page me in the middle of the night (because, of course, these things always...
2014-05-21
2,623 reads
Cumulative Update – 10 for SQL Server 2012 Service Pack 1 Is Now Available !
The 10th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-05-21
994 reads
Attaching All Databases with PowerShell – The Overview
TL;DR Script is here: Git Hub Powershell Scripts. It’s the attachdbs.ps1 and will attach all databases in a folder to...
2014-05-20
1,685 reads
Varchar "miracle" and best practice
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
672 reads
Running Out of Foreign Keys-Question of the Day
Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...
2014-05-20
343 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