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 2012   (RSS)
Showing page 5 of 7 (70 total posts)
  • DATEFROMPARTS

    I recently overheard a remark by Greg Low in which he said something akin to ''the most interesting parts of a new SQL Server release are the myriad of small things that are in there that make a developer's life easier'' (I'm paraphrasing because I can't remember the actual quote but it was something like that). The new DATEFROMPARTS ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 10, 2012
  • Publish Profile Files in SQL Server Data Tools (SSDT)

    I have been using SQL Server Data Tools (SSDT) both at work and on some hobby projects for quite a few weeks now and of all the new features I have to say the one that I am appreciating the most is Publish Profile files. I have been searching around on MSDN for an article that explains Publish Profile files but it seems no such article exists so ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 8, 2012
  • Geek City: Build a Big Table with a Columnstore Index

    I was looking all over to find a big table to use for my columnstore examples in my SQL Server 2012 book, and the only one I found was from someone at Microsoft and was not publicly available. When I demonstrate code in my writings, I like to have the code available for anyone to use, so that was no use. Finally I realized I was just ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 26, 2012
  • Folders in SQL Server Data Tools

    Recently I have begun a new project in which I am using SQL Server Data Tools (SSDT) and SQL Server Integration Services (SSIS) 2012. Although I have been using SSDT & SSIS fairly extensively while SQL Server 2012 was in the beta phase I usually find that you don’t learn about the capabilities and quirks of new products until you use them on a ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 15, 2012
  • Follow-up Answers for my Australia Classes

    I was out of the country for the last two weeks of March, delivering classes in Brisbane and Sydney, which were organized by WardyIT.  It was a great visit and there were 24 terrific students! As is sometimes (perhaps often?)  the case, there were questions posed that I couldn’t answer during class, so here are a couple of follow-up ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 4, 2012
  • SQL Server 2012 content on Channel 9

    A mountain of SQL Server 2012 video content featuring Greg Low, Jonathan Kehayias, Joe Sack and Roger Doherty has just been released on Channel 9. Channel 9 has great support for tags and RSS feeds so if you want to automatically download all of that content simply you can add the following RSS feed: ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 10, 2012
  • Variable enhancements in RC0 [SSIS]

    I have been poking around idly in the RC0 release of SQL Server Integration Services (SSIS) 2012 and noticed a few nice enhancements that hadn’t really hit the newsstands as yet (well, I didn’t know about them anyway). Here is a quick rundown: Expression is viewable in the Variables window Fairly self-explanatory this one. If a variable ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 22, 2012
  • Is the SSIS Catalog going to be enough?

    Over the past year or so I have written at length about the SSIS Catalog that will be provided in the upcoming version of SQL Server Integration Services (SSIS 2012) and the capabilities that it will bring; one of the biggest benefits (in my opinion) is that logging is now something that is taken care of on your behalf. Many SSIS developers have ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 22, 2012
  • SQL Server Data Tools does support required variables

    Over the past few years of using datadude (aka DBPro aka Visual Studio Database Projects) I have fallen prey to a peculiar little nuance – if you forget to supply a value for a sqlcmd variable then it will simply use a default and often that is not the desired behaviour. Hence why yesterday I submitted the following suggestion to ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 12, 2012
  • PBM for SSIS? What policies would you want?

    My mind was wandering today after reading Andy Leonard's excellent post Name Those Connections and it occurred to me that due to SQL Server 2012 including an SSIS Server there may be an opportunity to leverage Policy-Based Management (PBM) for ensuring adherance to an organisation's best practises around SSIS development. I have absolutely no idea ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 9, 2012
Privacy Statement