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 40 of 40 (400 total posts)
  • A script to check for the existence of data in tables or views

    This is the second time I have needed this, so that elevates it to blog status (code for mine and your reuse being the second most important reason I blog.  The most important one is the notoriety, glamour, and big bucks :) I have a database that I have recently needed to check to discover if data existed in them, and in some cases, ...
    Posted to Louis Davidson (Weblog) by drsql on November 3, 2006
  • Automatic indexing is cool...plus something to tell you what indexes aren't used

    Now, I will admit up front that I haven't technically tried out all of their bits and pieces of the following tool, but over the past week I have made a lot of use of some of the indexing suggestions by ''hacking'' out the code that generates the index create statements from the sys.dm_db_missing_index_group_stats dynamic management view.  ...
    Posted to Louis Davidson (Weblog) by drsql on October 12, 2006
  • SQL Server Samples Blog

    On a private newsgroup I read, the question was asked: ''Samples in or out of the box? For the next release of SQL Server we're thinking of just shipping sample code on the web, instead of shipping on the web and also in the SQL Server box on a CD as we have done in the past.'' And I replied (amongst other things) that it would be nice if ...
    Posted to Louis Davidson (Weblog) by drsql on October 11, 2006
  • Red Gate's new refactor tool CTP has been released to the public

    A subject I have ranted about from time to time (here on the blog of course, in private I rant about this at least once a day...) is code formatting.  It is always a real pain to get some code from a user from the web (or someone else, closer to you) that is formatted in a way that makes it hard to read.  Now there is a tool for you that ...
    Posted to Louis Davidson (Weblog) by drsql on October 3, 2006
  • 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 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