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?

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||Comments Off on SQL Server 2017 (on Linux) in Mac Docker – Part 3

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||Comments Off on SQL Server 2017 (on Linux) in Mac Docker – Part 2

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||Comments Off on SQL Server 2017 (on Linux) in Mac Docker – Part 1

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 […]

By |October 7th, 2017|Categories: Performance Tuning, Programming, Query Tuning, SQL Server, Transact-SQL|Tags: , , , , , |Comments Off on Explore statistics histogram using SQL Server 2017

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||Comments Off on Data Files moving from On-Premises to Azure Data Lake Store using Azure Data Factory

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 […]

By |September 25th, 2017|Categories: Programming, SQL Server, Transact-SQL|Tags: , , , |Comments Off on SQL SERVER 2017 – IDENTITY_CACHE

SQL Server 2017 New String Function – CONCAT_WS

String manipulation is one of the common requirement for every project. There are many String functions already available in SQL Server but in SQL Server 2017 has some more string functions which ease the developer’s life. CONCAT_WS string function is one of them.

CONCAT_WS :

It concatenates a variable numbers of strings using the first argument as […]

By |September 16th, 2017|Categories: Programming, SQL Server, Transact-SQL|Tags: , , |Comments Off on SQL Server 2017 New String Function – CONCAT_WS

SQL Sever 2017 – Resumable Online Index Rebuild Parameters

Hello Friends,

In my previous blog post, we have learned about the importance and use of Resumable Online Index Rebuild Operation. In today post we will learn about the various parameters those we can use or we should consider while using this feature. First let me show you the syntax for Alter Index Rebuild operation […]

By |September 2nd, 2017|Categories: Database Administration, Database Maintenance, Indexes & Statistics|Tags: , |Comments Off on SQL Sever 2017 – Resumable Online Index Rebuild Parameters
Newsletter_Footer