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...

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...

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...

Adding Minutes in Excel

A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out...

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...

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!...

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!...

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...

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...

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...