Coca-Cola and #SQLSat 111
Got some great news today! Turns out Sarah (Blog | @DanceM0m) and I will be heading to Atlanta in a couple...
2012-02-17 (first published: 2012-02-14)
1,613 reads
SSRS – Embedding Refreshable Reports in Office Tools
Have you ever experienced this?
You have developed a set of Reporting Services report that your users love and they often...
2012-02-20 (first published: 2012-02-14)
2,704 reads
Your Road to Becoming a DBA: Getting Organised
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-02-17 (first published: 2012-02-13)
2,343 reads
Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly
SSIS Expressions
Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables,...
2012-02-16 (first published: 2012-02-13)
4,284 reads
Sarasota IT Pro Camp
The first Sarasota IT Pro Camp is being held on Saturday, February 18th 2012 from 9:00 am to 5:00 pm...
2012-02-13
628 reads
SQL Server 2012 (“Denali”): Contained Databases
A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure,...
2012-02-15 (first published: 2012-02-13)
2,936 reads
Battery Life–The Hidden Cost of Keeping a Laptop
I’ve had my Dell E6500 for about 3-1/2 years now. I’ve recently upgraded the original (back when a SSD was...
2012-02-13
854 reads
Using Powershell to Deploy Performance Monitor
As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight...
2012-02-13
2,849 reads
USB/Flash Drive Security
Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...
2012-02-15 (first published: 2012-02-13)
2,216 reads
Blogsy and my iPad
So this is just a short post to test how well I can type and use Blogsy. If it works...
2012-02-13
690 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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