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?

DPS 2017 Speaker Announcement – Mr.Thilakan, Technologist- Sales Engineering, Enterprise Storage Solutions for SanDisk India.

Dear Data/Analytics Geeks,

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

Join me in welcoming the Technologist- Sales Engineering, Enterprise Storage Solutions for SanDisk India.

SK Thilakan

 

 

 

 

 

 

Please join me in welcoming Thilakan, who will join the DataPlatformGeeks Team for the first time.

Mr.Thilakan is Technologist- Sales Engineering for the Data Center […]

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

DPS 2017: 75 New Sessions Added. More Stalwarts Announced. (June Updates)

Less than 50 days are left for Data Platform Summit 2017 Curtain Raiser! DPS team is prepped-up to meet you & our new delegates this August at NIMHANS Convention Center, which is Bangalore’s largest centralized air-conditioned convention Center. And thanks to The Government, for DPS 2017, it has been renovated :) – Yes, DPS […]

By |June 25th, 2017|Categories: SQL Conference, SQL Server||Comments Off on DPS 2017: 75 New Sessions Added. More Stalwarts Announced. (June Updates)

DPS 2017: Session List Released (Part 1), New Pre-Cons & New Speakers Announced (May Updates)

We are happy to announce the first release of Session List (Part 1) for DPS 2017. 5 New Pre-Conference seminars are also added. Here are May 2017 updates:

DPS 2017 Session List (Part – 1):

Release 1. Release Date: May 24, 2017. Count: 50 Sessions
This is ONLY Release 1 with 50 sessions. Multiple releases will happen […]

By |May 28th, 2017|Categories: SQL Conference, SQL Server||Comments Off on DPS 2017: Session List Released (Part 1), New Pre-Cons & New Speakers Announced (May Updates)

SQL Sever 2017 – Smart Transaction Log Backup

Hello Friends,

SQL Server 2017 CTP 2.1 has been announced with some new features, one of them is Smart transaction log Backup i.e. exposing the log in mb since last log backup. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post […]

DPS 2017 Speaker Announcement – Sandy Winarko, Principal Program Manager, Data Integration, Cloud & Enterprise, Microsoft

Dear Data/Analytics Geeks,

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

Join me in welcoming Principal Program Manager – Microsoft, China

Sandy Winarko

Please join me in welcoming Sandy Winarko, who will join the DataPlatformGeeks Team for the first time. 

Sandy is a seasoned Product Manager with extensive experience in the US, Europe, and Asia, combining commercial/technical […]

By |May 12th, 2017|Categories: SQL Conference, SQL Server||Comments Off on DPS 2017 Speaker Announcement – Sandy Winarko, Principal Program Manager, Data Integration, Cloud & Enterprise, Microsoft

DPS 2017 Speaker Announcement – Dr Sheela Siddappa, Global Delivery Head – Data Analytics

Dear Data/Analytics Geeks,

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

Join me in welcoming Data Analytics, Global Delivery Head from Bosch

Dr Sheela Siddappa

Please join me in welcoming Dr Sheela Siddappa, who will join the DataPlatformGeeks Team for the first time. 

Dr. Sheela Siddappa heads the Global Delivery for Data Analytics program at Bosch India. […]

By |May 8th, 2017|Categories: SQL Conference, SQL Server||Comments Off on DPS 2017 Speaker Announcement – Dr Sheela Siddappa, Global Delivery Head – Data Analytics

Configure SQL Server vNext – New utility new methods.

[mssql-conf] – A command line utility to reconfigure SQL Server vNext on Linux
Hello Friends!

In my previous post I listed down how to install & use SQL Server vNext on Linux. However, configuration is an important piece and thought to talk about in detail.

Traditionally we use SQL Server configuration manager to do a lot of […]

By |May 8th, 2017|Categories: SQL Server||Comments Off on Configure SQL Server vNext – New utility new methods.

SQL Server – ROW_NUMBER versus TOP N

Hello Friends,

This blog post is the result of question asked by some professionals working on databases. While writing T-SQL code they generally use TOP N in the code to get the top n number of rows in the result set. They knew the another way to achieve the same result by using ROW_NUMBER. Now the […]

By |May 7th, 2017|Categories: Database Development, Performance, SQL Server, Transact-SQL|Tags: , |Comments Off on SQL Server – ROW_NUMBER versus TOP N

Compare Query plan using SSMS

Recently Microsoft released SSMS 17.0. This release of SSMS supports SQL Server 2017 for both running on Windows and Linux. In this release Microsoft has added new features as well as improved some existing features. One of them is to Compare Query plan.

You can download latest SSMS 17.0 here

This is helpful where you have […]

By |May 6th, 2017|Categories: Programming, SQL Server, Transact-SQL|Tags: , |Comments Off on Compare Query plan using SSMS

SQL Server 2017 – Smart Differential Backup

Hello Friends,

SQL Server 2017 CTP announced with lots of new features to help database professionals. One of that feature is Smart Differential Backup i.e. exposing the modified extent page counts. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post we […]

By |May 6th, 2017|Categories: Backup, Restore and Recovery, Database Administration, SQL Server|Tags: , |Comments Off on SQL Server 2017 – Smart Differential Backup
Newsletter_Footer