What is connection pooling and why is it necessary? A connection resource on the database side is essentially the database server process, the session and the associated memory. In order to utilize the database resources effectively and to provide end user concurrency, applications use various reso

(Allan Mitchell) Beginning with SQL Server 2005 Analysis Services, Microsoft introduced a new range of modeling algorithms to be used for data mining, including Sequence Clustering. Along with these algorithms, Microsoft also provides viewers that allow you to see exactly what is going on inside the

(Atif Shehzad) I have read the tip about securing SQL Server backups with a password. It is great option and I am planning to implement it for my production servers on SQL Server 2005 and SQL Server 2008. I am currenlty using a backup plan configured through maintenance plans, but I want to be able

(Siddharth Mehta) This article leverages the examples and concepts explained in the Part I through Part IV of the spatial data series which develops a “BI-Satellite” app.

(Buck Woody) This is part two of a series that I’m covering as a monitoring exercise for longer-running (not necessarily performance-related) activities.

(Jonathan Kehayias) Today Joe Webb (Blog|Twitter) blogged about The Power of Regex in Powershell, and in his post he shows how to parse the SQL Server Error Log for events of interest. At the end of his blog post Joe asked about other places where Regular Expressions have been useful in PowerShell

(Richard Waymire) In the second post about the error logs, we examined the authentication mode and startup parameters. In this third post, we’ll examine the priority, CPU, locking, and node configuration information presented in the SQL Server error logs for Workforce Central. Knowing what informati

(Madhivanan) People use Dynamic SQL for various purposes. One of the disadvantages of it is SQL injection that can attack your database by doing the things that you didn’t want to do.

SQL Azure Database is a cloud-based relational database service from Microsoft. SQL Azure provides relational database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availa

(K. Brian Kelley) I know that in SQL Server 2000 and below, you could assign permissions against objects like tables, views, and stored procedures. I’m hearing in SQL Server 2005 and 2008 there’s a new security model called securables which allow for nestable permissions. How does this work?