Database Recovery

Understanding Adaptive Query Processing Mechanism in SQL Server

Learn about the Adaptive Query Processing Mechanism, and what all it includes. The Query Optimization feature in SQL Server works pretty well for deciding which execution plan will work best for any given query. It not only selects the cheapest plan, but also takes into account rows in a table. However, using the query optimizer for selecting the best execution plan is not always the best idea. At times it can also misjudge the tables and size of your database, thus selecting a plan that...

Read more »

Learn about Waterfall Charts and Power BI Funnels in SQL Server

The article will stuff your brain with the concepts of Waterfall Charts and Power BI Funnels in SQL Server Aren’t waterfalls awesome? But you know what beats them! Waterfall charts in SQL Server and Power BI Funnels! What are waterfall charts? Why do we use Power BI Funnels? What all we can do with these tools in SQL? Let’s find out more about these exciting tools of SQL in details.  What are Funnels charts? A waterfall chart simply makes you aware about the variance or changes in a...

Read more »

How to Integrate SQL Server Source Control with SSMS

This article discusses the ways in which developers can integrate SQL source control with SSMS If you are working as MSSQL DBA or developer for any organization, you might have come across the challenge of integrating the source code with SQL Server Management Studio (SSMS). This article will discuss the solution to the problem in detail. Add Source Control Plug in to SSMS You need a good Source Control system for business; one good example is Microsoft Team Foundation Server 2012, and...

Read more »