Find and Remove Duplicate Records SQL Server
Learn a quick method to find and remove duplicate records in your SQL Server tables.
What is the True Version of Code?
What version of your code is the true one? Steve Jones talks some version control today.
The PoSh DBA - Towards the Re-usable PowerShell Script
When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for creating scripts. Laerte Junior explains how, when and why it pays to think in terms of versatile functions to meet varying demands.
Using the Statistical Program R for Running Statistics
This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.
The SQL Server 2016 Query Store: Built-in Reporting
One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is performing, either aggregated for the entire query workload or for a single query. With this information, you can see the effects of 'forcing' an execution plan for specific queries and get feedback of the consequences.
A Review of rsNeatPublish
rsNeatPublish: Toolset to automate deployment of all SSRS 2008R2/12/14/16 objects
Training at the Top
Today Steve Jones looks at security training and the need for understanding from upper management.
Using PowerShell for SQL Server Replication Tracking
Tim Smith shows how using PowerShell can be an effective way to track SQL Server snapshot and transactional replication counts for sources and destinations.
Automate Alerting for SQL Server Suspect Database Pages
We suspect there are some issues with our disk subsystem and would like to be alerted by email if SQL Server encounters any corruption in any of the data files that reside on the disk in question. How can we add this automated monitoring?
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