Infrastructure at your Service

Microsoft Archives - Page 18 of 19 - Blog dbi services

Stéphane Haby

SQL Server 2012: Feature Pack

By | Database Administration & Monitoring | 2 Comments

Since the third CTP version of SQL Server 2012 codename Denali, you have some features available to provide an additional value for Microsoft® SQL Server 2012 like the other SQL Server versions. This Feature Pack or Manageability Tool Kit are available but are not the final version. I have compiled all information in this blog to find it easily.

All DBA should know that Feature Pack exists, how to find it and of course use it.Wink

Read More
Stéphane Haby

Forefront Endpoint Protection (FEP) 2010 and database policies

By | Database management | No Comments

I have seen at a customer that the SQL Server’s policy doesn’t follow the Microsoft’s recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn’t exist in case of Forefront Endpoint Protection 2010 known as FEP 2010.

I have decided to create databases policies for FEP optimized by dbi services to be generic and adapted to all SQL Server and Oracle environments.

Read More
Stéphane Haby

SQL Server 2012 ‘Denali’: a new panel of DMVs

By | Database management | One Comment

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.

Read More
Stéphane Haby

SQL Server Tuning: Detect SPARSE columns candidate

By | Application integration & Middleware | 6 Comments

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.

Read More
Stéphane Haby

Diving into Databases

By | Database Administration & Monitoring | 3 Comments

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

databases toxicity.
As always, we’ll start with a short briefing to present the environment and the different themes.
Have a nice dive !

 

“BRIEFIIING !”

Read More