Most Recent Tips		Most Popular Tips		Most Read Tips
Using the EventData() Function with DDL triggers in SQL Server 2005 Running a Dynamic Query against SQL Server without using Dynamic SQL Vacation for a SQL Server DBA SQL Server DBA Telecommuting Tips Windows Integrated Authentication Failures to SQL Server SQL Server Security Interview Questions Managing SQL Server Database and Application Metadata Database Mirroring Automating Failover for Multiple Databases How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005 more tips...		Recover from a SQL Injection Attack on SQL Server Calculating Mathematical Values in SQL Server T-SQL Function to Determine Holidays in SQL Server The Many Uses of Coalesce in SQL Server Using SQL Servers OPENROWSET to break the rules Create a SQL Server Data Dictionary in Seconds using Extended Properties Dynamically controlling the number of rows affected by a SQL Server query Rebuilding the SQL Server master database - Part 1 Inserting, Updating or Deleting Data in SQL Server from an Excel Spreadsheet Reading the SQL Server log files using T-SQL		Export data from SQL Server to Excel Date/Time Conversions Using SQL Server SQL Server 2000 Text Data Manipulation Different Options for Importing Data into SQL Server Error - Windows cannot access the specified device, path or file. Grant Execute to all SQL Server Stored Procedures Deleting Data in SQL Server with TRUNCATE vs DELETE commands Enabling xp_cmdshell in SQL Server 2005 SQL Server T-SQL Aggregate Functions Deploying a SQL Server 2000 DTS Package vs. a SQL Server 2005 Integration Services Package (SSIS)

Information From Our Sponsors Try Idera’s new SQL admin toolset: 24 essential tools for SQL Server Management Download a free trial and see how Red Gate’s SQL Compare will reduce your workload (and the inevitable human errors) by up to 90%. Trouble-free SQL Servers. No 1-size-fits-all solution. Focus on your servers and keep them healthy! Worried about Disaster Recovery? Learn how to protect your SQL servers using SonaSafe from Sonasoft SQL Nitro found the secret to 65 percent faster queries with network compression technology yielding a fantastic SQL Server ROI.

Industry Leading Products    SQL Prompt Fast, intelligent, T-SQL code-completion add-in for Visual Studio, SSMS and Query Analyzer. SQL Prompt helps you write faster, neater SQL queries without having to know the details of the database schema. Preset exactly how and when SQL Prompt responds to your needs. Free 14-day trial download. ...