SQL Server 2008 Archives - Page 3 of 3 - Blog dbi services
Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.
During our test to create a failover clustering with the new function ‘AlwaysOn High Availability’, we had a few difficulties to overcome like the restoring of databases of the secondary cluster node.
In this article, we will just explain you how to avoid it before you encounter the problem.
dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.
The property of Spare columns is not the most used in client environment that we have seen.
This article present a script to find the potential columns that can have the sparse property with the usage restrictions to make a space tuning in your database and especially for Data Warehouse (DWH).
The database example that we used, is AdventureWorksDW2008R2.
In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services.
When Integration Service is installed with the instance “TOTO” and that it is at the end of his life, we’ll see how to transfer information to the second instance “TITI”. We present you a small working method to transfer information correctly.
Only the folders transfert is presented in this article and the transfert of the SSIS packages are explained at the end.
By dbi services, we are a few poeples passionate by diving.
We take this opportunity to let you dive into the two databases lakes Oracle and SQL server and see their similarities and differences. For this first level of diving (named ODD), we will not going too deep and not have narcosis or
As always, we’ll start with a short briefing to present the environment and the different themes.
Have a nice dive !
SQL server 2008 has PowerShell and at the end of this article, I speak of this topic but to use correctly Powershell, you must have a basic notion about this technologie.
In microsoft Techdays in Basel, Marc van Orsouw presents Powershell.
I think it was a nice opportunity to presents you an overview of Powershell based on this
presentation with adding microsoft msdn web site commentar.