May « 2009 « SQL Server Journey with SQL Authority

Archive for May, 2009

SQL SERVER – Create Multiple Filegroup For Single Database

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on May 31, 2009 | 20 Comments »

I am elated to receive hundreds of emails every day from my readers. My tight work schedule refrains me from answering all your questions, but I do try my best to entertain them whenever I can. Today’s post revolves around a question I received a number of times last year but never blogged on it. [...]

Read Full Post »

SQL SERVER – Difference Between Candidate Keys and Primary Key

Posted in Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 30, 2009 | 3 Comments »

Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key. Primary Key – [...]

Read Full Post »

SQLAuthority News – Blog Makeover – New Banner – New Color

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, SQLServer, T SQL, Technology on May 29, 2009 | 7 Comments »

Just a month back I had previously changed my personal homepage and had requested for feedback from my readers here SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested. To my astonishment, I received a huge number of emails. But I received only one comment. This time, I would like to request my [...]

Read Full Post »

SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 28, 2009 | 44 Comments »

I often receive emails from reader requesting solution to following error: “SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem.” in a modal dialog with the title “SQL Writer” While searching online there are so many different solution and [...]

Read Full Post »

SQL SERVER – Interesting Observation of Logon Trigger On All Servers

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Trigger, T SQL, Technology, tagged SQL Audit on May 27, 2009 | 23 Comments »

I was recently working on security auditing for one of my clients. In this project, there was a requirement that all successful logins in the servers should be recorded. The solution for this requirement is a breeze! Just create logon triggers. I created logon trigger on server to catch all successful windows authentication as well [...]

Read Full Post »

Older Posts »