Define IOPs for all database servers
Purpose
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations.
He’s asked me...
2011-08-22
2,117 reads
Blog Posts
Expert? Ha!
How do you define an expert? My personal definition: An expert is the person that is a chapter ahead of...
2011-08-22
1,248 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
Networking Dinner at the PASS Summit 2011
We’re repeating our event this year, a low key no sponsor dinner for those that arrive early and want to...
2011-08-22
680 reads
Outstanding DBAs Make Relationships a Priority
In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to...
2011-08-22
1,034 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes...
2011-08-22
685 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only...
2011-08-22
7 reads
SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features
sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:
- Compression,
- Partitioning,
- TDE and...
2011-08-22
1,376 reads
Tracking down KPI error in PerformancePoint
On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:
So...
2011-08-22
776 reads
T-SQL to find Fragmented Indexes
Fragmentation of Indexes is one of the reason for low performing queries resulting in a poor application performance.
Today, I will...
2011-08-22
7,521 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