Search SQL Server content

SSGAS 2016 Speaker Announcement – Nagaraj Venkatesan – SQL Server Enthusiast from Singapore

Dear SQL Geeks, Brace yourself as we announce the fourteenth speaker of SSGAS 2016! The SQL Server Enthusiast and Expert from Singapore. Join me in welcoming Nagaraj Venkatesan Please join me in welcoming Nagaraj Venkatesan to the second edition of Asia’s largest SQL Conference, the one who needs no introduction in the SQL world, yet […]
Read More »

SSGAS 2016 Speaker Announcement – Deepthi Anantharam – Sr Technology Evangelist at Microsoft

Dear SQL Geeks, Brace yourself as we announce the thirteenth speaker of SSGAS 2016! The Senior Technology Evangelist for Data Platform and Cloud from Microsoft. Join me in welcoming the returning speaker from SSGAS2015. Deepthi Anantharam Please join me in welcoming Deepthi Anantharam to the second edition of Asia’s largest SQL Conference. I want to […]
Read More »

SQL Server 2016 – sys.dm_exec_input_buffer

Hi Friends, DBCC INPUTBUFFER() is the TSQL command that we generally use to find out the submitted statement to the SQL Server Instance. Sometimes I use this command to troubleshoot the blocking scenario. If I know the session id of blocking and blocked session, then I can easily find out the TSQL statement/command passing that […]
Read More »

SSGAS 2016 Speaker Announcement – Aniruddha Deswandikar – Head, Microsoft Technology Center, India

Dear SQL Geeks, Brace yourself as we announce the twelfth speaker of SSGAS 2016! The Head of Microsoft Technology Center, India. Join me in welcoming the returning speaker from SSGAS2015. Aniruddha Deswandikar Please join me in welcoming Aniruddha Deswandikar to the second edition of Asia’s largest SQL Conference, the one who needs no introduction in […]
Read More »

SSGAS 2016 Speaker Announcement – Siva Harinath – Principal Program Manager, Microsoft

Dear SQL Geeks, Brace yourself as we announce the eleventh speaker of SSGAS 2016! A Principal Program Manager from Microsoft. Join me in welcoming the BI expert. Siva Harinath   Please join me in welcoming Siva Harinath to the second edition of Asia’s largest SQL Conference, the one who needs no introduction in the SQL […]
Read More »

SSGAS 2016 Speaker Announcement – Devashish Salgaonkar. Sr. Premier Field Engineer, Microsoft

Dear SQL Geeks, Brace yourself as we announce the tenth speaker of SSGAS 2016! A senior PFE from Microsoft. Join me in welcoming the SQL all-rounder. Devashish Salgaonkar Please join me in welcoming Devashish Salgaonkar to the second edition of Asia’s largest SQL Conference, the one who needs no introduction in the SQL world, yet […]
Read More »

SQLServerGeeks Annual Summit 2016 - Meet the blog experts

As an IT professional, For me, Blogs are the great source of learning. By reading at least one or two blogs daily, I try to enhance or improve my knowledge. I joined my first job in April 2010. The challenge for me to learn the new things. During my day to day activities at work, […]
Read More »

SQL Server 2016 – Database Scoped Configurations

Hi Friends, As a DBA, we know about various Instance level settings in SQL Server like MAXDOP, Cardinality Estimator related changes and various Trace Flags etc. There may be some scenarios where you want to enable these kind of settings at the database level rather than instance level. For Example, I want to set MAXDOP […]
Read More »

SSGAS 2016 Speaker Announcement – Dr. Subramani Paramasivam, MCT & Principal Consultant from UK

Dear SQL Geeks, Brace yourself as we announce the ninth speaker of SSGAS 2016! Another returning speaker from SSGAS2015. Join me in welcoming the community enthusiast from the UK. Dr. Subramani Paramasivam (Mani) Please join me in welcoming Dr. Subramani Paramasivan to the second edition of Asia’s largest SQL Conference, the one who needs no […]
Read More »

