THE SQL Server Blog Spot on the Web

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


You searched for the word(s):
Showing page 1 of 9 (86 total posts) < 1 second(s)
  • re: Agile or Waterfall?

    Probably my biggest concern w/ the Waterfall approach is that I typically see requirements set in stone for lengthy projects. By the time the project is done, the requirements are just out of date and injecting change into that process is painful. &nbsp;Conversely, Agile has issues with scope creep and many projects that never feel ''done'' as a ...
    Posted to Andy Leonard (Weblog) by Peter Schott on October 20, 2016
  • re: So You Want to Learn More About Biml?

    I think the main point for BIML isn't that you're adding a layer of XML, but you're writing code that you can more easily tweak to generate your SSIS packages. Ever had to adjust a package doing a bunch of inferred dimension member loads with a ton of UNION ALL transforms and realize that you need to add a new column to the mix? BIML - add the ...
    Posted to Andy Leonard (Weblog) by Peter Schott on June 6, 2016
  • re: Bad habits to kick : putting an IDENTITY column on every table

    Thanks for the article, Aaron. For some reason I'm just coming across it for the first time. While I am torn about your original example (I can see both sides), I appreciate the thoughts and the discussion along the way. I agree that not every table needs an Identity column. Even tables where I use an integer key don't always get Identity columns. ...
    Posted to Aaron Bertrand (Weblog) by Peter Schott on April 5, 2016
  • re: Row Level Security–Part 2-Write Operations

    Thanks, Louis. I hadn't considered the AFTER/BEFORE ideas when I was thinking about ways to use RLS. Those are some great examples that we can build on.
    Posted to Louis Davidson (Weblog) by Peter Schott on March 8, 2016
  • re: SSIS Catalog Compare

    The concept is interesting, but our Production environment is completely walled off so we'd have to do some fancy footwork to get the compare to work properly. :(
    Posted to Andy Leonard (Weblog) by Peter Schott on October 12, 2015
  • re: Responses to SSDT questions

    And for those following the thread, there is now quite a bit more granularity in SSDT Publish options as to what you can ignore/drop. It's definitely worth a look at the later updates. Check for the latest news and versions.
    Posted to Jamie Thomson (Weblog) by Peter Schott on October 8, 2015
  • re: SSIS Catalog Logging and Reporting in the Enterprise

    Agreed on that one, John. The cascading deletes are a pain if you don't catch them before that first purge and you haven't created the proper indexes. I was glad to see that they're finally fixed if you have 2012SP2 or later. I've used SSIS Reporting Pack before and plan to use it again. I've also appreciated Pragmatic Works' tool enough to be ...
    Posted to Andy Leonard (Weblog) by Peter Schott on August 15, 2015
  • re: SQL Formatting Matters…

    It matters because of the way I parse the code. However, it matters less when you have all sorts of tools that can re-format it for you. :) I really like Red-Gate's SQL Prompt, but have been playing with ApexSQL's Complete and Refactor lately as viable alternatives while trying to work out what would need to be licensed and where.
    Posted to Andy Leonard (Weblog) by Peter Schott on July 20, 2015
  • re: Temporal Tables – Part 1 - Simple Single Table Example

    Definitely interesting. I'll have to play with this to see what sort of overhead we incur by using this (where needed, of course). I'm also curious about the effects of trying to ALTER a table to add a column, drop a column, etc. It would mostly be for some sort of &quot;ADD Column&quot; statement, though we've done drops or even renames from time ...
    Posted to Louis Davidson (Weblog) by Peter Schott on July 2, 2015
  • re: Responses to SSDT questions

    @Marcus, VS2013 has SSDT built in and its own bits apart from those using the VS2012 IDE. (Also had a pretty quick hotfix applied to a recent build because the one included in the VS2013 update package ended up breaking builds. :) ) Because it uses the VS IDE to do its work, the &quot;version&quot; may not always seem to be in sync with SQL. MS ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on December 22, 2014
1 2 3 4 5 Next > ... Last »
Privacy Statement