When you have to routinely collect data from Performance Monitor Counters, it soon becomes easier and more convenient to use PowerShell. SQL Server MVP Laerte Junior was inspired to create a script, and guides us through its useful functions.

(Joshua Jones) I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2. This feature, known as Extended Protection for Authentication (Extended Protection, for short), helps secure connections to a SQL Server 2008 R2 server. This fea

(Edwin Sarmiento) As more and more SQL Server instances get installed in my organization by different departments in both servers and desktops, I need to find out where they are as I’ll be responsible for managing and administering these instances. How do I list out all the SQL Server instances acro

(SQL Master) This is a typical error during the connection attempt to a SQL Server 2005 instance, this morning I was faced with similar issue at workplace.

(Suprotim Agarwal) We tend to forget the most basic syntax of all and one of them is to check if a stored procedure exists and then drop it. Here’s the syntax for your reference:

(Carl Nolan) In most applications these days there will always be some form of backend database. So hopefully over the coming months I thought it would be a good idea to share some TSQL bits, starting with using Common Table Expressions (CTEs) for managing DELETE operations.

(Tara Kizer) A while back I wrote a CLR object to track database growth. The CLR object queries sp_databases for each passed in server and saves the data into a table. By using this CLR object, I can track all of my systems in one location. I blogged about this tool in this article.

(Mike Chapple) Conditions are the clauses that you may use to create DMF policies on a management facet. Examples of conditions are usernames, account creation dates and password complexity policies. In this example, we will create a DMF condition that enforces a stored procedure naming policy that

(Andy Novick) User written aggregates have proven very useful for solving a variety of problems that couldn’t be handled easily before they became available in SQL Server 2005. The most useful for me has been the Concatenate aggregate from the article SQL Server CLR function to concatenate values i

(Bart Duncan) This post is about deleting a lot of rows, as you might do in a data archiving or purging task. By “a lot of rows”, I mean anything from a few thousand rows up to billions. This may seem elementary, but there are some surprising problems that can appear if you use a simple DELETE to