Installation of SQL Server (Part 1 - Pre-installation)
I have been wanting to write this for a long time, and finally got time to do it. Which is...
2016-02-29 (first published: 2016-02-23)
2,754 reads
Shrink a log file…AUTOMATICALLY?
Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First...
2016-02-25 (first published: 2016-02-22)
2,635 reads
SSRS 2016 – Part 2 New Features for Paginated Reports
This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the...
2016-02-22
1,132 reads
Memory Fundamentals for SQL Server - SQL Server Memory Components, SQL Server Memory Logical Tree
In the Previous blogs we have seen about virtual memory related concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.html
We came across concepts like Address Window Extension, Physical...
2016-02-24 (first published: 2016-02-22)
4,090 reads
Adding Minutes in Excel
A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out...
2016-02-26 (first published: 2016-02-22)
1,915 reads
Why Is The Server Slow?
This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...
2016-02-24 (first published: 2016-02-22)
2,848 reads
T-SQL Tuesday #75: Round Up
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...
2016-02-22
31 reads
T-SQL Tuesday #75: Round Up
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...
2016-02-22
26 reads
T-SQL Tuesday #75: Round Up
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of...
2016-02-26 (first published: 2016-02-22)
1,559 reads
You are not logged on as the database owner or system administrator.
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify...
2016-02-22
1,151 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
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