Marko Zivkovic

Author
Recent Posts

Marko aka “Zivko” is a senior software analyst from Nis, Serbia focusing on SQL Server and MySQL as well as client technologies like SSMS, Visual Studio, and VSCode. He has extensive experience with quality assurance, issue escalation/resolution, and product evangelism.

He is a prolific author of authoritative content related to SQL Server including a number of “platinum” articles (top 1% in terms of popularity and engagement). His writing covers a range of topics on MySQL and SQL Server including remote/linked servers, import/export, LocalDB, SSMS, and more.

In his part-time, Zivko likes basketball, foosball (table-soccer), and rock music.

See more about Marko at LinkedIn

View all posts by Marko Zivkovic

Latest posts by Marko Zivkovic (see all)

How to connect to a remote MySQL server using SSL on Ubuntu - April 28, 2020
How to install MySQL on Ubuntu - March 10, 2020
Using SSH keys to connect to a remote MySQL Server - November 28, 2019

$C:\Users\Marko\AppData\Local\Microsoft\Windows\INetCacheContent.Word\14.png$

How to query data in a System-Versioned Temporal Tables in SQL Server

February 20, 2017 by Marko Zivkovic

This article will cover the querying of temporal tables in SQL Server by using the FOR SYSTEM_TIME clause and its four sub clauses AS OF, FROM TO, BETWEEN AND, CONTAINED IN. Also, we’ll cover how to clean up the history table to keep it a manageable size.

How to use SQLCMD commands in the SSMS query editor

December 13, 2016 by Marko Zivkovic

SQLCMD Mode allows creating, testing, executing SQLCMD commands or scripts in SQL Server Management Studio directly in the query editor. This option is available since SQL Server 2005.

Temporal tables – SQL Server

July 4, 2016 by Marko Zivkovic

What is a temporal table?

Temporal tables give us the possibility to retrieve data from any point in the past and for every data change (Update, Delete, Merge). With temporal table users can recover data from accidental changes (update/delete) as well as audit all changes to data, etc. Temporary table is a new feature in SQL Server available from SQL Server 2016 CTP2 version. Read more »

New options in SQL Server Management Studio 2016

June 28, 2016 by Marko Zivkovic

This article will introduce some minor, but very handy improvements in SSMS 2016, such as options for preventing the appearance of a dialog box for saving queries, setting up color of the interface theme, highlighting the current line and checking for a new SSMS updates.

New feature in SQL Server Management Studio 2016 – Scroll bar

June 20, 2016 by Marko Zivkovic

One of the new enhancements in SQL Server Management Studio 2016 (SSMS) is the Scroll Bars tab, in which can be set various of settings for vertical scroll bar.

New feature in SQL Server Management Studio 2016 – Quick Launch

June 14, 2016 by Marko Zivkovic

What is Quick Launch?

Quick Launch is a new feature that is added in SQL Server Management Studio (SSMS) 2016. Quick Launch is search tool, but it doesn’t search code/contents of the script/files. Instead it searches SSMS itself including menu items, options and file names. Quick Launch is enabled by default when SSMS is installed and it is located at the top right corner of the menu bar (see below):

How to create and customize SQL Server Templates

May 16, 2016 by Marko Zivkovic

SQL Server Templates are SQL scripts, containing SQL code, frequently used by developers and DBAs in their daily work (e.g. Create Table, Add Column, Drop Column, Create Database, Create Logins etc.):

SQL snippets in SQL Server Management Studio

April 22, 2016 by Marko Zivkovic

Snippets are a great productivity feature to speed up typing of repetitive T-SQL. Snippets were introduced in SQL Server 2012 as part of SQL Server Management Studio (SSMS).

Snippets are XML templates with predefined fields and values that render into T-SQL, when processed by the query window.

How to connect to a remote SQL Server

February 18, 2016 by Marko Zivkovic

In this article, we will explain step by step how to connect remotely to a SQL Server Express instance. Remote access is the ability to get access to a SQL Server from a remote distance in order to manipulate data which are located on that SQL Server.

How to install SQL Server Management Studio 2008

January 20, 2016 by Marko Zivkovic

SQL Server Management Studio is a software application that helps users to easily access the SQL Server database engine and manipulate objects and data stored on SQL Server databases. The first version was released with Microsoft SQL Server 2005, replacing Enterprise Manager as the primary interface for Microsoft SQL Server.