Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
43 reads
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
47 reads
Notes From The August 13, 2015 Spacecoast SQL Meeting
Meeting is held at Sonny’s BBQ, they have a long room (used to be outside seating) that works pretty well...
2015-08-17
625 reads
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one 2008. The 2012 project referenced the 2008 project as...
2015-08-17
13 reads
Notes From the August 12, 2015 oPASS and MagicPASS Meeting
Meeting held at Nova Southeastern here in Orlando Arrived early to meet David Pless, good thing we were early – couldn’t...
2015-08-17
651 reads
Tracking S&P 500 Using Power BI
S&P 500 index is an American stock market index consisting of 500 large companies and is considered to be the...
2015-08-17
2,695 reads
Pulling data from the error log
The other day I was asked to pull a list of errors from the SQL Server log into a table...
2015-08-25 (first published: 2015-08-17)
3,457 reads
Data corruption in SQL Server 2012 and 2014 when rebuilding indexes online
When I hear the discussion about causes of data corruption in SQL Server, I always mention bugs in the operating...
2015-08-17
2,009 reads
Buffer Pool Extension in SQL Server 2014
I guess many have heard the phrase «640K ought to be enough for anybody», which Bill Gates is mistakenly thought...
2015-08-17
1,758 reads
How to find CPU intensive queries ?
HI all
Today received the mail from RED-GATE team on this topic “How to find CPU intensive queries” . It is an...
2015-08-24 (first published: 2015-08-17)
10,425 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