Detect Worst Performing SQL Queries – Part 2
This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL...
2012-01-31
1,514 reads
Tabular Model
One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model...
2012-01-31
3,506 reads
Orlando IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.
2012-01-31
1,786 reads
SQL Server 2012 Express RC
The new version of the lovely SQL Server edition, Express Edition!
Take a look the new link for the download and...
2012-01-31
3,244 reads
When DBCC INPUTBUFFER disappoints
Today we have an alert from one of the client server about blocking, I have immediately start looking at it...
2012-01-30
1,733 reads
Breaking Down TempDB Contention (part 2)
Breaking Down TempDB Contention (part 2)
Tempdb Contention via Idera Diagnostic Manager
I wrote a somewhat popular script and blog post a...
2012-01-30
3,030 reads
Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,597 reads
The affordable self-service BI revolution has started.
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been...
2012-01-30
1,890 reads
Complex reporting off a SSAS cube
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,354 reads
The Idera ACE Program, So Far
The Idera ACE program is something I’ve been involved with for over a year now. I’ll share a bit of...
2012-01-30
1,673 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