Aug 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download Microsoft SQL Server 2005 Assessment Configuration Pack

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL Utility
Microsoft SQL Server 2005 Assessment Configuration Pack for Gramm-Leach Bliley Act (GLBA) This configuration pack contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 servers in order to support your Gramm-Leach Bliley Act compliance efforts. Microsoft SQL Server 2005 Assessment Configuration Pack…
Read More

SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Utility, SQL White Papers
Note :  Download Whitepaper by Microsoft Find out how SQL Server 2005 powers a 27 TB data management system called ICE 3.0 that gathers forensic data from more than 85 Microsoft corporate proxy servers into a single database. The Information Security team at Microsoft uses an internal tool called Information…
Read More

SQLAuthority News – Best Articles on SQLAuthority.com

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks
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
SQL SERVER – Cursor to Kill All Process in Database SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure SQL SERVER – Shrinking Truncate Log File – Log Full SQL SERVER – Simple Example of Cursor SQL SERVER – UDF – Function…
Read More

SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Security, SQL Utility
Microsoft has turned off all the potential features of SQL Server 2005 that could be susceptible to security risks and hacker attacks. Many features of SQL Server 2005 i.e. xp_cmdshell, DAC etc comes disabled by default, this makes the vulnerable surface area less visible to potential attacks. The Surface Area…
Read More

SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SQL Utility, SSMS

Following images quickly explain how to connect to SQL Server with different connection property. It can be useful when connection properties need to be changed for SQL Server when connected. I use this in my company when I connect to one of our servers using named pipes instead of TCP/IP. Let us learn about Connection Property of SQL Server Management Studio SSMS.

Read More