(K. Brian Kelley) I have a requirement to periodically audit for members of the sysadmin role across all my servers. I’d like to automate this and I’ve heard PowerShell is a good match. In order to feed a downstream governance application, I’d like to simply output the members into text files. How c

(Michael K. Campbell) In Part VII of this series on SQL Server Database corruption we touched upon how backups can be used as an additional means of early detection for corruption – by making sure to validate the checksums of all data being backed up.

(Mike Chapple) SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the number of rows in a table. Alternatively, a WHERE clause can be included to restrict the counting to specific records.

(Melissa Coates) A quick tip about how to manage data source connections within a SharePoint PowerPivot Gallery.

(Pedro Azevedo Lopes) If you follow this blog, this is another post on VLFs, a topic I’ve covered several times before. If you want to read more about it just click here. Also, all scripts in the VLF posts have been updated to support SQL server 2012.

(Michael J. Swart) I think most of you have all been here before. You want to know the results of a query, but you have to get it from a colleague through email or some other proxy:

(Anthony Zanevsky, Andrew Zanevsky and Katrin Zanevsky) The monochrome text output that T-SQL provides by default isn’t very impressive, especially to business analysts and other end users. Although you can use the geometry data type introduced in SQL Server 2008 to add images and colors to T-SQL ou

(Pinal Dave) SQL Server Management Studio is my most favorite tool and the comfort it provides to user is sometime very amazing. Recently I was retrieving numeric data in SSMS and I found it is very difficult to read them as they were all right aligned.

(Dattatrey Sindol) Typically when working in Sales and Marketing Departments, every individual or group of individuals are given a Target for each year. All of these targets rolls up to the company’s targets. Often companies will have one or more standard scorecards / dashboards to monitor the overa

(Kaarthik Sivashanmugam) Integration Services catalog (SSISDB) uses the encryption mechanism available in SQL Server to protect its sensitive data. So backup and restore of SSIS catalog across machines need some extra steps in addition to the usual backup and restore steps. This post describes all t