Welcome to SQL Server Central

Operations Manager and SQL Server

Longtime expert DBA Thomas Laorck brings us a short article about how he uses Operations Manager to watch the SQL Servers he is responsible for and ignore others. Read more...

By Thomas LaRock 2008/07/23 | Source: SQLServerCentral.com | Category: Operations Manager

Rating:

|

Discuss |

Briefcase | 2,466 reads

Kimball ETL Part 1 – Data Profiling via SSIS Data Flow

A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process. Read more...

By Ira Whiteside 2008/07/23 | Source: SQLServerCentral.com | Category: ETL

Rating:

|

Discuss |

Briefcase | 1,719 reads

SQLBits III - Registration Now Open!

Registration for SQLBits III, to be held at Hatfield in the UK on September 13th, is now open! SQLBits is the UK's finest SQL Server technical conference, and it's 100% free to attend! Read more...

By Additional Articles 2008/07/23 | Source: SQLServerCentral.com | Category: User Groups

Rating: (not yet rated) Rate this |

Briefcase | 403 reads

Comparing SQL Server constraints and DML triggers

Over the years, I have witnessed many developers being confused about when to use data-manipulation language (DML) triggers vs. when to use constraints. Read more...

By Additional Articles 2008/07/23 | Source: Builder.com | Category: Triggers

Rating:

Rate this |

Briefcase | 933 reads

Disabling Indexes

Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index. Read more...

By Andy Warren 2008/07/22 | Source: SQLServerCentral.com | Category: Indexing

Rating:

|

Discuss |

Briefcase | 6,115 reads

SQL Server Audit in SQL Server 2008 – Part 2

Learn how to monitor database-level actions and write audit results to files. Read more...

By Additional Articles 2008/07/22 | Source: Database Journal | Category: Auditing

Rating: (not yet rated) Rate this |

Briefcase | 1,250 reads

How to use ranking functions in SQL Server 2005

With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions. Read more...

By Additional Articles 2008/07/22 | Source: SearchSQLServer | Category: Ranking Functions

Rating:

Rate this |

Briefcase | 2,938 reads

How to Track Down Deadlocks Using SQL Server 2005 Profiler

It is irritating, sometimes alarming, for the user to be confronted by the 'deadlock message' when a deadlock happens. It can be a tiresome business to prevent them from occurring in applications. Fortunately, the profiler can be used to help DBAs identify how deadlocking problems happen, and indicate the best way of minimising the likelihood of their reappearance. Read more...

By Additional Articles 2008/07/21 | Source: SimpleTalk | Category: Profiler

Rating:

Rate this |

Briefcase | 3,525 reads

T-SQL Function to Determine Holidays in SQL Server

While working on a project recently I was asked to develop a mechanism that would provide the dates for state and federal holidays in a given year. Since this project deals with all states and territories of the United States, the list had to be comprehensive and the client asked that this list be in the form of a SQL query calculated on-the-fly, rather than a static list. Read more...

By Additional Articles 2008/07/21 | Source: MSSQLTips.com | Category: T-SQL

Rating:

Rate this |

Briefcase | 3,758 reads

Owning the Spelling Suggestion Feature

To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it. Read more...

By Bill Nicolich 2008/07/21 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 3,531 reads