July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Book Review – Backup & Recovery (Paperback)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Backup and Restore, SQLAuthority Book Review
Backup & Recovery [ILLUSTRATED] (Paperback) by W. Curtis Preston (Author) Link to Amazon Short Summary: This book’s does not only teaches you have to create safe backup but it takes you to the next level where a large organization can save tons of dollars a year by making their backup…
Read More

SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Coding Standards, SQL Scripts
Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change the code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep…
Read More

SQLAuthority News – Latest Interesting Downloads and Articles

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL White Papers
White Paper: Precision Considerations for Analysis Services Users This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due…
Read More

SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Scripts, SQL Stored Procedure
In my organization we rename the database on development server when are refreshing the development server with live data. We save the old database with new name and restore the database from live with same name. If developer/Jr. DBA have not saved the SQL Script from development server, he/she can…
Read More

SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Data Warehousing, Database, SQL White Papers
White paper describes the use of virtual copy Storage Area Network (SAN) snapshots in a load-balanced scalable querying environment for SQL Server 2005 Analysis Services. This architecture provides the following improvements Improves the utilization of disk resources Optimizes cube processing operations Supports dedicated snapshots for specific users at different points…
Read More