You may find that one or more availability group databases is reported ‘Not Synchronizing / Recovery Pending’ on the primary replica or ‘Not Synchronizing’ on one of the secondary replicas. Despite this, your availability group replicas report they are in the primary role or secondary role,

(Chris Webb) Following on from my post last week about M functions that are only available in custom data extensions, here’s a quick explanation of one of those functions: Extension.Contents().

(Kenneth Fisher) A while back I did a post about why you shouldn’t shrink your data file. This one is going to be similar in some ways, different in others.

(Pinal Dave) Many DBAs use sp_readerrorlog or xp_readerrorlog to read ERRORLOG files in SQL Server. SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location

(Arun Sirpal) If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE.

(Denny Cherry) The short answer is that yes there are ports that you’ll want to block outbound by default. There’s a variety of amplification attacks that you have the possibility of being a member of. These attacks aren’t against your systems, but you run the risk of your machines being used to am

(Parikshit Savjani) In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can successfully run and scale their Tier 1 mission critical workloads and applications on SQL Server.

(Melissa Coates) I’ve been asked numerous times where to start when it comes to Azure. Getting a handle on Azure concepts, terminology, and features can be more than a little intimidating. Not only is Azure an extremely large platform, the pace of change is *very* fast.

(Kenneth Fisher) I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. I should point out here that I really enjoy dynamic SQL. I find it fairly intuitive and always enjoy the challenge, so I’ve gotten pretty good at it.

(Anoop Kumar) Technology is changing rapidly, and newer versions of software products and tools are coming to market. It’s always recommended to migrate the applications to newer versions to get the benefit of the upgraded and enhanced versions.