PowerShell gives DBAs a reason to begin using SMO for real, so now we'll find out about all the gory details I was talking to a good friend at Microsoft last week, telling him about the problems I’ve ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

Manually closing and disconnecting [!INCLUDEssNoVersion] Management Objects (SMO) objects is not required. Connections are opened and closed as required. To use any code example that is provided, you ...

There are server event types that can be subscribed to by using an event handler and the xref:Microsoft.SqlServer.Management.Common.ServerConnection object. Many of the instance classes in ...

Microsoft® SQL Server® 2012 SP4 Analysis Management Objects AMO (Analysis Management Objects) est un modèle objet de Microsoft .NET Framework qui permet aux développeurs de logiciels de créer des ...

Last time we discussed creating a script that can retrieve configuration settings from a list of SQL Servers and placing that data into a SQL Server table. Now, let's take a look at another technology ...

Microsoft® SQL Server® 2012 SP4 Feature Pack est un ensemble de packages d’installation autonomes améliorant la valeur de Microsoft® SQL Server® 2012 SP4. Il inclut les dernières versions des : Outil ...

La création d’une table dans SQL Server s’apparente à un casse-tête, surtout si vous débutez dans le développement de base de données. En plus des colonnes qui forment la table, vous devez définir les ...