Debug Managed Code and Stored Procedures Seamlessly
Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing...
2015-05-18 (first published: 2015-05-06)
6,228 reads
Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing...
2015-05-18 (first published: 2015-05-06)
6,228 reads
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...
2015-05-06
195 reads
In what spare time I’ve had this week, I’ve been watching the news coming out of Microsoft Ignite (formerly Tech...
2015-05-06
4,742 reads
Most people prefer to have “sa” account as the database owner, primary reason being sa login cannot be removed/deleted unlike any...
2015-05-05
393 reads
If you’re in the Iowa City area, come to Iowa Code Camp this weekend! They have a great lineup of speakers, covering...
2015-05-05
413 reads
Intro
AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...
2015-05-15 (first published: 2015-05-05)
6,858 reads
As a DBA , migration of database is a part of day to day activities. sometime its a quite hectic task...
2015-05-05
16,766 reads
Earlier this year, my buddy Dan recommended that I read The Checklist Manifesto: How to Get Things Right. The recommendation...
2015-05-05
533 reads
It was announced yesterday at the Ignite conference that we’ll be getting a summer preview of SQL Server 2016. With...
2015-05-05
678 reads
My recent post on using the new DiskSpd utility to help you benchmark your storage is a great primer on how...
2015-05-14 (first published: 2015-05-05)
7,672 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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