• Home
  • Archive
  • Contact
  • About Me
  • Events
  • Services
  • Facebook
  • Twitter
  • Google Plus
  • Subscrib
  • Youtube
  • LinkedIn
  • Instagram
  • github

Mehedi's Earth

Idea | Knowledge | Sharing

Join our techforumbd 22nd August, 2020 webniar

16. August 2020 Mehedi News Comments (0)
SATURDAY, AUGUST 22, 2020 AT 5 PM – 8 PM
Software Performance Scalability & Productivity t [More]

Step by Step Installation of SQL Server 2019 ML Services in Windows Local Machine

9. August 2020 Mehedi Machine Learning , SQL Server Comments (0)
Step by step installation of SQL Server 2019 ML Services and a Python example will be covered here for windows local machine. [More]

Disable IDENTITY Function at INSERT

5. August 2020 Mehedi SQL Tips Comments (0)
Did you ever wondered how to INSERT values in IDENTITY column or fill the gap of missing value of ID [More]

An use case of ROW_NUMBER() Function

29. July 2020 Mehedi SQL Tips Comments (0)
In my Ranking Function article, I have briefly described about ROW_NUMBER() function. Let's have a p [More]

Ranking Functions

28. July 2020 Mehedi SQL Tips Comments (0)
Explore the all four RANK functions of SQL Server [More]

Character set 'utf8mb4' is not supported in .Net Framework MySql.Data.dll

27. July 2020 Mehedi MySQL Comments (0)
Recently, I was working in .Net framework and MySQL database. Below procedure was throwing error and finally, I found the solution. [More]

Please join our techforumbd monthly webniar

16. July 2020 Mehedi News Comments (1)
Application Performance Scalability to Success-3
 
Please join our techforumbd monthly webniar. [More]

Examining SQL Server Agent Job Status

16. July 2020 Mehedi SQL Tips Comments (0)
This article will enlight on how to examine SQL Server Agent job status using T-SQL [More]

SQL CASE Statement

15. July 2020 Mehedi SQL Tips Comments (0)
Explaining use of SQL CASE statement [More]

Linked Server - Error 7405: Heterogeneous queries

13. July 2020 Mehedi SQL Tips Comments (0)
In some cases, I used linked server. If you use linked server you might get "Linked Server - Error 7 [More]
<< Older posts Newer posts >>
  • Newer posts
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • Older posts

LinkList

  • Empty

Category List

  • RSS feed for SubBlog C# (2)
  • RSS feed for SubBlog MySQL (1)
  • RSS feed for SubBlog News (11)
  • RSS feed for SubBlog Redis (1)
  • RSS feed for SubBlog Technology (3)
  •     RSS feed for SubBlog Machine Learning (3)
  •     RSS feed for SubBlog SQL Server (48)
  •        RSS feed for SubBlog Performance Tuning (1)
  •        RSS feed for SubBlog Security (1)
  •        RSS feed for SubBlog SQL Server Monitoring (7)
  •        RSS feed for SubBlog SQL Tips (30)

Post List

  • MAXDOP: What You Need to Know
  • Exploring DBA Dash: The Free SQL Server Monitoring Tool You Should Know
  • Search within MDF File
  • The Waiting Game: Performance Tuning using SQL Server Wait Statistics Part-3
  • The Waiting Game: Performance Tuning using SQL Server Wait Statistics Part-2
  • The Waiting Game: Understanding SQL Server Wait Statistics Part-1
  • Behind the Scenes: How SQL Server Rebuilds an Online Index
  • Query Performance Tuning: Removing Key Lookup from Execution Plan
  • Deep Drive into Columnstore Index
  • Scripts for Identifying Missing Indexes, Unused Indexes and Heaps

Comment List

  • Understanding Index Fragmentation (1)
    UuDMEJ7m5BHwLZ wrote: 777280 51087fantastic post. Ne�er knew this, rega...
  • Please join our techforumbd monthly webniar (1)
    LDUygO wrote: 55068 338115Significant other, this excellent webs...
  • SQL Server Monitoring Demystified: Find the Most Resource-Intensive Queries with sp_BlitzCache (2)
    Mehedi wrote: Thanks for your feedback.
  • SQL Server Monitoring Demystified: Find the Most Resource-Intensive Queries with sp_BlitzCache (2)
    Mahmud Khan wrote: Great work on this article! You've done an exc...
  • Comment RSS

Month List

  • 2025
    • May (2)
    • April (8)
    • March (2)
    • February (4)
    • January (2)
  • 2024
    • December (3)
    • November (3)
    • October (1)
    • September (3)
    • July (4)
    • June (1)
    • May (3)
    • April (1)
    • March (1)
  • 2022
    • August (1)
    • July (2)
  • 2021
    • November (2)
    • October (2)
    • September (2)
    • June (4)
    • April (1)
  • 2020
    • November (1)
    • October (2)
    • September (1)
    • August (7)
    • July (8)

Copyright © 2025Powered by BlogEngine.NET 3.3.8.0Design by FSLog in