Knowledge Sharing

Pages

  • Cloud
  • AI-ML
  • Finance
  • Fabric
  • SQL Arch.
  • Performance
  • PostgreSQL
  • Demo
  • Scripts

TDE enabled Log shipped backup compression


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SSRS installation failure on existing cluster node


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How to Remove the Hyper-V role from windows 10

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Installation of Elastic-search on ubuntu


Read more »
9 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

List all the foreign keys referencing a database in SQL Server



Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Gitlab Installation on Ubuntu


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Installation of MySQL master-slave replication on CentOS


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How to find port for windows services ( Analysis Services)

Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SQL Server could not spawn FRunCommunicationsManager thread

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Replication | Not able to shrink Log file


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Windows drive shows difference in used space and size of files available in disk


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Query to find IP, port , connection details of SQL server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tableau Basics


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

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 »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Script Generates A script to Create all Logins, Server Roles

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SSISDB database Size is very large | SSIS Maintenance | How to reduce SSISDB size


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Difference between Where and Having clause

Read more »
2 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To Check If A String Contains A Substring In SQL Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Physical Join Operators in SQL Server



Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Error: The database principal owns a schema in the database, and cannot be dropped

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Scripting SQL Server Database Owners

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How to start Analysis Services that state is "Change Pending..."?

Read more »
6 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SQL Server Isolation Levels


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How to clear the Proc Cache in SQL Azure

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To Explicitly Connect SQL Server Using Specific ( Named Pipes / TCP / Shared Memory ) Protocol : Interview Question



Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

List of windows groups having sysadmin in SQL Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Difference between AlwaysOn FCI and AlwaysOn AG

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

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 »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How to change the MaxTokenSize on the server computer

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Audit SQL modifications and get notified in SQL Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

What is Online Indexing in SQL Server 2016

Read more »
3 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Step by step Table Partitioning in SQL Server Standard Edition


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SQL Server 2017 Installation on Ubuntu 16


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Table Structure in SQL Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Need VIEW DEFINITION permissions per database


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How to set "Dark Theme" for SSMS 17.3

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Categories

AI-ML (24) Accounting (1) Analytics (19) Audit (7) Automation (3) Azure (17) Cloud (19) Column Store Index (3) Connectivity (6) Data science (3) Dead Lock (5) Demo (36) Difference Between (15) Docker (1) Fabric (6) Finance (6) Firewall (2) GCP (11) High Availability (3) Hive (3) Indexes (15) Interview Questions (7) Java (1) Kubernetes (4) ML (1) MYSQL (1) Machine Learning (3) MariaDB (1) Memory (7) Must Read (3) Non SQL (3) OS (4) PDW (5) Partition (2) Performance Issues (18) Performance Scripts (3) PostgreSQL (7) Power Shell (4) Protocols (4) Python (3) Quick Audit (2) R (2) RabbitMQ (1) Registry Query (1) Regression (2) Replication (21) Robocopy (1) SPN (2) SQL Architecture (34) SQL Internals (14) Scripts (87) Sql Cluster (5) Statistics (8) Tableau (1) Third Party Tool (3) Tips & Tricks SQL Server (5) Trace flags (2) Ubuntu (3) Visual Studio (1) What is ? (7) XP_CMDSHELL (3) hadoop (2) litespeed (1)

Total Pageviews

Followers

Archive

  • ►  2024 (32)
    • ►  September (4)
    • ►  August (3)
    • ►  July (3)
    • ►  June (5)
    • ►  March (1)
    • ►  February (6)
    • ►  January (10)
  • ►  2023 (4)
    • ►  December (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2022 (11)
    • ►  December (1)
    • ►  November (1)
    • ►  September (2)
    • ►  April (3)
    • ►  January (4)
  • ►  2021 (1)
    • ►  January (1)
  • ►  2020 (13)
    • ►  May (8)
    • ►  March (2)
    • ►  February (2)
    • ►  January (1)
  • ►  2019 (15)
    • ►  December (3)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  July (2)
    • ►  June (1)
    • ►  May (1)
    • ►  March (4)
    • ►  February (1)
  • ▼  2018 (36)
    • ▼  December (1)
      • TDE enabled Log shipped backup compression
    • ►  November (1)
      • SSRS installation failure on existing cluster node
    • ►  October (3)
      • How to Remove the Hyper-V role from windows 10
      • Installation of Elastic-search on ubuntu
      • List all the foreign keys referencing a database i...
    • ►  September (2)
      • Gitlab Installation on Ubuntu
      • Installation of MySQL master-slave replication on ...
    • ►  August (5)
      • How to find port for windows services ( Analysis S...
      • SQL Server could not spawn FRunCommunicationsManag...
      • Replication | Not able to shrink Log file
      • Windows drive shows difference in used space and s...
      • Query to find IP, port , connection details of SQL...
    • ►  July (4)
      • Tableau Basics
      • SQL Server Agent Service Stopped | The process was...
      • Script Generates A script to Create all Logins, Se...
      • SSISDB database Size is very large | SSIS Maintena...
    • ►  June (6)
      • Difference between Where and Having clause
      • How To Check If A String Contains A Substring In S...
      • Physical Join Operators in SQL Server
      • Error: The database principal owns a schema in the...
      • Scripting SQL Server Database Owners
      • How to start Analysis Services that state is "Chan...
    • ►  May (8)
      • SQL Server Isolation Levels
      • How to clear the Proc Cache in SQL Azure
      • How To Explicitly Connect SQL Server Using Specifi...
      • List of windows groups having sysadmin in SQL Server
      • Difference between AlwaysOn FCI and AlwaysOn AG
      • Login packet used to open the connection is struct...
      • How to change the MaxTokenSize on the server computer
      • Audit SQL modifications and get notified in SQL Se...
    • ►  March (1)
      • What is Online Indexing in SQL Server 2016
    • ►  February (2)
      • Step by step Table Partitioning in SQL Server Stan...
      • SQL Server 2017 Installation on Ubuntu 16
    • ►  January (3)
      • Table Structure in SQL Server
      • Need VIEW DEFINITION permissions per database
      • How to set "Dark Theme" for SSMS 17.3
  • ►  2017 (45)
    • ►  December (12)
    • ►  November (11)
    • ►  October (3)
    • ►  September (4)
    • ►  July (1)
    • ►  June (2)
    • ►  February (5)
    • ►  January (7)
  • ►  2016 (12)
    • ►  October (1)
    • ►  August (5)
    • ►  July (1)
    • ►  January (5)
  • ►  2015 (58)
    • ►  December (1)
    • ►  November (17)
    • ►  October (11)
    • ►  September (1)
    • ►  August (1)
    • ►  June (4)
    • ►  May (5)
    • ►  April (4)
    • ►  March (2)
    • ►  January (12)
  • ►  2014 (100)
    • ►  December (14)
    • ►  November (11)
    • ►  October (3)
    • ►  September (9)
    • ►  August (12)
    • ►  July (8)
    • ►  June (6)
    • ►  May (5)
    • ►  April (3)
    • ►  February (22)
    • ►  January (7)
  • ►  2013 (22)
    • ►  December (4)
    • ►  September (4)
    • ►  August (4)
    • ►  June (2)
    • ►  May (2)
    • ►  April (4)
    • ►  March (1)
    • ►  January (1)
  • ►  2012 (10)
    • ►  October (1)
    • ►  September (2)
    • ►  July (2)
    • ►  June (5)
  • ►  2011 (3)
    • ►  July (1)
    • ►  June (2)
  • ►  2010 (1)
    • ►  February (1)

Who am I

  • Mohammed Adil
  • Saurabh Sinha
Powered by Blogger.