Database Engine Tuning Advisor
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...
2015-05-26
828 reads
SQL Agent Job Wrapper Part 3 – Handing the Errors in the Wrapper Script
This is the 3rd installment in a small series of blog posts on how to create a PowerShell wrapper for...
2015-05-26
697 reads
Default database
What?
The default database is one of the options when creating a login in SQL Server. This is the initial database...
2015-05-26
1,086 reads
Microsoft Azure SQL Database – Dashboard
By David Postlethwaite
Once you have created your database you can now start to manage and configure it.
There are six...
2015-05-26
860 reads
SQL Server 2016 features I’m interested in
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
501 reads
SQL Server 2016 features I’m interested in
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
1,365 reads
Row Numbers and Running Totals in SSIS
During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL...
2015-05-26
3,302 reads
Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4
Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored...
2015-05-26
339 reads
4 Things You’ll Need Before Installing a Failover Cluster Instance
Your servers are either provisioned or racked, your sys admin has taken care of installing the Failover Clustering feature and...
2015-05-25
500 reads
Changing NULL to NOT NULL – Dealing with Data
I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple...
2015-05-25
672 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