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 (83 total posts) < 1 second(s)
  • 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
  • re: Dacpac braindump - What is a dacpac?

    Been there before, been hit by the cross-DB stuff, learned to use the command line to at least get started and add DB references. Once those were set up, pulling in changes became a lot easier. Without that, the various dependencies almost always crashed the import/create project process. :) &nbsp; (And I learned a lot from Jamie over his many, ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 18, 2014
  • re: Dacpac braindump - What is a dacpac?

    @Jay, what problems are you having with extracting the DAC file? Have you tried using the SQLPackage command line to do that? I've had issues trying to use the GUI with some DBs that have cross-DB code or other things that don't necessarily translate as easily into a project.
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 18, 2014
  • re: Don’t be a dinosaur. Use Calendar Tree!

    Thanks for sharing. This sort of thing sounds like it could be really useful to keep track of events and keep everyone notified about them along with any changes.
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 18, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement