Skip to content

Igor Micev

My blog about SQL Server

Menu

Primary menu

  • Blog
  • About Me

Category Archives: Uncategorized

Microsoft Certified Trainer!

Posted on May 28, 2017 by Igor Micev — No Comments ↓

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus Educational and Development Center (SEDC), so I’m very thankful to SEDC. Continue reading Microsoft Certified Trainer!→

Posted in Uncategorized | Tagged MCT | Leave a reply

My first Microsoft MVP Award!

Posted on January 10, 2017 by Igor Micev — No Comments ↓

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing and data architecture. Fortunately all my next jobs were/are strongly related Continue reading My first Microsoft MVP Award!→

Posted in Uncategorized | Tagged MVP | Leave a reply

A strange OS bug on a SQL Server migration

Posted on May 6, 2016 by Igor Micev — No Comments ↓

This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS packages on quite a big database of 450 GB, and on a very powerful hardware (16 cores, 128 GB RAM Continue reading A strange OS bug on a SQL Server migration→

Posted in Uncategorized | Tagged cpu | Leave a reply

How a Bad query can rise up your CPU to ceiling

Posted on December 25, 2015 by Igor Micev — No Comments ↓

Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1). I just captured the moment and want to share. Figure 1. Continue reading How a Bad query can rise up your CPU to ceiling→

Posted in Uncategorized | Tagged query | Leave a reply

Database jokes

Posted on July 18, 2014 by Igor Micev — No Comments ↓

Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile yourself or share with a colleague. A SQL query walks into Continue reading Database jokes→

Posted in Uncategorized | Tagged jokes | Leave a reply

SQL Server sample databases

Posted on February 24, 2014 by Igor Micev — No Comments ↓

Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have some of them on your local instance. 1. The AdventureWorks sample databases for SQL Server versions can be found on the Continue reading SQL Server sample databases→

Posted in SQL Server, Uncategorized | Tagged sample databases | Leave a reply

Primary Sidebar Widget Area

Recent Posts

  • Useful T-SQL queries and scripts to work in SQL Server
  • How to Write a Better T-SQL Code
  • Some New Cool Features in SSMS

Categories

  • .NET (3)
  • Configuration (6)
  • Database design (5)
  • Features (4)
  • Installation (4)
  • Maintenance (7)
  • Optimization (5)
  • Programming (5)
  • Scripts (4)
  • SQL Server (2)
  • SSMS (6)
  • T-SQL (13)
  • Technology (2)
  • Uncategorized (6)

Tags

C# clone CLR code-refactoring compression configuration constraints cpu CXPACKET dates EOMONTH extents foreign keys fragmentation functions hints and tips indexes JASON jobs jokes licensing master rebuild maxdop MCT mixed_page_allocation MVP powershell primary key query Regex reports report server sample databases script snapshot SQL Azure sql server ports stored procedures system databases tempdb temp tables

Subscribe via Email

Subscribe via Email

  • Twitter
  • Google Plus
  • Linkedin
  • RSS Feed
Copyright © 2023 Igor Micev. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up