All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1

November 6, 2007

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

Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local…

SQLAuthority News – Few Add-ons for SQLAuthority

November 5, 2007

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database, DBA

SQL Random Article Find Post SQL Jobs Search SQLAuthority Subscribe Email Update SQLAuthority Feed My Other Blog Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Best Articles on SQLAuthority.com

November 4, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

SQL SERVER – Cursor to Kill All Process in Database SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure SQL SERVER – Shrinking Truncate Log File – Log Full SQL SERVER – Simple Example of Cursor SQL SERVER – UDF – Function…

SQLAuthority News – Best SQLAuthority Articles on Other Popular Sites

November 3, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Coding Standards, SQL Function, SQL Stored Procedure

Best SQLAuthority Articles on Other Popular Sites SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE (SQL Server Magazine) SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards (dotnetslackers.com) Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Best Downloads on SQLAuthority.com

November 2, 2007

Pinal Dave

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…