How to Convince the Boss to Send You to PASS Summit
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...
2016-05-02
998 reads
Remove files from a filegroup
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...
2016-05-02
1,666 reads
SQL 2016 - The Time Has Come!
Microsoft dropped it on us this morning:
Get ready, SQL Server 2016 coming on June 1st
https://media.makeameme.org/created/yes-finally.jpg
I read the article and was...
2016-05-02
937 reads
Why you should think about upgrading to SQL Server 2016!
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading...
2016-05-01
10 reads
Why you should think about upgrading to SQL Server 2016!
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide...
2016-05-01
3,092 reads
SQL Server 2005 Modernization Checklist
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...
2016-05-01
554 reads
Power BI Box and Whisker visualization vs. Box Plot chart in SSRS
[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...
2016-04-30
4,364 reads
3 Things I Wish I Knew When I Started Using Entity Framework
Entity Framework (EF) is Microsoft's object-relational-mapping tool (ORM) that allows programmers to easily map database objects to C# object models. What attracts developers to Entity Framework is the automatic...
2016-04-30
18 reads
Big Data architectures
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...
2016-05-12 (first published: 2016-04-29)
3,134 reads
Possible PARAMETER SNIFFING Scenario in SQL
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to...
2016-05-11 (first published: 2016-04-29)
3,706 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