Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help to manage multi-server management through automated...
I believe until SQL Server 2000 (or even SQL 2005) it was easy to remember the release version of your SQL Server instance. Since the changes affected from SQL Server Release Services and inception of Cumulative Update packages it is hard to keep a track of list of builds and version releases. Let it...
Posted to
SQLMaster
by
Satya Jayanty
on
01-17-2012
Filed under:
Filed under: dba, sql server, version, cumulative update, release, version control, package, sql master, dba practices, cookbook, blog
All this month let us cook some best practices within SQL Server to become a master SQL chef in your data platform. There is no doubt that SQL Server users have been keeping up their knowledge up to the level since last few years (at least since 2008 version release). In this regard the Upgrade of SQL...
Posted to
SQLMaster
by
Satya Jayanty
on
01-02-2012
Filed under:
Filed under: best practices, sql server, compatibility, upgrade, sql master, community, feature pack, cookbook, discontinued, #sql2k8r2cookbook, deprecated
How to change the default path of .cache files of a data collector after the Management Data Warehouse (MDW has been setup? This was the question asked by one of the DBAs in a client's place, instantly I enquired that were there any folder specified while setting up the MDW and obvious answer was...
I have had the pleasure of knowing and communicating with Mr. Satya Shyam K. Jayanty, aka Satya/aka SQLMaster|twitter for several years now, and found him to be a real genuine person, awesome fellow, professional and chalk full of innate and in-depth knowledge of the workings of SQL Server technology...
It is not uncommon to see the intermittent performance slowdown within your data platform, in order to tackle the problem in early stages you must deploy the proactive practices to minimize the problem. When they occur you will not have time to diagnose the root cause, rather fix the problem and then...
Posted to
SQLMaster
by
Satya Jayanty
on
05-13-2011
Filed under:
Filed under: best practices, sql server, performance monitoring, BRH, recovery, notes, beginners, sql master, configuration, memory, cookbook