THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 8 (71 total posts) < 1 second(s)
  • re: Responses to SSDT questions

    @Tyler, to me anything in the project could be considered an object - tables, stored procs, constraints, views, logins. If there's a script/file for it, I was treating it generically as an &quot;object&quot;. &nbsp;Set those to &quot;Not in Build&quot; and you'll still have the script that defined it, but won't try to work with it when you ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on July 25, 2014
  • re: Schema Compare or Publish [SSDT]

    Aaron, you may want to consider automating your script/diff generation. You can use SQLPackage to generate a diff report in XML and a change script as well. I've done that for several of our builds. We even have that set as an option in our automated build jobs to either just gen the report/change script or to also push the changes. (We haven't ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on December 19, 2013
  • re: Really useful Excel keyboard shortcuts

    CTRL+Shift+L turns on the filters for the current set. What I'd love to find is a good shortcut that uses the same date format as the one chosen when you set the Short Date. There is a shortcut for formatting dates, but it doesn't use that same date format. Sadly, it doesn't seem like one exists. It would be useful for when the datetime columns ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on December 6, 2013
  • re: Don’t learn SSDT, learn about your databases instead

    Stephen, What I'd likely start doing is clearing up the errors and warnings. Some warnings can be suppressed (perhaps an object in another database that you know exists or similar). The errors need to be addressed before you can build successfully. Double-clicking the error row should take you to the problematic file/line to address. ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on November 20, 2013
  • re: Detecting Database Drift using SSDT

    @Matt, isn't that what Jamie mentioned with his SQLPackage syntax to generate the drift report? Add that in with a command to build the package, then compare the project to the package or the other way around. You should also be able to specify a source DB/connection in addition to the target DB. I've done this and normally use the DB as target ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on November 4, 2013
  • re: June 2013 release of SSDT contains a minor bug that you should be aware of

    Another fun change in the June 2013 build is if you just &quot;Build&quot; a project, it does a partial overwrite of your pre and post deploy scripts. We're using Git so the actual project files change while those in the build output do not. If you have a post deploy script with a lot of text, then switch to a branch with a lesser amount of text, ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on August 27, 2013
  • re: Publish Profile Files in SQL Server Data Tools (SSDT)

    @Kyle, I built on Jamie's initial work on this and blogged about it here: http://schottsql.blogspot.com/2013/05/ssdt-setting-different-permissions-per.html There's also a link to Jamie's original article - ...
    Posted to Jamie Thomson (Weblog) by Peter Schott on July 11, 2013
  • re: June 2013 release of SSDT contains a minor bug that you should be aware of

    I don't recall this being new in the June 2013 release, but we've made it a habit to qualify everything in our statements to be on the safe side. Of course, having said that I'm sure we'd find out very quickly how many pieces of code we have that will prove me wrong. :) Thanks for the warning, Jamie.
    Posted to Jamie Thomson (Weblog) by Peter Schott on July 1, 2013
  • re: Diagnosing differences between production and development

    If all you're working with is SQL Server 2005 or higher, I'll put in a plug for SSDT. Download the latest release (at this point December 2012) from MS, install, and use the Schema Compare feature under the &quot;SQL&quot; menu to connect to your source/destination databases. You may want to tweak which object types to compare and perhaps tweak ...
    Posted to John Paul Cook (Weblog) by Peter Schott on March 25, 2013
  • re: Trigger Authoring Decision Tree

    Actually the other part of this is &quot;do you have any devs who can take the time to do this right now?&quot; :P Several times we've had to put something like this in a trigger because getting a dev to actually dig through the code to implement would take significantly longer before it ever got implemented.
    Posted to Merrill Aldrich (Weblog) by Peter Schott on March 7, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement