BUS7 Consulting
Main Menu
Home
Services
Contact Us
January 2009 Tips - Recap
Friday, 30 January 2009 14:17
Clustering
Identifying Windows Volumes on a Clustered SQL Server Instance with the DMVs
Updating the Passive Node in a SQL Server 2005 Cluster
Common Language Runtime (CLR)
SQL Server CLR function to improve performance of validating email addresses
Writing to an operating system file using the SQL Server SQLCLR
Functions
Generate a parameter list for all SQL Server stored procedures and functions
Interview Questions
SQL Server Interview Questions for a Network Administrator
Performance Tuning
Analyzing the SQL Server Plan Cache
Scripts
Using the NOWAIT option with the SQL Server RAISERROR statement
Security
Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005
Security issues when using aliased users in SQL Server
SQL Server security settings using the Surface Area Configuration tool (SAC)
Using the Surface Area Configuration Command Line Tool
Where is the Surface Area Configuration tool in SQL Server 2008
SQL Server Agent
Auto notification for failover of a server and restart of SQL Server services
SQL Server Configurations
How to setup security features for SQL Server
SQL Server Integration Services
How To Get Active Directory Users and Groups Using SQL Server Integration Services SSIS 2005
How To Retrieve Excel Schema Information Using SQL Server Integration Services (SSIS) 2005
T-SQL
SQL Server CLR and T-SQL functions to parse a delimited string
SQL Server Join Examples
Using CROSS JOIN queries to find records out of sequence
Related Tips
Click here for more articles on similar subjects
< Prev
Next >