Blogs about: Sql Security
Featured Blog
SQL SERVER - 2008 - Policy-Based Management - Create, Evaluate and Fix Policies
This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful d… more →
Journey to SQL Authority with Pinal Dave
SQL SERVER Interview Questions
nagarajreddy321 wrote 2 weeks ago: What is the difference between clustered and a non-clustered index? A clustered index is a special t … more →
SQLAuthority News - Using SQL Server 2008 Extended Events - White paper By Jonathan Kehayias
pinaldave wrote 3 weeks ago: Strange it may sound but being a SQL Server pro has its downside too. Common information on SQL does … more →
SQL SERVER - Find Hostname and Current Logged In User Name
— 4 comments
pinaldave wrote 1 month ago: I work in an environment wherein I connect to multiple servers across the world. Time and again, my … more →
SQL SERVER - FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
— 1 comment
pinaldave wrote 2 months ago: Just a day ago, one of my friend sent me email requesting help with following error: is not a valid … more →
SQL SERVER - Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
— 10 comments
pinaldave wrote 2 months ago: SQL Server 2005 and SQL Server 2008 provide encryption as a new feature to protect data against hack … more →
SQL SERVER - FIX : Error: 18486 Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. - Unlock SA Login
— 3 comments
pinaldave wrote 2 months ago: Today, we will riffle through a very simple, yet common issue – How to unlock a locked “ … more →
SQL SERVER - Check if Current Login is Part of Server Role Member
— 2 comments
pinaldave wrote 2 months ago: I often work on consulting projects with umpteen clients from across the globe. The nature of the wo … more →
SQL SERVER - Fix : Error : Msg 9803, Level 16. Invalid data for type "numeric" - Data Type Mapping for Oracle Publishers
— 4 comments
pinaldave wrote 2 months ago: My present article talks about an error that you will encounter when connecting to Oracle database u … more →
SQL SERVER - 2008 - Activity Monitor is Empty - Fix Activity Monitor for All Users
— 3 comments
pinaldave wrote 3 months ago: This article is outcome of the technical discussion of activity monitor and its behavior with my fri … more →
SQL SERVER - Disable Windows Authentication - Remove Windows Authentication Login Account
— 3 comments
pinaldave wrote 4 months ago: I just received following email from one of the blog reader. Question : “How to disable Window … more →
SQL SERVER - Find Current Location of Data and Log File of All the Database
— 2 comments
pinaldave wrote 4 months ago: As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in SQL S … more →
SQL SERVER - Reasons to Backup Master Database - Why Should Master Database Backedup
pinaldave wrote 4 months ago: The most interesting thing about writing blog at SQLAuthority.com is follow up question. Just a day … more →
SQL SERVER - Restore Master Database - An Easy Solution
— 2 comments
pinaldave wrote 4 months ago: Today we will go over two step easy method to restore ‘master’ database. It is really un … more →
SQL SERVER - Start SQL Server Instance in Single User Mode
— 2 comments
pinaldave wrote 4 months ago: There are certain situation when user wants to start SQL Server Engine in “single user” … more →
SQL SERVER - Shrinking NDF and MDF Files - A Safe Operation
— 1 comment
pinaldave wrote 5 months ago: Just a day ago I have received following email from Siddhi and I found it interesting so I am sharin … more →
SQLAuthority News - CWE/SANS TOP 25 Most Dangerous Programming Errors
— 2 comments
pinaldave wrote 5 months ago: I just came across very interesting article from SANS Institute. Experts from more than 30 US and in … more →
SQLAuthority News - Security White Papers
pinaldave wrote 5 months ago: Microsoft Dynamics AX 2009 White Paper: Configuring Kerberos Authentication with Role Centers This d … more →
Re-Associate An Orphaned SQL User With SQL Login
— 1 comment
Sean Decker wrote 5 months ago: If you ever have the need to move a SQL Server Database from one server or instance to the next then … more →
SQL SERVER - sqlcmd - Using a Dedicated Administrator Connection to Kill Currently Running Query
— 2 comments
pinaldave wrote 5 months ago: People are judged from their questions and not their answers. I received wonderful question the othe … more →
Have your say. Start a blog.
See our free features →
An 
Thingamajig
