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

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

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

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

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

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

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

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

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

Newsletter_Footer