SQL Server Blogs


-> Disaster Recovery Using AlwaysON Availability Group – Scenario 1
-> Disaster Recovery Using AlwaysON Availability Group – Scenario 2
-> Configuring Read Only Routing List for AlwaysON Availability Group
-> Reporting Services using AlwaysON Availability Group
-> Difference between Readable Secondary setting Yes and Read Intent only
-> Moving all Availability Groups in the Event of a Single Availability Group Failover
-> AlwaysON – Login Synchronization across Replicas
-> AlwaysON – Working through Crashed Synchronous Secondary Replica
-> Creating Linked Server to a Multi-Subnet Availability Group Listener with ReadOnly routing
-> AlwaysON – How to disable Read-Only routing for an Availability Group
-> AlwaysON – Unable to access the ‘JB1’ database because no online secondary replicas are enabled for read-only access. (Microsoft SQL Server, Error: 982)
-> None of the IP addresses configured for the availability group listener can be hosted by the server ””
-> Always ON Availability group automatic failover to a particular node
-> Listener entry in sys.availability_group_listeners exists even after related Availability group is deleted
-> Finding Transaction latency in an Always on Synchronous replica
-> Application Timeout with Multi-subnet Always On Availability Group
-> Adding Transparent Data Encryption (TDE) Enabled User Database to Always On Availability Group
-> Database Backup and Maintenance job to use secondary replica on a SQL Instance with Always On Availability group
-> Availability Group – SQL Server Agent Job to run only on Always On Primary Replica


-> Creating a SQL database in Microsoft Azure portal
-> Restore on-Premise SQL server database to Azure SQL Database
-> Backup On-Premise SQL Server Database to Microsoft Azure

Azure Managed Instance

-> My first Azure Managed instance
-> Connecting to Azure Managed instance from a virtual machine
-> Checking SQL Server errorlog in Azure Managed Instance
-> Trace Flags enabled in Azure Managed Instance
-> Is Trace Flag 1117 enabled in Azure Managed Instance?
-> Restore a database backup to an Azure Managed Instance
-> Physical_database_name column in sys.databases
-> Sp_configure on Managed instance
-> GETDATE() on Managed Instance


-> Hide Instance set to YES in SQL server Network Configuration
-> Server TCP provider failed to listen on [1519]. Tcp port is already in use.
-> Using certificates with SQL server
-> Logshipping metadata table log_shipping_monitor_secondary is not getting updated
-> Restore Database – Property BackupDirectory is not available for Settings ‘Microsoft.SqlServer.Management.Smo.Settings’
-> RESTORE detected an error on page (0:0) in database “Database” as read from the backup set.
-> Error: 18456, Severity: 14, State: 5. Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Reason: Could not find a login matching the name provided.
-> MYSQL Linked server in SQL Server
-> Removing IAM page %S_PGID failed because someone else is using the object that this IAM page belongs to


-> Restoring a Transparent Data Encryption (TDE) Enabled User Database on a SQL Server Instance with a different master key
-> Remove Transparent Data Encryption (TDE)


-> SQL Server Parameter Sniffing
-> Install and Configure PSSDIAG
-> Install and Configure SQLNexus
-> Trace Flag 7471
-> Tempdb contention
-> Optimize for ad hoc workloads
-> Column data may be deleted when you update another variable-length column in a table of a database upgraded from SQL Server 2005
-> Why Bookmark Lookup is BAD?

-> Optimizing Queries using XML in SQL Server


-> Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.
-> Finding Undistributed commands in Transactional replication


-> Database ‘model’ cannot be opened. It is in the middle of a restore.
-> SQL resources not coming online after patching
-> The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘msdb’. You should correct this situation by resetting the owner of database ‘msdb’ using the ALTER AUTHORIZATION statement.

-> SQL services fails after applying service pack
-> Error 1311.Source file not found: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Update Cache\KB4018073\ServicePack\redist\VisualStudioShell\VC10SP1\vc_red.msi. Verify that the file exists and that you can access it.


-> Creating DTSX files from existing SQL Services Integration packages


-> SQL Server Reporting Services Encryption Key Backup
-> SQL Server Reporting Services – The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead.


-> Stretch Database in SQL Server 2016
-> Adding a table to the stretch database
-> Disabling Stretch Database
-> Stretch database – Modifying the filter function

TSQL & Powershell

-> Query To get Table Statistics Details
-> TSQL to query commandlog table to check Alter Index duration
-> Script to list size of all tables in a SQL Server database
-> TSQL Queries related to Database Backup and Restore
-> TSQL query to find Enterprise features availability in a SQL Server Instance
-> Identifying databases that are no longer used
-> Archival Report – Getting before and after row count post data archival
-> Execute job step if a job is not running
-> Restore PRIMARY Filegroup only on a database using full backup
-> Viewing Allocation Unit Size of a NTFS Disk