(Terrence Dorsey) Writing software is a complicated process. These new Visual Studio 2013 and 2015 extensions help your projects stay on schedule.
Author: SSWUG Research
How to Get SQL Server Data-Conversion Horribly Wrong
(Robert Sheldon) One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit data conversion is a good feature for the expert but can cause a lot of trouble to the unwary.
EF6 Code First Migrations for Multiple Models
(Julie Lerman) Entity Framework 6 introduced support for Code First Migrations to better handle storing data for multiple models in a single database. But the support is very specific and may not be what you imagine. In this article, you’ll learn about this feature, what it does and doesn’t do, and
SQL SERVER – Backup and Restore Behavior of ReadOnly Filegroup Databases
(Pinal Dave) Last week I wrote about SQL SERVER – Marking Filegroup as ReadOnly with SQL Server and it got me interested into few key questions. One of the questions someone asked was, how will backups behave? Are there anything I need to know about ReadOnly Filegroups?
Running Selenium Tests using Node.js
(Dean Hume) Browser automation is a great way to automate and test repeatable tasks in the browser. I’ve always been interested in browser automation and testing using tools such as Selenium. If you are looking for a way to ensure that your website runs as expected in many different browsers and dev
SQL30082N – ROOT CAPABILITY REQUIRED
(Jack Vamvas) An application owner reported an error
Look at Blocking By Index
(Michael J. Swart) This post is for me. It’s a script I find useful so I’m putting it in a place where I know to go look for it, my blog. You may find it useful too.
SSDT Myths #1 – SSDT only works with TFS
(Ed Elliott) I was reading a white paper from a Sql Server tools vendor about how to integrate their tools with SSDT and while it was very interesting there were a couple of inaccuracies and I wanted to clear one of them up and also to help people understand that although SSDT is integrated to Visua
MySQL Enterprise Incremental Backup simplified
(Shinguz) MySQL Enterprise Backup (MEB) has the capability to make real incremental (differential and cumulative?) backups. The actual releases are quite cool and you should really look at it…
12c Parallel Execution New Features: Concurrent UNION ALL – Part 2
(Randolf Geist) In the first part of this series I’ve focused on the parallel degree chosen by the optimizer when dealing with the new concurrent UNION ALL feature.