SSMS 18.x cannot find right version of most recent backup

I used 18.4 , from the menu,click restore database, it lists the full backup two weeks ago, but we …

Using result of previous function call in SQL Server... or any better idea

I use a recursive CTE ;WITH cte ( -- anchor UNION ALL -- recursive parte ) SELECT * INTO #Reser…

SQL 2017 Schema access issue

HI, I have restored database from SQL 2016 to SQl 2017, All permission and logins were copied and a…

a good book on stored procedures

Could someone recommend a good book on SQL programming on Stored procedures, functions, triggers? I…

Always on AG Dashboard report

Comments posted to this topic are about the item Always on AG Dashboard report

Delet old backup in azure

Hello, How to delete backups in blob storage from azure sql server VM to maintain retention ? Inste…

Concurrency Control in SQL Server

Comments posted to this topic are about the item Concurrency Control in SQL Server

Tempdb Default Size

Comments posted to this topic are about the item Tempdb Default Size

Daily Coping 11 May 2020

Today’s tip is tell someone about why your favorite music means a lot to you. My thoughts: http://v…

Connection time out SQL 2017

Hi Team, I am getting this message while I try to connect to a new SQL Sever 2017 server : Connecti…

Creating a User Account on a database

Hi Im a bit rusty with SQL and Im moving over into administration a little more now. Ive created a …

Question on Full database backups

Hi All, I have doubt on database backups. I usually use below query to know the estimation completi…

How do I append records to a table via SSIS?

Basically, I just need to know how to append records to a table via SSIS?

Error while executing stored procedure

Hi Team, I am getting the below error while I am executing a stored procedure from my local. But wh…

How to get column names in the row wise along with their values