Excel Power Map vs. Power BI Globe Map visualization

[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...

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

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

Microsoft Azure Stack in Preview!

Microsoft made available the first technical preview of its new Microsoft Azure Stack offering today.  It was announced last week.  Azure...

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

View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!

Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power...

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

Database Log VLFs

Transaction logs are split into VLFs which affects performance. How large are yours and what does that mean for you?

Database Log VLFs

Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files...

Impersonation can give you the wrong answer

I use impersonation all the time to let me see additional permissions information I can only get that way and,...