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?
Analysis Services databases must serve a large population of users, and it is best to exploit a scale-out approach: distribute the querying load across multiple hosts, each of which has a copy of the same database. Although database administrators have several options for ensuring that all SSAS instances have the same data, the built-in synchronization method is an effective, easy to implement solution. Database administration expert Baya Dewald shows how built-in synchronization works and how it compares to other approaches. The article also discusses troubleshooting and tuning synchronization performance.