User Shekar Kola

8 votes

Replication in sql server 2019?

answered Oct 21, 2020 at 9:37

6 votes

How can I use SQL Profiler to capture a single stored procedure

answered Aug 14, 2019 at 5:24

5 votes

Accepted

Columnstore Index maintenance and finding fragmentation

answered Dec 5, 2019 at 7:28

5 votes

How can I create a Windows Firewall rule to allow only one IP address to connect MS SQL 2017 Express database in Windows 2016 server?

answered Dec 23, 2019 at 12:11

4 votes

Query to retrieve SQL Server login password length

answered Nov 5, 2020 at 10:22

4 votes

Will one SQL instance work whilst the other 2 are patched?

answered Oct 22, 2019 at 16:48

4 votes

SSISDB master key in an Availability Group

answered Nov 13, 2020 at 7:04

4 votes

Do I need "New SQL Server Failover Cluster installation" to run Availability groups with manual failover?

answered Aug 22, 2019 at 19:15

3 votes

Accepted

Rights to grant for controlling an Availability Group

answered Aug 21, 2019 at 9:38

3 votes

Accepted

All my database on the fail over server showing in "Synchronizing" state

answered Jul 24, 2019 at 7:46

3 votes

Accepted

How to find total used and remaining space in Azure SQL mi

answered Sep 4, 2019 at 19:42

3 votes

How SQL Server caches data in memory

answered Oct 29, 2019 at 19:36

3 votes

How to prevent a full database backup

answered Nov 7, 2019 at 7:11

2 votes

How is calculated fill-factor percentage related to size of database?

answered Oct 29, 2019 at 11:35

2 votes

Windows Logs Application is full of "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]"

answered Nov 28, 2019 at 12:29

2 votes

Accepted

SQL Log Shipping - What is the date time format used by transaction log file name?

answered Oct 27, 2020 at 18:50

2 votes

SQL Server Maintenance Plan - Multiple vs Single Plan / Cleanup History

answered Oct 27, 2020 at 19:39

2 votes

Accepted

Dynamic execution query produces error when called from the procedure, but works when executed manually

answered Nov 3, 2020 at 8:03

2 votes

how to automate DB restore to another server?

answered Nov 7, 2019 at 12:24

2 votes

Restore database with Availability Groups

answered Oct 16, 2019 at 13:37

2 votes

Accepted

How can I get Elastic IP/host from KIbana interface

answered Feb 4, 2020 at 11:43

2 votes

How to sync SQL Server Logins with database User after a restore from another server

answered Oct 11, 2021 at 18:38

2 votes

SQL TDE and Certificate Handling Recommendations

answered Aug 22, 2019 at 9:05

2 votes

How to convert UTC time to New York time zone in Microsoft SQl

answered Aug 22, 2019 at 10:05

2 votes

How to have MS Analysis server setup of both modes: multi dimension and tabular

answered Sep 15, 2019 at 5:01

2 votes

Accepted

How to use parent table column inside subquery JOIN condition?

answered Sep 21, 2019 at 12:00

2 votes

Mixed Editions in a 3 Node SQL Server Always on Availability Group

answered Oct 1, 2019 at 17:00

2 votes

Domain Admin Account Accessing SQL Server

answered Aug 2, 2019 at 15:40

2 votes

trying to connect to MSSQL server using named pipe in HeidiSQL

answered Aug 7, 2019 at 18:30

2 votes

SQL Server Backup Database not .bak file format

answered Aug 8, 2019 at 9:35

Stack Exchange Network

131 Answers

Replication in sql server 2019?

How can I use SQL Profiler to capture a single stored procedure

Columnstore Index maintenance and finding fragmentation

How can I create a Windows Firewall rule to allow only one IP address to connect MS SQL 2017 Express database in Windows 2016 server?

Query to retrieve SQL Server login password length

Will one SQL instance work whilst the other 2 are patched?

SSISDB master key in an Availability Group

Do I need "New SQL Server Failover Cluster installation" to run Availability groups with manual failover?

Rights to grant for controlling an Availability Group

All my database on the fail over server showing in "Synchronizing" state

How to find total used and remaining space in Azure SQL mi

How SQL Server caches data in memory

How to prevent a full database backup

How is calculated fill-factor percentage related to size of database?

Windows Logs Application is full of "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]"

SQL Log Shipping - What is the date time format used by transaction log file name?

SQL Server Maintenance Plan - Multiple vs Single Plan / Cleanup History

Dynamic execution query produces error when called from the procedure, but works when executed manually

how to automate DB restore to another server?

Restore database with Availability Groups

How can I get Elastic IP/host from KIbana interface

How to sync SQL Server Logins with database User after a restore from another server

SQL TDE and Certificate Handling Recommendations

How to convert UTC time to New York time zone in Microsoft SQl

How to have MS Analysis server setup of both modes: multi dimension and tabular

How to use parent table column inside subquery JOIN condition?

Mixed Editions in a 3 Node SQL Server Always on Availability Group

Domain Admin Account Accessing SQL Server

trying to connect to MSSQL server using named pipe in HeidiSQL

SQL Server Backup Database not .bak file format