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

SQL SERVER – Find Current Location of Data and Log File of All the Database

February 17, 2009

SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL System Table

As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in SQL Server data installation folder – the place where I have all the .mdf and .ldf files are stored. I often go to that folder and clean up all unnecessary…

SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup

February 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Backup and Restore, SQL Data Storage, SQL Server Security, SQL Utility

The most interesting thing about writing blog at SQLAuthority.com is follow up question. Just a day before I wrote article about SQL SERVER – Restore Master Database – An Easy Solution, right following it, I received email from user requesting reason for importance of backing up master database. Master database…

SQL SERVER – Restore Master Database – An Easy Solution

February 14, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL Utility

Today we will go over two step easy method to restore ‘master’ database. It is really unusal to have need of restoring the master database. In very rare situation this need should arises. It is important to have full backup of master database, without full backup file of master database…

SQL SERVER – Start SQL Server Instance in Single User Mode

February 10, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio, SQL Server Security, SQL Utility

There are certain situation when user wants to start SQL Server Engine in “single user” mode from the start up. To start SQL Server in single user mode is very simple procedure as displayed below. Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on…

SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation

January 25, 2009

Pinal Dave

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

SQL Data Storage, SQL Scripts, SQL Server DBCC, SQL Server Security

Just a day ago I have received following email from Siddhi and I found it interesting so I am sharing with all of you. Hello Pinal, I have seen many blogs from you on SQL server and i have always found them useful and easy to understand. Thanks for all…

SQLAuthority News – CWE/SANS TOP 25 Most Dangerous Programming Errors

January 19, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Error Messages, SQL Server Security

I just came across very interesting article from SANS Institute. Experts from more than 30 US and international cyber security organizations have released list of 25 most dangerous programming errors and their resolution. It may be possible that many of the programmers may not understand what this errors are and…

SQLAuthority News – Security White Papers

January 10, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download, SQL Server Security, SQL White Papers

Microsoft Dynamics AX 2009 White Paper: Configuring Kerberos Authentication with Role Centers This document describes how to configure Kerberos authentication with Enterprise Portal and Role Centers. Kerberos authentication is required to display reports created using Microsoft SQL Server Reporting Services and Microsoft SQL Server Analysis Services on Role Center pages.…