Download links for the Microsoft SQL Server 2005 Assessment Configuration Pack for GLBA, SOX and FISMA, to validate server settings for compliance.
SQL SERVER – Export Data From SQL Server to Microsoft Excel Datasheet
How to export data from SQL Server to Microsoft Excel? Enable Ad Hoc Distributed Queries, create the Excel file, and run a short query to fill it.
SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool
How SQL Server 2005 powers ICE 3.0, the Microsoft forensic data security tool that gathers data from more than 85 proxy servers into one 27 TB database.
SQLAuthority News – Best Articles on SQLAuthority.com
Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility
A list of my best articles so far, from killing all processes in a database and shrinking the log file to deleting duplicate rows and UNION vs UNION ALL.
SQL SERVER – 2005 – Driver for PHP Community Technology Preview (October 2007)
Microsoft released the SQL Server 2005 Driver for PHP CTP, a free PHP 5 extension to read and write SQL Server data. I include the install steps.
SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation
SQL Server 2005 ships with risky features off. The Surface Area Configuration tool turns them on or off, and here is what replaced it later.
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
How to change connection properties in SSMS as you connect, like using named pipes instead of TCP/IP, as I do for one of our servers. Screenshots show each step.