SQL Server Security Archives - Page 37 of 47 - SQL Authority with Pinal Dave

SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks

August 18, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security, SQL Transactions

Loyal reader of this blog and “Great SQL Expert” Imran Mohammed always have good attitude towards any problem. Many times his answers very interesting to read and details are very accurate. I came across his two interesting comment on this blog and I would like to share this all of…

SQL SERVER – 2005 – Best Practices Analyzer (August 2008)

August 17, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Download, SQL Server Security, SQL Utility

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. This download is the August 2008 release of…

SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server

August 9, 2008

Pinal Dave

SQL

Database, SQL Error Messages, SQL Server Security

If you are receiving the following error related to connection to SQL Server, this blog is for you.

SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000

August 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL Server Security

If you are still using SQL Server 2000 (you should have upgraded to SQL Server 2005 by now), there is Security Upgrade for Service Pack 4 and MSDE. Download SQL Server 2000 Security Upgrade Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Introduction to Log Viewer

July 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security, SQL Utility

SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQL Server 2000 there was no facility to check System and Application log, however in SQL Server 2005 there is facility of the log viewer. It is very useful tool and very easy…

SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings

July 13, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

It is very good to know our server and its feature which are available for configurations. SQL Server always has many features which can be enabled or disabled. One should at least know what are the options SQL Server provides. This blog post we will learn how to display or change global configuration settings.

SQL SERVER – 2008 – User Account – sa or sysadmin

July 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server, SQL Server Security

Just a day ago, I noticed ‘sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ‘sa’ account. ‘sysadmin’ is actually replacement for legacy ‘sa’ account. ‘sa’ still exist in SQL Server 2008, however, it will be deprecated in future versions of SQL Server. It is recommended to all the users who switch to SQL Server 2008 to start migrating to ‘sysadmin’ from ‘sa’.