THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL Server   (RSS)
Showing page 66 of 66 (658 total posts)
  • 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
  • Updated SQL Server 2005 Samples and Databases

    A bit late, but nevertheless, I wanted to let you know that there's an update you should all be aware of ... the samples and sample databases! :-) SqlServerSamples.msi -- 19,092 KB AdventureWorksDB.msi -- 27,992 KB AdventureWorksDBCI.msi -- 29,116 KB AdventureWorksBI.msi -- 7,592 KB ...
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on May 19, 2006
  • SQL Server 2005 Service Pack 1 available

    If you are using SQL Server 2005, then you will want to download this service pack. There are 32 and 64-bit versions available on the page. Here is a list of bugs fixed and features added to SP1. Here is a link to SQL Server 2005 Express SP1.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on April 22, 2006
  • Timeline Sues ProClarity for Patent Infringement

    BELLEVUE, Wash., June 29, 2005 (PRIMEZONE) -- Timeline Inc. (OTCBB:TMLN) announced it has filed a patent infringement action against ProClarity Corporation, a private company headquartered in Boise, Idaho. This action, filed in the Federal District Court for Western Washington, seeks substantial damages and to enjoin ...
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on July 17, 2005
  • SQL Server 2005 ISV Training for Developers

    Thank you to those whoe attended class. I enjoyed the opportunity to show off SQL Server 2005. Here are the files from class.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on June 2, 2005
Privacy Statement