We often want to modify many SSIS packages at once. We may want to change the password on all packages within a folder, or regenerate the unique identifier on each SSIS package to make sure that it’s unique across multiple copies of the package. This is a case where a little scripting knowledge can save you [...]
Rules of Engagement was written to help shed light on the usefulness of NoSQL in your applications, and get you thinking about where it could fit into your overall architecture. I was originally going to use this space to read your mind and go through a list of some of the top reservations that you [...]
This is space! Course, we’re just in the beginning part of space, we-we haven’t even got to *outer* space yet! – Armageddon (1998) In the movie Armageddon, Oscar (played by Owen Wilson) is very anxious and excited at the same time and says this as he is flying to stop the asteroid from hitting earth. [...]
That’s so crazy, it just might work How many times have you implemented solutions that somehow manage to fit a square peg into a round hole? It’s the strangest thing too: you have a certain sense of pride that you were able to get SQL to do that thing that it really can’t do. At [...]
Thank you to Wayne Sheffield (blog | @DBAWayne) not only for hosting February’s T-SQL Tuesday #39, but for bringing The Rock into it. Wayne is writing a series about PowerShell and asked for others in the community to participate with a post about the most electrifying ways to use PowerShell with SQL Server. Looping through a DataTable in PowerShell [...]
Rules of Engagement: NoSQL is SQL Server’s Ally is the title of a presentation that Dave Valentine (Blog | @IngeniousSQL) and I plan to give several times this year. Your knee jerk reaction to this title was likely negative, if you are like many other SQL Server professionals. And I can’t blame you, because I was once in the [...]
What would your reaction be if you were scanning the list of presentations to attend at a conference and saw a session named NoSQL Rules of Engagement? Dave Valentine (Blog | @IngeniousSQL) and I were originally going to name our next presentation just that, until we asked for feedback from Mike Donnelly (Blog | @SQLMD). [...]
Twas the night of the Release, when all through the shop, Not a developer was coding, QA made them stop; The code was checked into TFS with care, In hopes that the deployment team soon would be there; The managers were nestled all snug in their beds, While visions of trouble free upgrades danced in [...]
Thank you to Sebastian Meine ( @sqlity ) for hosting December’s T-SQL Tuesday #37. He is writing a series about JOINs this month and asked for others in the community to participate with a post about JOINs. We are frequently given requirements to return ALL of the data from Table A combined with data from Table B whether the data [...]
Which SSIS Package is DTEXEC running right now? Have you ever noticed a rogue DTEXEC process, but didn’t know which of many SSIS packages was actually running, or what values had been passed to it? I was in that position once, and one of the few references that I could find was dtexec.exe what are [...]
Subscribe Via E-Mail
- Powershell Training Wheels November 12, 2012
- Key Lookups at the Poker Table – #TSQL2sDay June 10, 2013
- What’s In a [Presentation] Name? January 30, 2013
- PowerShell, Just Bring It: Looping Through a DataTable – #TSQL2sDay February 12, 2013
- LEFT JOIN: Location, Location, Location – #TSQL2sDay December 11, 2012
- Rob Farley : Plan Operator Tuesday round-up says: [...] Switch operator is consuming data from up to four lookups,...
- Santosh George says: Rick - Good overview of Google+. I was never sure why...
- SQLSaturday Game Plan - DataOgre says: [...] been working on some new ideas for presentations, because the...
- T-SQL Tuesday #39 – Wrapup | Wayne Sheffield says: [...] Krueger (@DataOgre) http://www.dataogre.com/2013/02/12/powershell-just-bring-it-tsql2sday/ shows us how to use PowerShell to...
- Eric SElje says: See, if SQL Server were any good it would have automatically...