The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.  Read more...

This webinar will focus on branching and merging with Visual Studio Team Services (VSTS) as part of a DevOps approach to database development. It will also show how Redgate tools plug into VSTS to enable the build, test and deployment of your database changes. There will also be plenty of time to ask Grant and Arneh questions.   Read more...

The use of IoT is growing in businesses.  Read more...

In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.  Read more...

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...

Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.  Read more...

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.  Read more...

Steve wants to know which version of SQL Server you like the best.  Read more...

Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.  Read more...

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...

Steve asks the question today of how you might measure downtime and the scope you are concerned about.  Read more...

Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.  Read more...

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.  Read more...

With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.  Read more...

Learn how you can execute a PowerShell script via the SSIS execute process task.  Read more...

Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.  Read more...

A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists.  Read more...

Learn how you can script specific objects from SSMS and store or update them in a git repository.  Read more...

Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.  Read more...

In memory of Robert Davis.  Read more...