A Script A Day - Day 3 - Live Change Data Edit Template
Today's script is a template I use for the occasions when a data edit is required to be run against...
2012-02-03
572 reads
Pragmatic Works Has Balls...SQLBalls
http://www.flickr.com/photos/54296260@N05/6036813377/
That is right Dear Reader, I am making the jump, Starting Monday February 6th I will be a Sr. Consultant...
2012-02-03
924 reads
Recovery Modals in SQL Server
Being a SQL Server DBA, one should be able to understand how many recovery modals do we have in SQL...
2012-02-03
820 reads
AMD 2012-2013 Server Roadmap
AMD had their 2012 Financial Analyst Day today, which is basically a dog and pony show for stock analysts.
Previously,...
2012-02-03
1,179 reads
Verifying Last Successful CheckDB with Powershell and SMO - sorta
A few years ago, I wrote a script that was published on SQLServerCentral.com about how to verify the last successful...
2012-02-03
1,726 reads
2012-02-03
548 reads
PowerPivot for Excel Install Issues
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
993 reads
2012-02-02
8 reads
2012-02-02
12 reads
2012-02-02
14 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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