Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
All Articles sac6

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 – Pre-Code Review Tips – Tips For Enforcing Coding Standards

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Coding Standards, SQL Scripts
Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change the code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep…
Read More

SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Ranking Functions, SQL Function, SQL Scripts
I have not written about this subject for long time, as I strongly believe that Book On Line explains this concept very well. SQL Server 2005 has total of 4 ranking function. Ranking functions return a ranking value for each row in a partition. All the ranking functions are non-deterministic.…
Read More
All Articles connection3-416x400

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

SQLAuthority News – Latest Interesting Downloads and Articles

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL White Papers
White Paper: Precision Considerations for Analysis Services Users This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due…
Read More

SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Utility
This article is written by request and suggestion of Sr. Web Developer at my organization. Due to nature of this article most of the content are referred from Book On-Line. sqlwb command prompt utility which opens SQL Server Management Studio. sqlwb command does not run queries from command prompt. sqlcmd…
Read More