News & Information

This week at Ignite 2017 in Orlando, Microsoft announced Azure Data Factory V2 with new features including Control Flow, VNET support, On-Demand Spark execution and SSIS in the cloud. This is a first look at ADF V2....More

Learn how to start using PowerShell with this ebook. It covers almost any question you may have regarding PowerShell and its applications. This guide to learning PowerShell presents a wide range of topics which will leave you with an abundance of knowledge....More

Practical use cases for finding a maximum matching are quite obvious--for example, maximum utilization of agents. But what could be practical use cases for finding a maximal matching? Here's what you need to know....More

Use the expert tips provided in this tech brief to master SQL Server in record time, save hours with powerful task automation, optimize SQL with a couple clicks, easily compare and sync SQL Server data and schemas, and increase your job security by becoming indispensable to your organization....More

August 12, 2017 marked the first day of Tech Outbound’s SQL Cruise Alaska. After 3 years away, SQL Cruise returned to Seattle under hazy skies from the forest fires burning in Central British Columbia....More

A few years ago, I stumbled onto a T-SQL puzzle. It recently occurred to me that there must be some practical use cases for it. If I managed to find those, I could probably also find existing optimized algorithmic solutions--and, based on those, work on T-SQL adaptions....More

If you’ve been following this series, you know that in part one, I addressed reasons for upgrading to Microsoft SQL Server 2016, as well as some pre-upgrade tasks to be mindful of, and in part two, I focused on tasks that should take place during the upgrade. Now, in part three—the final installment—we’ll cover the post-upgrade tasks.
After the Upgrade...More

Microsoft Centralizes their Online Product Documentation and Forums
Microsoft Corporation has now provisioned a new portal for all their application/framework documentation and are also placing the ability to add to that content at your fingertips. The new docs.microsoft.com rolled out recently and provides a jumping-off point for their documentation covering each of the following topic groups arranged by product line/focus:...More

In lieu of System Administrator Appreciation Day (SysAdminDay.com) coming up on July 27, 2017 and for a little fun with a lot of reward, we have rolled out a Discover Your Technology SuperPower Sweepstakes....More

Heard on Social

From the Blogs

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More