Log in | Register

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

Database Administration

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

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

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

Resumable Online Index Rebuild- SQL Server 2017

Resumable online index rebuild is one of the very useful feature of SQL Server 2017 for DBA’s. Now it is possible to pause an Index Rebuild. It allows to resume an online index rebuild operation from where it is stopped or paused. Below are some scenarios where you may need to pause your index […]

Database Scoped Configurations and Trace flag 4199

Those who are working on query performance whether you are a DBA or Developer I am sure you guys must have used trace flag 4199.  TF 4199 enables all query optimizer related fixes.Microsoft used to have separate TF for each hotfix applied to query optimizer prior to SQL Server 2005 Service Pack 3 (SP3) Cumulative […]

By |April 16th, 2017|Categories: Database Administration, Database Development, Performance, SQL Server, Transact-SQL|Tags: , , , |Comments Off on Database Scoped Configurations and Trace flag 4199

SQL Server 2016 – sys.dm_db_incremental_stats_properties for Incremental Stats

Hello Friends,

During various troubleshooting scenarios, we generally check the statistics information on the objects. These statistics information helps us a lot to detect the root cause. There is a DMF that we use to check the statistics information i.e. sys.dm_db_stats_properties. This DMF requires the object id and stats id to return the details.

SQL Server […]

By |April 7th, 2017|Categories: Database Administration, Database Development, Indexes & Statistics|Tags: , |Comments Off on SQL Server 2016 – sys.dm_db_incremental_stats_properties for Incremental Stats

Rightly Estimating the Azure DTU

As the move to Azure getting popular for SQL Server, the adoption involves a step to understand the costs associated with the migration – The measure of an Azure DTU. Yes, the most under-explained term of the Azure world. Azure DTU is the term, heard so often and yet, unless shown on your bill, very […]

By |April 3rd, 2017|Categories: Database Administration, Performance|Tags: , , , , |Comments Off on Rightly Estimating the Azure DTU

DBCC CloneDatabase

This blog was due from a long time.  With the release of SQL Server 2014 Service pack 2, a new DBCC command included that is DBCC CloneDatabase. My primary job role is to do query tuning and I was looking for this kind of functionality. Using this command, it is quite easy   to copy […]

By |March 15th, 2017|Categories: Database Administration, Performance, Transact-SQL|Tags: , , |Comments Off on DBCC CloneDatabase

Step by Step Guide to Install, configure and Run R script in SQL Server 2016

Microsoft acquired Revolution Analytics in 2015 and integrated R in SQL Server 2016.Today I will show you how to install, configure and run R script in SSMS. Like all other Microsoft software installation of R is pretty easy. You just need to run the set up and with few click on Next button will […]

By |February 28th, 2017|Categories: Database Administration, SQL Server, Transact-SQL|Tags: , , |Comments Off on Step by Step Guide to Install, configure and Run R script in SQL Server 2016

New Security Features In SQL SERVER 2016 – PART 1

Data Security in any application is vital. Different business or application  has their own security policy.  SQL Server 2016 provides three new security features which helps to protect data.

Below there are new security features added in SQL Server 2016.

Row-Level Security (RLS)
Dynamic Data Masking (DDM)
Always Encrypted

In this part of blog, we will see use case […]

By |February 1st, 2017|Categories: Database Administration, Security and Encryption, Transact-SQL|Tags: , , , |Comments Off on New Security Features In SQL SERVER 2016 – PART 1

Trace Flag 634 – Disable Background Columnstore Compression

Hi Friends,

In Columnstore Technology, we knows that Column data stores in segments and segments groups together to form the rowgroup. One of the main reason of using Columnstore technology is compression of rowgroups. By default, SQL Server perform compression of closed delta stores. This tasks is done by tuple mover. Which invokes after a […]

By |December 26th, 2016|Categories: Compression, Database Administration, Indexes & Statistics, Performance|Tags: , |Comments Off on Trace Flag 634 – Disable Background Columnstore Compression
Newsletter_Footer