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: 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
  • re: An appeal for SSDT developers – Red Gate want to hear from you

    More than willing to chat with them. I know I've discussed some SQL Source Control / SSDT stuff with them in the past, though. They can shoot me a message on twitter - @paschott.
    Posted to Jamie Thomson (Weblog) by Peter Schott on November 13, 2014
  • re: Table designer (10 days of SSDT – Day 4)

    @Jag - that could be a holdover from the old VS DB Project format where everything was broken out into separate scripts. If you want to do something similar, you can right-click in the project to add a new constraint as a separate file. To me, it's easier to manage as part of the table definition, but I can see some might prefer splitting each ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on October 1, 2014
  • re: Day 1 – Online and offline (10 days of SSDT)

    I haven't played with the &quot;online&quot; portion of Object Explorer too much. I may have to look at that a little more closely. Most of my work has been in the offline world, making sure the project builds successfully, getting post-deploy scripts ready, etc. Sounds like I might want to use the online mode a little more if it just previews ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on September 17, 2014
  • re: Dacpac braindump - What is a dacpac?

    Jay, you can also make your changes to the other DB Project, build it, and use the generated dacpac to replace the existing one. It depends on how many databases you have in projects, of course. And yes, if you modify the referenced database in some fashion that will affect your projects, you'll need to re-extract. Ideally you've made that ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 21, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement