Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Best Downloads on SQLAuthority.com

November 2, 2007

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Data Warehousing, Database, DBA, SQL Coding Standards, SQL Download

Best Downloads on SQLAuthority.com SQL SERVER – Query Analyzer Shortcuts SQL Server Interview Questions and Answers Complete List Download SQL SERVER – Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts) SQL SERVER Database Coding Standards and Guidelines Complete List Download SQL SERVER – Data Warehousing Interview Questions and Answers…

SQLAuthority News – First Birthday of Blog – 365 Post in One Year

November 1, 2007

Pinal Dave

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

Database, DBA, SQLAuthority Author Visit

Hello Everyone, Today is birthday of this blog. Exactly one year ago, I started this journey of SQL Server and today I have reached first mile stone. There are so many great experience I had during this year. One thing I enjoyed the most is My Extremely Knowledgeable and Friendly…

SQL SERVER – Importance of Master Database for SQL Server Startup

October 31, 2007

Pinal Dave

SQL

SQL Server, SQL System Table

I have received following questions. I will list all the questions here and answer them together.
What is the purpose of Master database?

SQL SERVER – Business Intelligence (BI) Basic Terms Explanation

October 30, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, Data Warehousing

Business Intelligence Business intelligence is a method of storing and presenting key enterprise data so that anyone in your company can quickly and easily ask questions of accurate and timely data. Effective BI allows end users to use data to understand why your business go the particular results that it…

SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers

October 29, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Trigger

Just a day ago, I received question in email regarding my article SQL SERVER – 2005 Disable Triggers – Drop Triggers. Question : How to disable all the triggers for database? Additionally, how to disable all the triggers for all servers? Answer: Disable all the triggers for a single database:…

SQL SERVER – 2008 – Server Consolidation WhitePaper Download

October 28, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL White Papers

Server Consolidation with SQL Server 2008 Writer: Martin Ellis Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal Published: March 2009 Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services…

SQL SERVER – 2005 – Get Current User – Get Logged In User

October 27, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server Security, SQL System Table

Interesting enough Jr. DBA asked me how he can get current user for any particular query is ran. He said he wants it for debugging purpose as well for security purpose. I totally understand the need of this request. Knowing the current user can be extremely helpful in terms of…