Read-only URL removal
When I blog to configure Read only replica. it would require to provide read-only URL information, and provide the replica sequence. but their is no easy way to remove...
2019-10-30
15 reads
Vinay Thakur
Error 9002
This is very important error whenever you see this error it is clear that your database has “TLOG FILE FULL” and this could result into maintenance job failed or...
2019-10-30
25 reads
Fail to cycle errorlog
sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle...
2019-10-29
27 reads
Read-only Replica -AG
Read only replica is a great concept where we can re-direct all the read only connections to that replica. Following are some of the great articles for it....
2019-10-25
119 reads
MSDB Size growing
msdb is growing due to queue. their is a great blog to help to reduce this How to reduce MSDB size from 42Gb to 200Mb query to get object...
2019-09-12
34 reads
Always On: Troubleshooting Consolidated
Working on Always On and configuration/setup of AG we have observed many errors. especially when configuration listener with following error 19471 or AG could not configure: Creating availability group...
2019-08-17
42 reads
Docker – Install Other Open source DB
We can quickly install anything on Docker with hub.docker.com PostgreSQL: $ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres MariaDB: docker...
2019-03-05
379 reads
Informix on Docker
Today we will discuss how to install/configure informix on Docker, >docker run -it –name ifx –privileged -p 9088:9088 -p 9089:9089...
2019-03-04
821 reads
Imp Linux Commands
Important Linux Commands 1. uname -a: To know what version of unix we are using 2. hostname: System name 3....
2019-02-25
352 reads
Configure Kubernetes with minikube
We have discussed about Docker Swarm to know how to use Docker as a Load balance. Today we will discuss about...
2019-02-11
761 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package
Hi I upgraded to new version of VS2019 to 16.11.49. My original SSIS package...
How do I make this one row per id
I've written this code, but it is showing right now as 2 rows per...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers