SQL Server Database Recovery

A Quick Overview of Differential Backups in SQL Server

Learn all about differential backups; their working, and when to put them to use. SQL Server databases are the ones which are not used for storing any ordinary data. All the medium, small, as well as the enterprise level organizations that make use of this software, also give equal importance and emphasis to the backups of these databases. Backing up SQL Server databases is one of the most important things you need to do when using them. And when it comes to backing up SQL Server data,...

Read more »

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 »