Posts filed under: development
Planning Upgrades, Migrations, Consolidations.. SQL and more
Steve Jones posted a good editorial a month or so ago about why he typically prefers side-by-side migrations over in-place upgrades. If you are running virtualized and want to upgrade in-place then it is not horrendous if you need to revert back...
Gaps and Islands – Determining Continuous Hours
T-SQL Master Itzik Ben-Gan covered different solutions in SQL Magazine quite a few years ago, and there are many other articles out there about it. I thought I would give a current example we were solving where this came into...
Linked Server Inconsistent Meta Data Error and Synonyms
* Featured image from In most of our more recent tools we have a single layer in the ETL Staging solution that understands all of the connections to other systems / databases that need to be made. This layer is...
Microsoft Visual Studio 2017 Launched
Microsoft Launched Visual Studio 2017 a couple weeks ago. The launch included quite a few videos on new features and solutions people are using to solve problems. Take a look at the descriptions to see if anything speaks to you....
Splitting User Stories and Hamburgers
On paper writing a good user story sounds easy. “As a … I want.. So that I can”. While that may convey the basics it does not always actually tell the story. Roman Pichler lays out 10 Tips For Writing...
Microsoft Levels Features in SQL 2016
With SQL 2016 SP1 Microsoft has started to level features out across the editions. Many options that were previously enterprise only, can now be used in other editions, such as standard. Each edition still has differences in the amount of...
Moving SET NOEXEC OFF in SQLCMD deployment scripts
Currently when we build deployment packages we try to validate that the deployment is properly configured for the customer site to reduce errors. We do this by validating the version number, the database it is pointed to, connections are working,...
Better User Stories Mini Course Free for Two Weeks
Mike Cohn over at Succeeding with Agile has a mini course on writing better user stories that he is making available for 2 weeks. This 20 minute training looks at some of the common mistakes people make at the early stage of...
The State of Machine Learning
Shivon Zilis and James Cham posted a list outlining the Competitive Landscape for Machine Learning over on HBR. Here is the infographic. The State of Machine Intelligence Have you played with any of the open source data sets or...
Deployment FAQ: Oracle Driver and Linked Server Setup
For many of our tools we routinely need to pull data from an Oracle server. In order to connect; SQL Server needs to understand how to talk to Oracle. This is true whether you are using a linked server to...