How to Recover Data From Corrupted Log File In SQL Server ?
Introduction
SQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used...
2016-04-26
4,653 reads
PASS – A Business Case for Attendance
[read this post on Mr. Fox SQL blog] For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say that’s a huge number!) the PASS Summit provides...
2016-04-25
10 reads
PASS – A Business Case for Attendance
[read this post on Mr. Fox SQL blog]
For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say...
2016-05-06 (first published: 2016-04-25)
2,467 reads
Cumulative Updates Every 2 Months
The SQL Server team is implementing an Incremental Servicing Model (ISM) to deliver updates for SQL Server. This is basically a...
2016-04-25
605 reads
Explicitly using tempdb with ##tables
I had someone ask me last night if this statement would create a permanent table in tempdb with a strange...
2016-04-25
1,702 reads
Monday Morning SQL Break – April 25, 2016
It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s...
2016-04-25
519 reads
Upcoming Florida IT Pro Camps
Two IT Pro Camps coming up, register soon!
IT Pro Camp – Jacksonville FL – June 11 at Keiser UniversityIT Pro Camp – Tampa...
2016-05-05 (first published: 2016-04-25)
1,034 reads
Get your SQL Server MCSA without taking the BI exam.
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new...
2016-04-25
1,838 reads
Partition to Filegroup Mapping in SQL Server
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition...
2016-05-05 (first published: 2016-04-25)
2,841 reads
Speaking at SQLSaturday Pensacola
I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday event and I’m really excited that I get to...
2016-04-23
11 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