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
117 reads
Vinay Thakur
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
32 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
37 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
367 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
723 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
302 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
758 reads
Docker Swarm
As we studied the basics of Docker and container and containerization , Docker – is a open-source platform to have multiple light...
2019-01-28
392 reads
Containerization
Docker has containers to work on processes or application. now docker containers has some limitations as it uses resources from...
2019-01-19
118 reads
Error – Hung Docker
Sometime when you not actively working on Docker and on you are not actively working on the system. it could...
2019-01-19
199 reads
Blogs
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Forums
Master Data - Relational or Dimensional modeling?
Dears, In my company, we have certain master data domains like customer; Vendor; Product;...
Convert columns result into rows with comma and single quotes
Hi All, Hi All, I want to convert columns result into rows with comma....
Does multi-subnet with standardeditionofsqlserver supports DB Mirror Or AG group
Does multi subnet failover with standard edition of sqlserver supports DB Mirror or AG...
Ask SSC