Database Support
- SQL Server Diagnostics and figuring out what is running slow.
- SQL Server Health Check – 78+ point check list.
- SQL Query Performance Tuning, indexing, etc.
- Maintenance plan, backup, DBCC CHECKDB, etc.
- Log Shipping, Replication, Mirroring, AlwaysOn Availability
- Failover clustering
- Security, Auditing.
- SSIS, SSRS and SSAS.
Find Currently running Queries in SQL Server
I am always using this script to find which queries are currently running on my SQL Server and which queries are running for a…
Continue Reading Find Currently running Queries in SQL Server
Introduction of Java programming
Java programming Java is an Object-oriented programming language. Everything in Java is object-based and it required to create an Object to access anything in the Java…
What is Java Programming?
Java is a computer programming language. Mr. James Gosling designed Java in the year 1991 and he was from Sun Microsystems Company. Firstly, Java was…
Update statistics with full Scan all tables in sql server database
We all know to keep auto statistics update ON for a SQL server databases little overkill the performance and query may or may not…
Continue Reading Update statistics with full Scan all tables in sql server database
How to Install SSL Certificate on Linux Apache Web Server
SSL stands for Secure Sockets Layer, the protocol that provides the encryption. It provides secure, encrypted communications between a website and an internet browser.…
Continue Reading How to Install SSL Certificate on Linux Apache Web Server
What is Let’s Encrypt free SSL certificates
Let’s Encrypt – Free SSL Certificates The web is fast turning to a battleground where the good guys are working extremely hard to ensure…
Continue Reading What is Let’s Encrypt free SSL certificates