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......
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......
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......
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......
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......
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......
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......
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 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......
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......