Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find it easy to learn, powerful, and reasonably intuitive. This article explains the attraction of Python and gives a general introduction to the language, suitable for anyone who has been wondering whether to give it a try.
Why don't we emphasize the huge advantages of parameterized queries over ad-hoc queries in SQL Server? There is a severe impact on resources and performance from repeatedly using similar ad-hoc queries, instead of reusing the existing query plans. This article shows how you can measure this impact, and springs a surprise or two in the process
The most flexible way to bulk-load data into SQL Server is to use SSIS. It can also be the fastest, and scaleable way of doing so. There are three different components that can be used to do this, using SSIS, so which do you choose?
This article provides an architectural overview of SQL Azure Database, compares it with SQL Server and describes how you can use SQL Azure to augment your existing on-premises data infrastructure or as your complete database solution.