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

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

SQL Sever 2017 – Resumable Online Index Rebuild

Hello Friends,

As a Database Administrator for big size databases, we generally face the issue of small maintenance window for performing index maintenance operations. We keep trying to our business management for allowing us more maintenance window time but sometimes Business/management does not allow us for a longer maintenance window. Finally somehow, we do the […]

By |August 26th, 2017|Categories: Database Administration, Database Maintenance, Indexes & Statistics|Tags: , |Comments Off on SQL Sever 2017 – Resumable Online Index Rebuild

DPS 2017 Speaker Announcement – Ramu Raghavan, Presales Head, HPE, India

Dear Data/Analytics Geeks,

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

Join us in welcoming the Presales Head from HPE, India

Ramu Raghavan

 

 

 
 

 

 
 

Please join us in welcoming Ramu Raghavan, who will join the DataPlatformGeeks team for the first time.

Ramu Raghavan serves as Presales Head – Servers, the technical selling force at Hewlett […]

By |August 11th, 2017|Categories: SQL Conference||Comments Off on DPS 2017 Speaker Announcement – Ramu Raghavan, Presales Head, HPE, India
Newsletter_Footer