This article shows a simple proof-of-concept workflow that allows an organization to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process.
Read more...

SQL Compare snapshots provide an easy way to keep track of changes during development work, whether they are small changes between iterations, or significant changes between releases. Snapshots can be used to quickly generate rollback scripts during releases even in environments which are isolated by infrastructure design for security reasons.
Read more...

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.
Read more...

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
Read more...

Microsoft HDInsight is the cloud service that deploys and provisions Hadoop clusters on the Azure cloud. It's a completely managed, open source analytics service to support enterprise needs and supports a wide variety of scenarios with the help of open source frameworks like Hadoop, Storm, Spark, R Server and Hive.
Read more...

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.
Read more...

The GDPR is almost here and, just one week before it’s launch, Redgate is hosting the first SQL Privacy Summit in London. The schedule of presentations, panel discussions and workshops has been created to help SQL Server professionals ensure their business meets the new data privacy and protection regulations.
Read more...

The GDPR brings new responsibilities for organizations which need to store and process personal data. Plan for it in the right way, however, and the journey to compliance will be a lot easier.
Read more...

Phil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.
Read more...

Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.
Read more...