July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Data Warehousing, Database
Top 10 Best Practices for SQL Server Maintenance for SAP By Takayuki Hoshino SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an outline of best practices for maintaining SQL Server database for an SAP implementation. 1) Perform a full database backup daily 2) Perform…
Read More

SQLAuthority News – Book Review – Beginners Guide to SQL Server Integration Services Using Visual Studio 2005

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQLAuthority Book Review
Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 (Paperback) by Jayaram Krishnaswamy (Author) Link to Amazon Short Summary: SQL Server Integration Services Using Visual Studio 2005 contains all the information and education needed for one to begin with SSIS. It covers all the basic concepts in depth…
Read More

SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Humor
Following is the collection of some funny quotes regarding computers. Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rich Cook. UNIX is basically a simple operating…
Read More

SQLAuthority News – Microsoft SQL Server 2000 MSIT Configuration Pack for Configuration Manager 2007

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download
Microsoft SQL Server 2000 MSIT Comprehensive Configuration Pack for Configuration Manager 2007 This configuration pack contains configuration items intended to manage your SQL Server 2000 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. Microsoft SQL Server 2000 MSIT Intermediate…
Read More
All Articles partition2-600x400

SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table

Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Scripts, SQL Server, Table Partitioning

I have received calls from my DBA friend who read my article SQL SERVER – 2005 – Introduction to Partitioning. He suggested that I should write a simple tutorial about how to horizontal partition database table. Here is a simple tutorial which explains how a table can be partitioned.

Read More

SQLAuthority News – Download Microsoft SQL Server 2005 Assessment Configuration Pack

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL Utility
Microsoft SQL Server 2005 Assessment Configuration Pack for Gramm-Leach Bliley Act (GLBA) This configuration pack contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 servers in order to support your Gramm-Leach Bliley Act compliance efforts. Microsoft SQL Server 2005 Assessment Configuration Pack…
Read More