Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Chad Miller

SQLServerCentral.com profile

   Items 1 to 12 of 12   
 

Database Space Capacity Planning

Describes a process to create a consolidated space forecasting report, which focuses on a "days remaining" metric.  Read more...
By Chad Miller 2009/10/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 12,440 reads

Backup Monitoring and Reporting

Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.   Read more...
By Chad Miller 2009/06/04 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 12,915 reads

Getting Data out of SQL Server from Powershell

In the first article, we learned how to move data into SQL Server. This time Chad Miller shows us how we can use Powershell to extract data out of SQL Server.  Read more...
By Chad Miller 2009/01/02 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 15,131 reads

Loading Data With Powershell

Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.  Read more...
By Chad Miller 2011/05/13 (first published: 2008/12/16) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 25,744 reads

SQL Server PowerShell Extensions (SQLPSX) Part 2

In part two of his series on Codeplex extensions to Powershell for SQL Server, Chad Miller talks more about the functions in the project and how you can integrate with Reporting Services.  Read more...
By Chad Miller 2008/10/08 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 7,514 reads

SQL Server PowerShell Extensions (SQLPSX) Part 1

Powershell is the new management interface for scripting and working with SQL Server that is integrated into Windows 2008 and SQL Server 2008. The author of a Codeplex project introduces some extensions that try to make it easier to use Powershell with SQL Server.  Read more...
By Chad Miller 2008/10/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 16,685 reads

Windows Utilities for the SQL Server DBA

This article is a short summary of Windows utilities both GUI and command line intended for new SQL Server DBAs or those interested in learning some useful techniques.   Read more...
By Chad Miller 2006/09/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 17,993 reads

Conducting a SQL Server Operational Audit

Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.   Read more...
By Chad Miller 2005/10/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,175 reads

Use SQL-DMO and Excel to Quickly Create Reports for Auditors

Auditing SQL Server, or any system, is not an easy task and with new regulations like Sarbanes-Oxley, it is becoming a full time job in some environments. Chad Miller brings us a way that he developed with Excel and some scripting to automate some of the security information for a large installation of SQL Servers.   Read more...
By Chad Miller 2005/10/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,137 reads

Dump SQL Permissions

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.   Read more...
By Chad Miller 2004/03/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,649 reads

Troubleshooting Cannot Generate SSPI Context Errors

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.   Read more...
By Chad Miller 2005/08/19 (first published: 2003/02/27) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 65,337 reads

Getting Rid of Excessive Files and Filegroups in SQL Server

Although there are legitimate reasons for using filegroups, Chad Miller recently encountered a situation where they were used too much. He shows you in this article why and how to remove excessive filegroups.   Read more...
By Chad Miller 2003/02/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,852 reads
   Items 1 to 12 of 12