Power BI Application Embedding Releases Today
A few weeks ago, the Power BI team gave us the ability to freely embed Power BI reports, dashboards and...
2016-04-01
527 reads
MDX – Putting Visual Totals on top or at the bottom
Dynamically totaling child members
Putting the dynamic totals on top or at the bottom can be a trivial or a big...
2016-03-31
1,232 reads
Ola Hallengren’s solution on a network share using FTP
I use the Ola Hallengren’s maintenance solution for my SQL Servers instances. It happened to run the maintenance solution so that...
2016-03-31
1,010 reads
March MVP – Gareth Swanepoel
The March nomination is Gareth Swanepoel (B|T).
If you don’t know Gareth you should make it a point to get to know...
2016-03-31
782 reads
I hope you didn't miss it!
Warning: This is a really short post.
Today March 31st, BrentOzar.com is giving away their videos! Well, not giving away... but...
2016-03-31
773 reads
2016 PASS Nominating Committee Announced
I was pleased to hear today that I was selected for the 2016 NomCom, along with Joaquin Romero, Erin Stellato,...
2016-03-31
999 reads
SQL Server 2016 Azure Virtual Machines
With the release candidates coming thick and fast for SQL Server 2016 downloading, uninstalling the previous version and installing the...
2016-03-30
1,399 reads
Multiple Tagging of TFS Work Items Using Excel
In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can...
2016-03-30
1,035 reads
When should I test?
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
794 reads
SQL Agent Job Schedules
SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from...
2016-03-29
13 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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