confessionsofanagilecoach.blogspot.com
Confessions of an Agile Coach: Automated Tests for Database Procedures
http://confessionsofanagilecoach.blogspot.com/2015/02/automated-tests-for-database-procedures.html
Confessions of an Agile Coach. Wednesday, February 18, 2015. Automated Tests for Database Procedures. Why not future-proof your database procedures just as the middle tier and front-end developers have been future proofing theirs? Why Unit Test Procedures? Every time there's a change in a procedure or schema, unexpected errors can happen. To mitigate disaster, you'll have been doing some kind of testing: manual testing, automated testing, . To pass your test procedures. If you have a test suite that conf...
philhelmer.com
Testing | SQL on the Brain
http://www.philhelmer.com/tag/testing
SQL on the Brain. How Test Data Builders Help You Sleep. April 9, 2015. This isn’t a full-on sales pitch for data builders. Rather, it is only a testimonial of how they make my life easier. Some developers have to start with an empty database. Others have some minimally-populated db that they add to on an as-needed basis. Still others can use a scrubbed copy of production data, which is excellent for judging what the execution plans will be. This isn’t about the ACID. That you only need to supply values ...
philhelmer.com
Testing | SQL on the Brain
http://www.philhelmer.com/category/sql-server/testing
SQL on the Brain. Test Data Builders at SQL Saturday Las Vegas (Sept 12). September 10, 2015. At SQL Saturday Las Vegas. Sept 12, 2015), I’ll be presenting about test data builders. I’ve attached the slide deck and demo files to this post for your convenience. They’re also available directly from the SQL Saturday site, just visit my session summary. Building Your Way to Better Database Testing – Phil Helmer – SQL Saturday LV 2015 #436.zip. Click to email this to a friend (Opens in new window). You will a...
philhelmer.com
Phil Helmer | SQL on the Brain
http://www.philhelmer.com/author/philhelmer
SQL on the Brain. All posts by Phil Helmer. Summit15 Guidebook is out / Argenis Without Borders 2.0. October 23, 2015. If you’re attending the PASS Summit. Next week in Seattle, there is a must-have item to pack onto your phone: the Guidebook. App It’s a one stop shop for all things Summit in a neat little package. If you don’t have an Android or iPhone, you can still access the same content via web browser. And karaoke party on Tuesday. On another Summit note, Argenis Without Borders 2.0. Click to share...
philhelmer.com
SQL Server | SQL on the Brain
http://www.philhelmer.com/category/sql-server
SQL on the Brain. Category Archives: SQL Server. Summit15 Guidebook is out / Argenis Without Borders 2.0. October 23, 2015. If you’re attending the PASS Summit. Next week in Seattle, there is a must-have item to pack onto your phone: the Guidebook. App It’s a one stop shop for all things Summit in a neat little package. If you don’t have an Android or iPhone, you can still access the same content via web browser. And karaoke party on Tuesday. On another Summit note, Argenis Without Borders 2.0. Click to ...
ladimolnar.com
Personal Projects | Ladislau Molnar
https://ladimolnar.com/personal-projects
Welcome to my digital home. Automating tests for T-SQL code. How to Customize an ItemsControl. SQL Indexes and Concurrency. Here are my personal projects that are available online. A NET class library written in C#. It can be used to parse the Bitcoin blockchain. The sources are available on GitHub. Also available as a NuGet. CodeCrowd is a SCRUM Project Management tool. Written in Silverlight and ASP.NET. Available on https:/ www.codecrowd.com. The ultimate Windows Phone chess clock. It has a number...
gui-at.blogspot.com
LC Blog: 7/1/14 - 8/1/14
http://gui-at.blogspot.com/2014_07_01_archive.html
Tuesday, July 29, 2014. The initial design proved itself to be working nicely so I've stuck to it:. Android tablet in each kiosk connected to the Internet via 3G Wi-Fi router. Tablets with 3G modem are more expensive and every kiosk had already been equipped with 3G Wi-Fi router because of the previous system. HTML SPA (Single Page Application) as client POS application running in the browser on the tablet. JavaScript Azure Mobile Services (AMS) with SQL database as server. POS as web page. All AMS endpo...
lexicalclosures.blogspot.com
Lexical Closures: Database schema changes unit tested using TSQLUnit
http://lexicalclosures.blogspot.com/2010/03/database-schema-changes-unit-tested.html
Tuesday, March 30, 2010. Database schema changes unit tested using TSQLUnit. How does one test the existence of a primary key (PK) constraint belonging to a table in a database? Just write a test that intentionally violates that constraint. One's initial impulse would be to write a test inspecting the data contained within the PK's table. This approach is sensible and can be viewed as the conventional state-based style of testing. Let's try it. The following test using TSQLUnit. Instead, it can be tested...
philhelmer.com
How Test Data Builders Help You Sleep | SQL on the Brain
http://www.philhelmer.com/2015/04/09/how-test-data-builders-help-you-sleep
SQL on the Brain. How Test Data Builders Help You Sleep. April 9, 2015. This isn’t a full-on sales pitch for data builders. Rather, it is only a testimonial of how they make my life easier. Some developers have to start with an empty database. Others have some minimally-populated db that they add to on an as-needed basis. Still others can use a scrubbed copy of production data, which is excellent for judging what the execution plans will be. This isn’t about the ACID. That you only need to supply values ...
philhelmer.com
Automation | SQL on the Brain
http://www.philhelmer.com/tag/automation
SQL on the Brain. How Test Data Builders Help You Sleep. April 9, 2015. This isn’t a full-on sales pitch for data builders. Rather, it is only a testimonial of how they make my life easier. Some developers have to start with an empty database. Others have some minimally-populated db that they add to on an as-needed basis. Still others can use a scrubbed copy of production data, which is excellent for judging what the execution plans will be. This isn’t about the ACID. That you only need to supply values ...