Knowledge Sharing
Pages
Cloud
AI-ML
SQL Arch.
Demo
Performance Issues
PostgreSQL
Scripts
Finance
Fabric
SQL Server: How to track progress of CREATE INDEX command?
Read more »
Script to get the start and end time of SSRS subscribed reports
Read more »
Artificial Intelligence and Machine Learning
Read more »
How to restore backup from Azure
Read more »
How to calculate cost function J(θ0, θ1) - Machine Learning
Read more »
MariaDB Galera Cluster in CentOS 7
Read more »
Elastic search duplicate document check
Read more »
Query To Read Deadlock details From Error Log
Read more »
Command not found error mssqlctl and mssql-tools on ubuntu
Read more »
SQL Server on Kubernetes with Ubuntu OS
Read more »
Enable Delayed messages with RabbitMQ
Read more »
SQL Server current session status
Read more »
TDE enabled Log shipped backup compression
Read more »
SSRS installation failure on existing cluster node
Read more »
How to Remove the Hyper-V role from windows 10
Read more »
Installation of Elastic-search on ubuntu
Read more »
List all the foreign keys referencing a database in SQL Server
Read more »
Gitlab Installation on Ubuntu
Read more »
Installation of MySQL master-slave replication on CentOS
Read more »
How to find port for windows services ( Analysis Services)
Read more »
SQL Server could not spawn FRunCommunicationsManager thread
Read more »
Replication | Not able to shrink Log file
Read more »
Windows drive shows difference in used space and size of files available in disk
Read more »
Query to find IP, port , connection details of SQL server
Read more »
Tableau Basics
Read more »
SQL Server Agent Service Stopped | The process was terminated due to an internal error in the .NET Runtime at IP 00007FF96A6CEEE5 (00007FF96A690000) with exit code 80131506
Read more »
Script Generates A script to Create all Logins, Server Roles
Read more »
SSISDB database Size is very large | SSIS Maintenance | How to reduce SSISDB size
Read more »
Difference between Where and Having clause
Read more »
How To Check If A String Contains A Substring In SQL Server
Read more »
Physical Join Operators in SQL Server
Read more »
Error: The database principal owns a schema in the database, and cannot be dropped
Read more »
Scripting SQL Server Database Owners
Read more »
How to start Analysis Services that state is "Change Pending..."?
Read more »
SQL Server Isolation Levels
Read more »
How to clear the Proc Cache in SQL Azure
Read more »
How To Explicitly Connect SQL Server Using Specific ( Named Pipes / TCP / Shared Memory ) Protocol : Interview Question
Read more »
List of windows groups having sysadmin in SQL Server
Read more »
Difference between AlwaysOn FCI and AlwaysOn AG
Read more »
Login packet used to open the connection is structurally invalid | Length specified in network packet payload did not match number of bytes read; the connection has been closed
Read more »
How to change the MaxTokenSize on the server computer
Read more »
Audit SQL modifications and get notified in SQL Server
Read more »
What is Online Indexing in SQL Server 2016
Read more »
Step by step Table Partitioning in SQL Server Standard Edition
Read more »
SQL Server 2017 Installation on Ubuntu 16
Read more »
Table Structure in SQL Server
Read more »
Need VIEW DEFINITION permissions per database
Read more »
How to set "Dark Theme" for SSMS 17.3
Read more »
SMS SQL Agent Job alert
Read more »
SAS Administration Checklist
Read more »
Table index details in SQL Server
Read more »
Script Database permission in execute mode
Read more »
How to find SQL Server database owner for all databases
Read more »
Automate failed SSRS Subscriptions
Read more »
SQL server job name and Job owner
Read more »
SQL Server Startup Options
Read more »
When windows server last rebooted?
Read more »
Task Scheduler Error 2147944309
Read more »
SQL Backup Audit Report
Read more »
Is it safe to delete the "Update Cache" folder?
Read more »
When backup / restore will finish (ETA) in SQL server
Read more »
How to determine the progress of a SQL Server backup or restore process?
Read more »
SQL Server agent job schedule modification by non-admin permission
Read more »
Contained Database in SQL Server
Read more »
How to enable / disable Buffer Pool Extension
Read more »
Transparent Data Encryption in SQL Server
Read more »
Ways to compare and find differences for SQL Server tables data
Read more »
Script to find database level roles assigned to database level users
Read more »
Script to find server level roles assigned to Server level logins roles
Read more »
Understanding SQL Server fixed server roles
Read more »
How do I see the full SQL / Query text of a spid?
Read more »
Replication Latency Monitoring Job Automation
Read more »
Get size ,row count and used space of all tables in database in SQL Server
Read more »
How to find statistics on specific table or column in SQL Server
Read more »
Error: ERRSQB: 5145 (Failed to start SQL Backup Agent service.) (): 5 (Access is denied.)”
Read more »
How to find SQL agent job status in SQL Server using query
Read more »
Check all database size and Free Space in SQL Server
Read more »
Calling a SQL Agent Job from another Job on a remote server in SQL Server
Read more »
Not able to upgrade MDS database, scripts missing
Read more »
Replication Scripts
Read more »
Error: Not able to open SQL configuration manager | WMI error | Invalid class [0x80041010]
Read more »
Connect R to SQL Server 2016
Read more »
Installation of R and R Studio
Read more »
How to Install Microsoft SQL Server 2016
Read more »
The error code is 0x80073CF0 in case you need it | Windows 10 Auto update
Read more »
An explicit value for the identity column in table 'product' can only be specified when a column list is used and IDENTITY_INSERT is ON
Read more »
How to Start SQL Server Services
Read more »
Replication Status: Waiting 60 Second(s) Before Polling For Further Changes.
Read more »
How to find Publisher , Publisher server and Publisher databases in SQL Server Replication
Read more »
Script to Find Triggers and its Status in Database in SQL Server
Read more »
Factors Causing Latency in Replication
Read more »
How to find Distributor , Distributor server and Distributor databases in SQL Server Replication
Read more »
Tips to optimize replication in SQL Server
Read more »
Script To Retrieve SQL Server Database Backup History
Read more »
How to automatically execute SQL queries with a batch file (OSQL UTILITY)
Read more »
Demo To Execute SQL Query From Batchfile
Read more »
How to Extract SQL Server Service Pack To Specific Location
Read more »
Cannot Truncate Table Because It Is Published For Replication Or Enabled For Change Data Capture.
Read more »
Difference Between Truncate and Delete
Read more »
Script to Find All Active Transactions Filling Log File in SQL Server
Read more »
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)