-
Storage area network (SAN) basics every SQL Server DBA must know
Storage area networks mean better management and improved performance for your SQL Server environment – but only if people in charge understand them. In this tip, SQL Server expert Denny Cher...29 May 2008
-
Open SSIS packages without validation using these SQL properties
When opening a SQL Server Integration Services (SSIS) package in SSIS Designer, by default SSIS validates data sources used by the various components. You can choose to override this behavior -- pr...27 May 2008
-
SQL Server backups using SAN database snapshots
In his overview of SAN snapshots for the DBA's tool belt, SQL Server expert Brent Ozar discusses performance impact, filegroup and file layout, replication, transaction logs and snapshots for data ...21 May 2008
-
Using the OUTPUT clause for practical SQL Server applications
The OUTPUT clause returns results of all the rows affected by an INSERT, UPDATE or DELETE command' has provides many options for simplifying your T-SQL code. In some scenarios, it can even eliminat...19 May 2008
-
Tips for moving from SQL Server local disk storage to SANs
Implementing storage area networks in your SQL Server environment can make your locally attached storage system seem primitive. Moving to SANs means understanding concepts of multiple fabrics, adva...14 May 2008
-
Check SQL Server database and log file size with this stored procedure
Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Spac...13 May 2008
-
Sarbanes-Oxley compliance checklist: IT security and SQL audits
If your SQL Server environment is not yet expected to meet Sarbanes-Oxley (SOX) Act compliance standards, it soon will be. In this tip, SQL Server expert Michelle Gutzait presents security practice...07 May 2008
-
Create DDL table in SQL Server 2005 to audit DDL trigger activity
Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and cus...05 May 2008
-
How to process SQL Server 2005 Analysis Services for data availability
When processing very large databases in Analysis Services and ensuring users access to data, you can break a cube's measure group into manageable chunks. In this tip, contributor Baya Pavliashvili ...01 May 2008