Apr 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 – Three T-SQL Script to Create Primary Keys on Table

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts
I have always enjoyed writing about three topics Constraint and Keys, Backup and Restore and Datetime Functions. Primary Keys constraints prevents duplicate values for columns and provides unique identifier to each column, as well it creates clustered index on the columns. -- Primary Key Constraint upon Table Created Method 1…
Read More

SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Security, SQL Utility
Microsoft has turned off all the potential features of SQL Server 2005 that could be susceptible to security risks and hacker attacks. Many features of SQL Server 2005 i.e. xp_cmdshell, DAC etc comes disabled by default, this makes the vulnerable surface area less visible to potential attacks. The Surface Area…
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