Back to school
Hey, I realize that future we need to know Database system, No SQL and Big Data. with that as things are moving to machine learning and AI system which...
2019-11-02
24 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
29 reads
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
30 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
31 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
128 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
49 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
52 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
388 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
844 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
361 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers