Log in | Register

Setup & Configuration Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Setup & Configuration Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Setup & Configuration

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

SQL Server 2016 – Temporal Tables Part 3

Hello Friends,

In my previous blog posts about temporal tables, we have seen three different ways for the creation of a temporal history table. First was the default where SQL Server create the table and assign a default name to that table. Second was where we specify the name of that table and SQL Server […]

By |July 23rd, 2016|Categories: Database Administration, Database Development, Database Engine, Setup & Configuration|Tags: , |Comments Off on SQL Server 2016 – Temporal Tables Part 3

SQL Server 2016 – Trace Flag 1117 Changes

Hi Friends,

My today’s blog post is focused on trace flag 1117 changes in SQL Server 2016. We all know that there are multiple trace flags in SQL Server. These trace flags are generally used to change the default behavior of SQL Server. One of these trace flag is 1117. This trace flag is generally […]

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

By |April 10th, 2016|Categories: Database Administration, Performance, Setup & Configuration|Tags: , |Comments Off on SQL Server 2016 – Instant File Initialization

SQL Server 2016 – Model database default settings

Hi Friends,

Many improvements and new features are there in the SQL Server 2016. One of that change is about the model database default settings in SQL Server 2016. We know that the model database plays an important role just like a template while we are creating a new database over that instance. By default […]

By |March 21st, 2016|Categories: Database Administration, Database Maintenance, Setup & Configuration|Tags: , |Comments Off on SQL Server 2016 – Model database default settings

SQL Server 2016 – New SERVERPROPERTY properties

Hi Friends,

I hope that most of us uses SERVERPROPERTY in SQL Server to collect various information about the Instance. I used SERVERPROPERTY most of the time when I got a new server added to my responsibility list. This is also very useful to collect the Instance information before and after the patching activity. Microsoft has […]

By |February 28th, 2016|Categories: Database Administration, Setup & Configuration|Tags: , |Comments Off on SQL Server 2016 – New SERVERPROPERTY properties

Max Server Memory – A Tale of Seven Wonders – Wonder 4

Hello Geeks,

Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]

By |December 30th, 2015|Categories: Database Administration, Database Maintenance, Memory, Setup & Configuration|Tags: , , , |Comments Off on Max Server Memory – A Tale of Seven Wonders – Wonder 4

ADMIN? – A Tale of Seven Wonders – Wonder 2

Hello Geeks,

Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]

By |December 10th, 2015|Categories: Database Administration, Security and Encryption, Setup & Configuration|Tags: , , , , , |Comments Off on ADMIN? – A Tale of Seven Wonders – Wonder 2

SQL Server – Cluster resource ‘SQL Server’ in clustered service or application ‘[ServerName] (MSSQLServer)’ failed.

Install SQL 2005 cluster on Windows 2008 R2. It’s always a new issue. Most of them are known. But last night I installed SQL server 2005 cluster on Windows 2008 R2 64bit and the setup almost completed successfully. Little did it know that the Network name was not coming online and it did not […]

By |February 18th, 2015|Categories: Setup & Configuration, SQL Server|Tags: , , , |Comments Off on SQL Server – Cluster resource ‘SQL Server’ in clustered service or application ‘[ServerName] (MSSQLServer)’ failed.

sql server trace flag 3226

Hi Friends,

This is my 11th blog on SQL Server Trace Flag 3226 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

In my working experience I have seen many servers where we have more than 20 databases on a single SQL instance. For […]

By |October 3rd, 2014|Categories: Backup, Restore and Recovery, One Trace Flag a Day, Setup & Configuration|Tags: , , |Comments Off on sql server trace flag 3226

sql server trace flag 3505

Hi Friends,

This is my 8th blog on SQL Server Trace Flag 3505 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

Trace Flag 3505 is related to SQL Server Checkpoint. I hope we all are aware of checkpoint in SQL Server. Those who […]

By |September 30th, 2014|Categories: Database Administration, One Trace Flag a Day, Setup & Configuration|Tags: , |Comments Off on sql server trace flag 3505
Newsletter_Footer