Hi 

Do take note of the Always Encrypted Limitations

https://blogs.sentryone.com/aaronbertrand/t-sql-tuesday-69-always-encrypted-limitations/

Hi Myukas,

Below is another way to export schema only of your objects via MSSQL 

1. Right click on the database > Tasks > Generate Scripts... > Next

2. Choose...

Hi

Under services, please check if SQL Server Agent Startup Type is set to Manual

December 5, 2017 at 8:59 pm

#1970834

The following are the benefits of using stored procedures in SQL Server rather than application code stored locally on client computers include:
·         They allow modular programming.
...

Hi

The act of changing the compatibility level tells the database to change its feature set. That is, some features will be added, but at the same time some old features...

Hi

When you said that “the log file is very big”, I could imagine that bulk of the database size (sp_spaceused) is due to huge transaction log...

You might also want to explore a free tool called  draw.io

https://www.draw.io/

Hi Alex,

I created similar diagrams using MS Visio.

Best Regards,
Ricky

Hi Sir,

I think you cannot do that. There are specific requirements for configuring AG listener.

Requirements for the DNS Name of an Availability Group Listener
...

Hi Sir,

You mayrefer to Brad'sSure DBA Checklist article 

https://www.red-gate.com/simple-talk/sql/database-administration/brads-sure-dba-checklist/

It has Clustering, Performance tuning, Indexing, HA/DR checklist, etc.

I hope this...

HI G Sunny,

Based on the screenshot that you sent me, you have to check from the Windows Server Failover Cluster (WSFC) perspective.  You have to verify whether or not the...

We also go for parallel upgrade instead in-place upgrade

Hi G Sunny,

What does the error logs show at the time when it failed over.
Is there any error thrown when you attempt to failback to primary?...

Hi twin.devil,

Awesome! Thank you very much!

Best Regards,

Hi

AG Listener creation failure is typically due to lack of permission for the Cluster Name Object (CNO) in Active Directory. Approach your Active Directory Administrator and request for...