Infrastructure at your Service

Microsoft Archives - Page 18 of 18 - Blog dbi services

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
Stéphane Haby

A brief PowerShell 2.0 overview

By | Database management | No Comments

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.

 
Read More