VMware vExpert 2016 Announcement

What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...

and other pointless query rewrites

In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...

and other pointless query rewrites

In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...

How Much Hospitals Charge For The Same Type Of Cases?

Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...

Spring Training: Developing SQL Queries for SQL Server

Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries...

Memory Fundamentals for SQL Server - Process-Thread Model, CPU execution model, CPU scheduling, CPU Architechture, SQLOS

Until now we have seen the windows memory addressing concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.html

So how exactly are user applications like SQL server assigned to...

Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported

Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...

Upcoming SQL Saturday Precon Sessions (Update!!!!)

Wow, Power BI is making a tidal wave in the BI industry.  New features are being released regularly and blog posts...

Monday Morning SQL Break – February 8, 2016

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...

Introduction to SQL Server: The Main Components

There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a...