The ‘Always On Availability Group’ feature is a high-availability and disaster-recovery solution. Since the launch with SQL Server 2012, data professionals have adopted this solution widely. Before implementing ‘Always On Availability Group’, data professionals need to make decisions about availability and failover mode. These decisions will involve discussion with business owners of the applications that […]
View Event: The Magnificent Seven: Intelligent Query Processing in SQL Server Is there a way to fix query performance issues without any code changes? Making application changes can be an expensive undertaking. Hence, developers and DBAs want the query processor to adapt to their workload needs vs. having to use options and trace flags to […]
I want to thank all of the participants of T-SQL Tuesday #132. If I missed your post, it was not intentional. Please let me know, and I will add it here. I am proud of this community and feel lucky to be a small part of it. I admire everyone who joined the blog party […]
View Event: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]
View Event: Azure SQL Database-Business Continuity During Disaster Azure SQL Database is a relational database-as-a-service (DBaaS) based on the latest version of the Microsoft SQL Server Database Engine. You can build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure. While considering Azure SQL Database, two of the […]