Want to be a SQL Pro? Learn from the best & get career advice too

The elites and successful from every industry have few things in common. They understand that the surest way to achieve success is to model someone who is already successful. If you don’t have good models, find someone who is the best in your chosen field and emulate them. I understood this through years of my industry […]
Read More »

SSGAS 2016 Speaker Announcement – Silvia Doomra – PM in Azure SQL DB at Microsoft

Dear SQL Geeks, Brace yourself as we announce the eighth speaker of SSGAS 2016! The Azure SQL Database Program Manager from Microsoft. Join me in welcoming the Azure SQL DB Expert. Silvia Doomra Please join me in welcoming Silvia Doomra to the second edition of Asia’s largest SQL Conference. I want to take the privilege […]
Read More »

Comparing Apples To Oranges

I penned down one of my observations regarding SQLMaestros Master Classes & SQLServerGeeks Annual Summit 2016, just to show how some SQL folks are comparing the two learning events, which of course, they should not be doing. Since the post is about both the brands, I posted it on my personal website. Read here.
Read More »

SQL Server 2016 – truncation of specific partition

Hi Friends, Till now we have seen various new improvements in SQL Server 2016. In my previous blog posts, I had explained Trace Flag 1117 and 1118 related changes. Today I am going to show you an another improvement in SQL Server 2016 i.e. truncation of specific partition or the number of partitions. Before SQL […]
Read More »

The Power of Networking

Networking is to interact with others to exchange information and develop professional and social contacts. This statement itself speaks about the power of networking. We do network with people in our day to day life in offices, gym, meetings, malls and other public places. However, this isn’t professional networking. We meet, we talk and we […]
Read More »

SQL Server 2016 -- Polybase (External Tables) and Azure Blob Storage

What is PolyBase? In this Article, we will discuss new feature called PolyBase with Microsoft SQL Server 2016. Why Microsoft has introduced in the SQL Server and why it is needed. If you see from Data Warehouse scope is progressing and we see that there is an increasing volume of data from a lot of […]
Read More »

SSGAS2016 - Expand your Horizon - Be a Hero at your Work

What is happening for SSGAS2016 We are still living the excitement from SSGAS2015. Time waits for none and it is already the time of the year where we have started full-fledged preparations for the Asia’s largest Data Platform Conference – SQLServerGeeks Annual Summit 2016, SSGAS2016. The speaker lineup is already a blast and we have […]
Read More »

SQL Server Database Mail – It’s vaster than you think

SQL Server Database mail, since its inception in SQL Server 2005, has been a very important part of DBA’s daily life. This is the main part of your automatic alert generation system and this saves you a lot of work in day to day life. You don’t have to go to the servers one by […]
Read More »

The more you learn, the more you earn!

“The more you Learn, The more you earn” – quote by Frank Clark, always inspires me to strive for new learning and implement those learning into my routine life irrespective of personal or professional. Being a decade old SQL Server professional, experienced a wide spectrum of SQL Server versions from 2000 to 2016 (Wow! 7 […]
Read More »

SQL Server 2016 - Instant File Initialization

Hi Friends, Today, I am going to show you an interesting thing about SQL Server 2016 – Instant File Initialization. We all knew about the Instant file Initialization feature. For those who are not aware about it can click here. As a DBA, we know the importance of this feature. Instant File Initialization feature helps […]
Read More »

SSGAS 2016 Speaker Announcement – Satya Jayanty : the Returning DBA Master from SSGAS2015

Dear SQL Geeks, Brace yourself as we announce the seventh speaker of SSGAS 2016! The returning DBA Master from SSGAS2015. Join me in welcoming the 11 year Data Platform MVP and a community enthusiast from the UK. Satya Jayanty Please join me in welcoming Satya Jayanty to the second edition of Asia’s largest SQL Conference, […]
Read More »

Older