SQL Server – Deploying Multiple SSIS Packages into SQL Server Using Command Prompt Utility – DTUTIL
Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using...
2013-11-04
779 reads
Building The Redneck Treadmill Desk
Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of...
2013-11-08 (first published: 2013-11-04)
3,981 reads
UK SQL Relay 2013 R2 Plus Travel Info for London and Southampton
Throughout November, SQL Relay R2 2013 is taking place in the UK. This is the 2nd series of events this year. SQL Relay is a series of 1 day...
2013-11-04
15 reads
Last Weeks Top “Reading” Links #56
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-03
941 reads
SQL Saturday #255 Dallas 2013 - SQL Server Permissions and Security Principals
500+ IT pros at UT-Arlington this weekend for SQL Saturday #255 Dallas!
Notes from today:
A big shout-out to SQLSat Dallas organizer...
2013-11-03
716 reads
SQL Server–Security Risk Assessment PMP Way
Recently I had a chance to speak my friend Ashish Sharma who is my colleague too. We were discussing Project...
2013-11-02
1,176 reads
PASS SQL Saturday Events : November 2013
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2013-11-02
501 reads
PASS SQL Saturday Events : November 2013
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2013-11-02
615 reads
Announcing the SQLpassion Academy 2014 Course Schedule
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Time flies by,...
2013-11-02
854 reads
PASS Virtual Chapter Events : November 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-11-02
511 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers