A Script A Day - Day 4 - Estimated Time Left
Today's script allows you to keep track of how long left a statement has before it completes. I find this useful...
2012-02-04
492 reads
Sarasota IT Pro Camp
Join system administrators IT professionals and database professionals in addition to managers at all levels who work with Microsoft technologies...
2012-02-04
939 reads
Dundas Dashboard – My observations
Dundas Data Visualization Inc, is well-known to SSRS developers. Microsoft had earlier acquired their SSRS controls (Charts, Gauges & Map) and integrated...
2012-02-04
1,569 reads
List SQL Server Instances using Powershell and Get-ItemProperty
This post explains how to list SQL Server Instances installed on the current server, using the Powershell Get-ItemProperty Cmdlet.
The Get-ItemProperty...
2012-02-04
2,673 reads
Delivering Three PTI SQL 2012 Firestarter Webcasts
I have been given the opportunity to deliver a few webcasts about some of the new features of SQL Server...
2012-02-03
1,359 reads
..This operation must be performed in the master database."
"Cannot alter a server audit from a user database. This operation must be performed in the master database."
If you're trying...
2012-02-03
1,089 reads
Re-blog – January 27 – February 2
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-03
577 reads
Slowly Changing Dimensions
When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make. It...
2012-02-03
1,236 reads
How to output from invoke-sqlcmd to Powershell variable
Sorry for another Powershell post but I’ve been doing a lot of it recently and coming up with (what i...
2012-02-03
21,144 reads
Magazines I Read This Year
In December I went through my current magazine list and made some changes, mostly based on what I had been...
2012-02-03
643 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