Track and Report SQL Server Database Space Usage with this App
C Sharp application you can easily create to keep track of how much space your largest SQL Servers and databases are using.
Bernard is a relative newcomer to blogging and the SQL community. You could say he's been off the grid and only rarely ventures out on Facebook. He has worked as a programmer/DBA for Memorial Hospital in South Bend, IN since 1993, where he authored a surgery reservation system that was in use for over 10 years. Prior to that he worked for Carleton Finanacial Computations and wrote software for companies such as the Ohio Division of Consumer Finance and Chrysler Finance.
Inventory SQL Server Environment for Service Accounts, Versions, Ports
PowerShell script that can help you quickly inventory all of your SQL Servers in your environment to get service accounts, version, ports and more.
SQL Server DBA Utility Dashboard
Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.
Quick and Simple CSharp Windows Form
In this article we look at how you can build a simple CSharp Windows Form to query SQL Server and return results to the application.
Encrypting SQL Server Backups for Legacy Systems
In this article we look at how to encrypt SQL Server backup files for systems where SQL Server does not support backup encryption.
Finding and Cleaning Up Old SQL Server Job Log Files
Due to SQL Server sprawl, you may have hundreds of servers that may be accumulating job logs that you are unaware of. You may have HUNDREDS of THOUSANDS of job log files floating about. It would take days to go thru hundreds of servers and their log direc
Checking SQL Server Database Backups When You Don’t Have Access
I have a new vendor installed application along with SQL Server. Since the data is confidential, the vendor won't give me access, but I still want to know that backups are occurring on a regular basis. Read this tip on the approach I came up with to mak
Collect Database and Table Index Grow Statistics for all SQL Servers Using PowerShell
You want to collect growth statistics on your databases and report on them. Management would like to see how fast databases are growing. Users would like to know how big their main tables are becoming. You have over a hundred servers with thousands of dat