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,150 reads
Wait Stats Baseline Comparison – Idera Diagnostic Manager
Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes something changes without our knowledge and is running differently...
2016-02-22
28 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