Miscellaneous

SQLServerCentral Article

Server Farm Reporting - Part 1

  • Article

Managing a large number of servers can be quite the challenge for many DBAs and it seems to get worse each year as more servers are added without an increase in staffing. New author Mark Tierney brings us the first part of a series on the framework he's built to help manage his servers.

5 (1)

You rated this post out of 5. Change rating

2007-08-01

4,257 reads

Technical Article

Automate Scripting with SQL Scripter

  • Script

SQL Scripter is an open-source console tool for generating SQL Server DDL. Written in C# using .NET 2.0, SQL Scripter provides front-ends for MSBuild, NAnt and the Windows command line. Each front end supports syntax for specifying which types of database objects to script, including all objects of a type or directly named instances.SQL Scripter […]

3.33 (3)

You rated this post out of 5. Change rating

2007-10-12 (first published: )

6,269 reads

Technical Article

Collation Checker

  • Script

this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation

4.71 (7)

You rated this post out of 5. Change rating

2007-11-06 (first published: )

2,357 reads

Technical Article

MOM SCDWgroom Enhancement

  • Script

It might not be useful now, but if you ever wanted to downsize the amount of data that you keep in your datawarehouse, good luck.  This will help you do that.  This job is set to shrink it down to 120 days, but you can adjust it as you like.  Runs again in 5 day […]

You rated this post out of 5. Change rating

2007-10-16 (first published: )

538 reads

Technical Article

MOM 2005 Datawarehousing Catchup

  • Script

I wrote this script because our MOM Datawarehousing got so damn behind.Every time the windows Scheduled task tried to run to warehouse the dataout of OnePoint, it would puke because the SQL log would fill up. Thisallows you to start so many days out and it will increment it down by the number of days […]

You rated this post out of 5. Change rating

2007-10-18 (first published: )

1,388 reads

Technical Article

Find Column Name Usage

  • Script

This procedure produces a formatted report to list which tables, views and table functions have a column of the specified name. This is particularly useful in systems that do not enforce referential integrity or when schema changes are being evaluated.

4.17 (6)

You rated this post out of 5. Change rating

2007-10-22 (first published: )

4,153 reads

Technical Article

Find Column Usage

  • Script

When changing schema or modifying an application it is often necessary to determine when a column from a specific table is used.  This procedure produces a formatted report (when outputting from query analyzer or management studio in text mode) that specifies all of the procedures, views, functions and triggers that use the designated table.column.

5 (13)

You rated this post out of 5. Change rating

2007-10-10 (first published: )

7,409 reads

Blogs

Advice I Like: Praise

By

Don’t reserve your kindest praise for a person until their eulogy. Tell them while...

How to Install SQL Server 2025 RC0 on an Azure VM

By

I wanted to try out the new JSON index which is for the moment...

Prepping for Certification, Part 1 of ?

By

I thought it would be good to put my thoughts down on how to...

Read the latest Blogs

Forums

Learning a New Language

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learning a New Language

is there a way to "detect" schema like changes on a server?

By stan

Hi, we have a few people who like to experiment on our prod sql...

Guidelines and Requirements

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Guidelines and Requirements

Visit the forum

Question of the Day

Copying Production Schema

If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?

See possible answers