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 » connect   (RSS)
  • T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

    I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it is. This changes today because I read a blog on Adam Machanic's (@adammachanic) blog that outlined the rules (here) and I have been keen to get back to blogging regularly. When I saw what ...
    Posted to Louis Davidson (Weblog) by drsql on January 10, 2017
  • A potted SSIS history via Connect

    Yesterday I received a notification that one of my submissions to http://connect.microsoft.com had received a comment. Nothing unusual about that, I receive those sorts of emails every day, on this occasion however the comment was actually worth reading. The comment was from SSIS development guru Jeff Bernhardt (he has changed job titles recently ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 7, 2011
  • Have SSIS' differing type systems ever caused you problems?

    One thing that has always infuriated me about SSIS is the fact that every package has three different type systems; to give you an idea of what I am talking about consider the following: The SSIS dataflow's type system is made up of types called DT_*  (e.g. DT_STR, DT_I4) The SSIS variable type system is based on .Net datatypes (e.g. ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 14, 2011
  • Newly closed Connect items auger well for SSIS in Denali

    Todd Mcdermid spoke recently on his blog post Integration Services vNext Coming Soon about how some recently closed Connect items had encouraged him as to the future of SSIS. Also, Matt Masson from the SSIS team has written a similarly encouraging blog post about some upcoming SSIS enhancements at Upcoming Product Changes. Now its my turn. Just ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 10, 2010
  • Be wary of using UNC paths in SSIS packages

    I have recently discovered what I believe to be a bug in SQL Server Integration Services (SSIS) 2008 and am taking the opportunity herein to warn about it so that nobody else gets stung by it. The bug concerns the use of Uniform Naming Convention (UNC) paths inside a .dtsx package (i.e. paths that start with a “\\”). I have managed to reproduce a ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 19, 2010
  • RSS feed for SQL Server Connect feedback

    Have you heard of Microsoft Connect? It is a Microsoft website dedicated to soliciting feedback about bugs and feature suggestions for their products and SQL Server has a dedicated space on that website at https://connect.microsoft.com/SQLServer/feedback/. That much you probably knew. What you might not know is that the site provides an RSS feed ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 19, 2010
  • Extended Properties in Object Explorer Details – Vote on Connect

    After a discussion with a friend of mine, I’ve opened a suggestion on Connect to request to have Extended Properties visible in the main Object Explorer Details window. This will be especially useful for creating self-documenting database, since that window can easily provide additional information about, for example, column in a table or in a ...
    Posted to Davide Mauri (Weblog) by manowar on September 15, 2009
  • And sometime Connect works... slowly...

    Almost two years ago I wrote a post about the abuse of the ''it's by design'' answer Microsoft gives to many bugs. You know, I think that a bug in design produces the same results (if not worst) than a bug in implementation. I also had a long discussion about the reason why that specific issue should have considered a bug or not. But that's ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 16, 2009
  • The "by design" abuse

    In the last months, I got the infamous ''it's by design'' answer for many bugs/issues/irrational behaviors I posted to Microsoft. For most of them I used the Connect web site, in a couple of cases I opened a formal incident to Microsoft support. There are a lot of story (in and outside Microsoft) about the ''it's by design'' excuse and most of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 19, 2007
Privacy Statement