Log in | Register

SQL Server Blog - SQLServerGeeks.com SQL Server Blog - SQLServerGeeks.com

Blog

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk

In this video, you will understand the following concepts: SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Memory Clerk

You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).

All DPG members (membership is free) have free access to many learning resources including in-person events, […]

By |December 20th, 2017|Categories: SQL Server Videos||0 Comments

Free SQL Video – How to Troubleshoot a Slow Running Query in SQL Server (Extended Events & Wait Stats)

In this video, I am demonstrating how to track waits stats for a given query/session using Extended Events.

You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).

All DPG members (membership is free) have free access to many learning resources including in-person events, webinars, […]

By |December 14th, 2017|Categories: SQL Server Videos||0 Comments

Free SQL Video – Session Level Waits and Task Level Waits

In this video, I am demonstrating the difference between session level waits and task level waits.

You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).

All DPG members (membership is free) have free access to many learning resources including in-person events, webinars, past event […]

By |December 8th, 2017|Categories: SQL Server Videos||0 Comments

Free SQL Video – SQL Server Wait Types, Queues & Wait Statistics

In this video, I am demonstrating a few common wait types in SQL Server.

You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code).

All DPG members (membership is free) have free access to many learning resources including in-person events, webinars, past event resources, videos, […]

By |December 4th, 2017|Categories: SQL Server Videos||0 Comments

SQL Server 2017 (on Linux) in Mac Docker – Part 3

Hello Friends!

In continuation to my previous 2 blogs (Part 1, Part -2) on same topic, this is last in series. I’ll continue my experiment with SQL Server 2017 (on Linux) sitting on Mac Dockers. So far everything is working as expected and it’s time now to have a real fun with Microsoft Visual Studio […]

By |November 1st, 2017|Categories: SQL Server||0 Comments

SQL Server 2017 (on Linux) in Mac Docker – Part 2

Hello Friends!

In continuation to my previous blog, I’m going to showcase how Docker images works hand to hand with containers.

As you saw my docker is able to sense the SQL Server 2017 image, let’s go ahead and create a container from it which is running instance of the image.
Setting Up a “Container” From the […]

By |October 28th, 2017|Categories: SQL Server||0 Comments

SQL Server 2017 (on Linux) in Mac Docker – Part 1

Hello Friends!

SQL Server 2017 is launched about a month back and created a lot of excitement around data platform professionals and IT world. Lot of organisations are looking towards it as a promising product for their open source environment where SQL Server wasn’t used to get fit due to platform dependency.

It’ been a while […]

By |October 25th, 2017|Categories: SQL Server||0 Comments

Explore statistics histogram using SQL Server 2017

Prior to SQL Server 2016 SP1 CU2, we need to use DBCC SHOW_STATISTICS WITH HISTOGRAM to read Statistics histogram of a specific statistics. Since it is a DBCC command in order to filter any information or if you want to join with another table, we first need to save the out to a table.

Below […]

Data Files moving from On-Premises to Azure Data Lake Store using Azure Data Factory

Azure Data factory is a cloud based Data Integration Service that Orchestrates and automates the Movement and transformation of data.

Step 1: I will place the multiple .csv files in the local drive in the “D:\Azure Data Files\InternetSales” as shown in the below screen shot

Step 2: I will create an Azure Data Lake store in […]

By |September 28th, 2017|Categories: SQL Server||0 Comments

SQL SERVER 2017 – IDENTITY_CACHE

When we define a table with Identity column, SQL Server might cache the identity values to improve performance. Due to server restart or database failure some assigned values may be lost.  If your application required to have consecutive values, then having identity column was the right choice prior to SQL Server 2017.

You need to […]

Newsletter_Footer