June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – SQL Server Security Whitepapers

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Server Security, SQL White Papers
Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the summary know what is covered in those  white papers. Engine Separation of Duties for the Application Developer – Separation of duties is an important consideration for databases and database applications.…
Read More

SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Security
Recently I have got two desktop computers at home and both of them are very powerful machine. Machine 1 : Windows Vista SP1 with SQL Server 2008 Machine 2 : Windows 2003 with SQL Server 2005 with SP2 When I was trying to connect from SQL Server 2008 to SQL…
Read More

SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download
Note:   Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The…
Read More

SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Joins, SQL Scripts
Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any…
Read More