How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-06-04 (first published: 2014-05-28)
2,007 reads
NodeXL – Accessible Network Graph Analysis, part 3 (Twitter)
This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.
If you are interested,...
2014-05-27
378 reads
How Much Value Would a SQLSaturday Certificate of Completion Have?
Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two,...
2014-05-27
709 reads
Webcast Follow-Up: 5 SQL Server Indexing Myths
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-05-27
901 reads
Attaching All Databases with PowerShell–Checking All Databases
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-05-27
1,311 reads
Building The SQLSaturday Orlando Marketing Plan-Part 13
Here is the second of the two flyers I ordered from fiverr.com (see the first one here). The center image...
2014-05-27
551 reads
Get User In Reporting Services-Question of the Day
Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”....
2014-05-27
511 reads
SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014
This event promises to be a highlight of the Canadian SQL Server calendar year.
The presenters are all 'first class'.
All...
2014-05-27
816 reads
NodeXL – Accessible Network Graph Analysis, part 2
This is the second blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.
If you are interested,...
2014-05-26
293 reads
Useful Links for learning & using in Data Quality Projects in SQL Server
Data Quality Services in SQL Server is a component that is based around the concept of knowledge-driven quality.
Here comes a...
2014-05-26
202 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