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 10 (92 total posts) < 1 second(s)
  • re: The SQL Hall of Shame

    I'm w/ Aaron on the need for a &quot;Beginning of Month&quot; function. We've used something like that _far_ more often than we've ever used an &quot;end of month&quot; function. &nbsp;It's more consistent in day numbers - the &quot;day&quot; portion is always 1. :)
    Posted to cinahcaM madA (Weblog) by Peter Schott on June 19, 2017
  • re: The SQL Hall of Shame

    Ran across one instance where a company didn't have a DBA but had various sysadmins. One decided that they would DBCC PINTABLE the largest tables in the system so it would run faster. That server ran out of memory within the day and kept crashing until it was rebooted and we turned that option off. :) &nbsp;I kind of get the idea in general when ...
    Posted to cinahcaM madA (Weblog) by Peter Schott on June 14, 2017
  • 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
1 2 3 4 5 Next > ... Last »
Privacy Statement