THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » testing   (RSS)
Showing page 1 of 2 (19 total posts)
  • Tinkering with SSIS 2016 RC2

    I’ve been testing SSIS 2016 as the CTPs (Community Technology Previews) and RCs (Release Candidates) have been made available. I’ve been most interested in changes to the SSIS Catalog. Getting RC2 running posed a couple challenges for me so I thought I would blog about my test setup – in case anyone else is experiencing similar challenges. I ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 11, 2016
  • SSISPerformance.com

    During a delivery of Advanced SSIS Training (by Tim Mitchell and Andy Leonard), Michael Smith suggested an idea for a site where SSIS performance benchmarks could be created and recorded. Thus, SSISPerformance.com was born. I was so struck by the idea; I purchased the domain while Tim was delivering a couple modules on Advanced SSIS! The site is ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 29, 2015
  • Automate ETL Testing: Cross-Server Data Comparison with PowerShell

    In collaboration with a current client over the past year or so, I've been working on the issue of Test Driven Development for ETL work, especially in the area of automated testing for data. He graciously agreed to allow me to rewrite some of the code we originally developed in Ruby as a set of PowerShell demo scripts and share it through ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on November 22, 2015
  • Software Economics and Testing

    “There are two types of developers: those who test their software and those who will.” – Andy, circa 2015 It’s April Fool’s Day in the US, but I’m going to act like it’s Halloween. Software testing is no joke, and not testing should scare you. In 1996 (yes kids, years used to begin with a “1”), in the sixth issue of Fast Company ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 1, 2015
  • Testing

    It’s 2015 and we still have no flying cars. (Dear Doc Brown, we still need roads. Love, Andy) On a similar note, we’ve suffered through another year of software breaches and empty promises to fix the issues behind them. Brian Kelley (Blog | @kbriankelley) was right, We Don’t Care About Data and IT Security. Part of the issue is testing. Do you ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 5, 2015
  • Geek City: What Triggered This Post?

    I’d really like to get another post up onto my much neglected blog before the end of 2012. This will also start one of my New Year’s resolutions, which is to write at least one blog post a month. I’m going to tell you about a change in SQL Server that wasn’t announced in any “What’s New” list that I ever saw, perhaps because it was just a chance ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 31, 2012
  • CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

    Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a lot recently. CPU pressure in SQL Server creates all sorts of interesting side-effects, such as ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 23, 2012
  • How Microsoft helps you NOT break your Windows Azure Application: Storage Services Versioning

    One of the advantages of using Windows Azure to run your code is that you don’t have to constantly manage upgrades on your platform. While that’s a big advantage indeed, it immediately brings up the question - how do the upgrades happen? Microsoft upgrades the Azure platform in periodic increments, and the components that are affected are ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 6, 2011
  • Why generalizations are dangerous

    A couple of years ago, John Sansom wrote a blog post comparing the performance of two different ways to get the maximum value from a column: MAX() and TOP (1). http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/ In the conclusion, he states:  When a clustered index is present on the table & ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 15, 2011
  • Plan for Diagnostics in Cloud Computing From the Git-Go

    “Git-Go” is something we say in the South that means “right at the start”. I’ve seen several applications for on-premise systems that don’t have much in the way of diagnostics - the developers rely on a debugger, the event logs on the server and client workstation, and most of all, the ability to watch the system from end-to-end. This approach ...
    Posted to Buck Woody (Weblog) by BuckWoody on September 6, 2011
1 2 Next >
Privacy Statement