SQLServerCentral Article on Backup Monitoring and Reporting
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,320 reads
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,320 reads
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.
2009-01-02
21,305 reads
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.
2008-10-08
7,732 reads
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.
2008-10-06
17,763 reads
2008-09-11
415 reads
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-08-27 (first published: 2008-02-15)
2,557 reads
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.
2007-10-02 (first published: 2003-02-27)
68,687 reads
Perl script that reports SQL Server AD accounts which are now longer valid by verifying the output of sp_validlogins system stored procedure against SID stored in AD. This is done to ensure only accounts that do not exist are reported since sp_validlogins will only check the name and not SID against AD. Accounts that are […]
2007-02-12 (first published: 2006-08-08)
240 reads
XSLT Stylesheet to produce developer/object oriented html report from SQL Server 2005 Upgrade Advisor xml report file. Name the script sqlupad.xsl and insert the following as the first line in the xml Upgrade Advisor report file. Place sqlupad.xsl file in same directory as the xml report. This stylesheet works against Database Server component reportonly, does […]
2007-01-17 (first published: 2007-01-03)
178 reads
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.
2006-09-07
18,269 reads
I recently received a complaint that Query Store for a particular database was turned...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers