Warning: count(): Parameter must be an array or an object that implements Countable in /homepages/37/d545468783/htdocs/clickandbuilds/SQLWorldWide/wp-includes/post-template.php on line 317
×

High Availability

Auto-failover Groups – GracePeriodWithDataLossHours

March 31, 2021

The auto-failover groups feature for the Azure SQL database can be configured with an automatic failover policy. Azure triggers failover after the failure is detected and the grace period has expired. Grace period is determined by a setting called ‘GracePeriodWithDataLossHours’ that cannot be set under one hour. Why is it not allowed to set a […]

Executive Summary – Always On Availability Group

December 20, 2020

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 […]

Panelist at HA/DR Open Q&A Extravaganza

December 6, 2019

HA/DR Open Q&A Extravaganza is on December 10th, 2019, at 1 PM EST. This event is one of the most extensive lineups of SQL Server HA/DR experts in history, and any question goes! ! Organized by High Availability and Disaster Recovery PASS virtual group. I am honored, humbled, and super excited to be part of this panel. […]

How to Exclude Read_Only Databases Using sp_MSforeachdb

March 28, 2017

I will explain how you can use sp_MSforeachdb stored procedure against READ_WRITE database only. There are numerous articles on the web about excluding databases using database id or name. Recently I needed a script to run against databases that are part of Always On Availability Groups and in READ_WRITE status. I used the ‘Updateability’ properties […]

SQL Server Fullscan Statistics Being Overwritten with Sample Statistics

March 3, 2017

I observed this behavior only in the following version of SQL Server while using Always On Availability Group feature. Version: Microsoft SQL Server 2012 (SP3) (KB3072779) – 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 9600: ) In this article by David Barbarin […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Happy Friday! Anyone else feel like June is flying by? Just us? But that's OK because it means we're that much closer to... next week when @SQLvariant will be presenting "Why Jupyter Notebooks are Changing Everything". Remember to RSVP and join us! https://www.meetup.com/NESQLUG/events/277115798/

Happy Friday!
Do not forget to sign up for a talk by @AnalyticAnna
"Don't miss the bus: Functions, Azure SQL, ... Geospatial, JSON"
Registration details:
https://www.meetup.com/dbavug/events/276911440/
Wednesday, June 23rd, 2021
2:00 PM EDT
1800 GMT
#Azure #AzureSQL

There’s still time to submit your last-minute PASS Data Community SUMMIT abstract – CFS closes in just over 12 ... hours! Grow your speaking experience, share your expertise & help your community learn more about the #Microsoft #data platform.

Submit now: http://ow.ly/rta750FcyNW

T - 7 days
@AnalyticAnna will be talking about:
"Don't miss the bus: Functions, Azure SQL, Geospatial, JSON"
... Registration details:
https://www.meetup.com/dbavug/events/276911440/
Wednesday, June 23rd, 2021
2:00 PM EDT
1800 GMT
#Azure #AzureSQL

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */