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 64 of 64 (640 total posts)
  • Another reason to hate quoted identifiers...

    I was working with the Redgate compare tool today (something I am a big fan of I might add,) using it to take a snapshot of my database so I could drop all code and do a collation change to a database (an article I updated because I discovered a new wrinkle with computed columns needing to be modified.) When I got to that point in the process ...
    Posted to Louis Davidson (Weblog) by drsql on October 1, 2006
  • 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 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
  • 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