The Jarvis–Standing Desk Update

I started using a standing desk a few years back. While visiting the Redgate Software office, I saw one of...

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

DBCC Just Runs Faster, Unless You’re Cheap

The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales...

HP Superdome X for high-end OLTP/DW

No, Superdome X is not the name of the stadium where they played in the last Super Bowl.  Rather, Superdome...

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

SQL 2012 Identity Columns Feature

Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this...

Well that’s just neat: Row Level Security, new in SQL Server 2016

SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while,...

Grabbing Fitbit Data

Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.
I saw Rob Farley build a...

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

Powershell script to create multiple SQL Server Connections

As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...