Log in | Register

SQL Server Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education SQL Server Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SQL Server

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

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

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

DPS 2017 Speaker Announcement – Sriharsha Narasimhan, CTO, Mission Critical Solutions, HPE, India

Dear Data/Analytics Geeks,

Brace yourself as we announce the next Speaker of DPS 2017.

Join us in welcoming the CTO, Mission Critical Solutions from HPE, India

Sriharsha Narasimhan

 

 

 
 

 

 
 

Please join us in welcoming Sriharsha Narasimhan, who will join the DataPlatformGeeks team for the first time.

Sriharsha Narasimhan is Chief Technology Officer for Mission Critical Solutions, HPE
Servers. His […]

By |August 10th, 2017|Categories: SQL Server||Comments Off on DPS 2017 Speaker Announcement – Sriharsha Narasimhan, CTO, Mission Critical Solutions, HPE, India

DPS 2017 Speaker Announcement – Pranab Mazumdar , Embedded Escalation Engineer, Microsoft, India

Dear Data/Analytics Geeks,

Brace yourself as we announce the next Speaker of DPS 2017.

Join us in welcoming the Embedded Escalation Engineer from Microsoft, India

Pranab Mazumdar

 

 

 
 

 

 
 

Please join us in welcoming Pranab Mazumdar, who will join the DataPlatformGeeks team for the first time.

Pranab Mazumdar is currently working as an Embedded Escalation Engineer for the Microsoft […]

By |August 10th, 2017|Categories: SQL Server||Comments Off on DPS 2017 Speaker Announcement – Pranab Mazumdar , Embedded Escalation Engineer, Microsoft, India

DPS 2017 Speaker Announcement – Rahulinder Singh, Software Engineer, Microsoft, India

Dear Data/Analytics Geeks,

Brace yourself as we announce the next Speaker of DPS 2017.

Join us in welcoming the Software Engineer from Microsoft, India

Rahulinder Singh

 

 

 
 

 

 
 

Please join us in welcoming Rahulinder Singh, who will join the DataPlatformGeeks team for the first time.

Rahul is a Computer Science graduate, joined Microsoft 4 years ago as Software Engineer. […]

By |August 4th, 2017|Categories: SQL Server||Comments Off on DPS 2017 Speaker Announcement – Rahulinder Singh, Software Engineer, Microsoft, India
Newsletter_Footer