THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server   (RSS)
Showing page 37 of 37 (365 total posts)
  • Easier access to metadata coming soon to a SQL Server near you

    This is not a scoop or anything, but it is quite newsworthy.  It is also a good way to kick off my sqlblog er...blog: Kalen Delaney - Metadata PowerSimon Sabin - object_name() to be extended in SP2 A very common request is to have some of the system functions to work in any database.  Kalen posted a piece of feedback on ...
    Posted to Louis Davidson (Weblog) by drsql on September 25, 2006
  • Visio does not handle Schema? Let's force it to do!

    I love VISIO to make database modeling, it gives very nice and colorful diagrams that I use for the documentation. I hate VISIO as it is really far from perfect, among all the others one thing it lacks is the ability to generate a database using SCHEMA information. As I like schemas I decided to find a way to bypass VISIO limitations, here ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on September 6, 2006
  • SqlBulkTool

    SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way. The parallelism can use the ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on July 14, 2006
  • Table Difference 1.1

    TableDifference has been updated to version 1.1. The major improvement is the fact that now TableDifference can handle a field as Key: a field that represent a key in the table, you must supply KeyOrder Compare: a field that is to be compared between OLD and NEW, you must supply UpdateID PreferNEW: the field appear in both flows but you ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on July 6, 2006
  • TableDifference: a solution to SCD handling

    In SSIS the SCD component does a lot of work for you but it works so slowly that it is quite always convenient to create an “ad hoc” solution to handle the slowly changing dimensions. As the main problem is that of determining the difference between the last snapshot of the SCD and the current data we decided to write an SSIS component ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on June 8, 2006
Privacy Statement