Skip to content

Igor Micev

My blog about SQL Server

Menu

Primary menu

  • Blog
  • About Me

Category Archives: SSMS

SSMS

Some New Cool Features in SSMS

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

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right click on a database Tasks -> Vulnerability Assessment -> Scan For Continue reading Some New Cool Features in SSMS→

Posted in Features, SSMS | Leave a reply

Connect to SQL Azure database from SSMS

Posted on October 11, 2016 by Igor Micev — No Comments ↓

In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you have to have a resource (your database server). Some of the Continue reading Connect to SQL Azure database from SSMS→

Posted in SSMS, Technology | Tagged SQL Azure | Leave a reply

Showplan comparison

Posted on June 2, 2016 by Igor Micev — No Comments ↓

A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option you’re already having the comparison. Example comparison If you want to Continue reading Showplan comparison→

Posted in SSMS | Leave a reply

The new SQL Server Management Studio 2016

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

The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014. The link from the window below forwards you to the newest release which Continue reading The new SQL Server Management Studio 2016→

Posted in SSMS | Tagged hints and tips | Leave a reply

Live execution plans

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

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query is shown with a live flow of the execution plan like below Continue reading Live execution plans→

Posted in SSMS | Leave a reply

Objects dependency check up in SSMS

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

It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s) is tiny it could withdraw change(s) in other objects. The example Continue reading Objects dependency check up in SSMS→

Posted in SSMS | Tagged hints and tips | 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