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?

Row Level Security in SQL Server 2016

Row Level Security in SQL Server 2016 – Allow access to Subset of Records.

There might be requirement to provide security at the record or row level, you will able to do this Row Level Security feature that is introduced with newer version of SQL Server i.e.; SQL Server 2016. In this post, I […]

By |September 20th, 2016|Categories: SQL Server||0 Comments

SQL Sever 2016 – DBCC CHECKDB WITH MAXDOP

Hello Friends, There are lots of feature and improvements announced by Microsoft in SQL Server 2016, one of them is restricting the number of processors for DBCC CHECKDB. We know that MAXDOP setting is generally taken care by Instance level setting ‘MAX Degree of Parallelism’ under advanced tab of server property. I’ll show you the […]

SQL Server Always ON and Change Data Capture: Friends or Foes?

I talked about Always ON and Change Data Capture in one of the Open Talks at recently concluded SQLServerGeeks Annual summit – 2016. The topic of discussion was Always ON and Change Data Capture: Friends or Foes? I thought its worth a write as well because this combination is very less talked about.

Let me […]

By |September 16th, 2016|Categories: SQL Server||2 Comments

Read-Write Concurrency in SQL Server Analysis Services

Hello Friends and Geeks,

I write this blog when the tallest Ganesh of Hyderabad is on the way for Immersion.

Coming to the topic for this post

Most of us know, how read/write concurrency and locking works with SQL Server Database Engine.

Ever wondered what would be the locking pattern for Processing and Querying concurrency for SQL Server Analysis Services (SSAS)

The […]

By |September 15th, 2016|Categories: SQL Server||0 Comments

Index Usage Analysis on databases with AlwaysON Secondary Readable Replica

Hi Friends and Geeks,

I write this blog at a time when traffic in Hyderabad has come to a stand-still owing to incessant rains since morning today.

Coming to the topic of this blog-post, we know how important it is to identify unused indexes and rarely used non clustered indexes to reduce the IO foot print of […]

By |August 31st, 2016|Categories: SQL Server||0 Comments

SQL Server 2016 – SQL Server checkpoint

Hi Friends,  In today’s blog post we will learn about the importance of SQL Server checkpoint and changes in SQL Server 2016. I’ll start with some basics.

How SQL Server works?

To understand the checkpoint, it’s important to understand the working of SQL Server. Let’s say, I want to update a few records of a table in […]

How to resolve High Compilations/Second problem in SQL Server

Hi Friends and Geeks!

Sharing an experience on resolution of High Compilations/Second performance counter in SQL Server from one of my consulting assignments.

The threshold for Compilations/Second is mentioned as 10% of Batch Requests/Second by various MVPs and in our case it was around 40 to 50%

Investigation Process

Investigate for queries with same query_hash but multiple plan_handles using […]

SQL Server 2016 Trace Flag 2371 Change

Hello Friends,

In SQL Server 2016, we have seen that various trace flag related changes. For example, changes related to trace flag 1117 and 1118. This blog post focused on SQL Server 2016 – Trace Flag 2371 Change. Today, I’ll show you the changes related to trace flag 2371.

Those who don’t know about trace flag 2371 this trace […]

By |August 20th, 2016|Categories: SQL Server||2 Comments

Easiest way to install additional packages in SQL Server R Services

Beginners coming to SQL Server R Services would find it a bit difficult to understand the integration of R and SQL Server. Bob Ward has provided a great insight into the SQL Server R Services Architecture in the recently concluded #SSGAS2016 summit.

When I started exploring this feature, the first bottleneck I faced was the installation […]

By |August 16th, 2016|Categories: SQL Server||0 Comments

SSGAS 2016 July Price Extended

SQLServerGeeks is for the community, by the community.

SSG Team that includes Amit, Manohar, Ahmad, Surbhi, Avanish, Sandip, Yogesh, Vignesh, Prince & Jay have contributed in more than one ways to serve the community, especially the SQL community.

And something unprecedented has happened. SSG Team got more than a dozen emails from SQL community members that […]

By |July 22nd, 2016|Categories: Conferences, SQL Server|Tags: , , |0 Comments
Newsletter_Footer