Configure SQL Jobs in SQL Server using T-SQL
SQL Server Agent is a component used for the database tasks automation. For instance, we need to...
Configure Database Mirroring in SQL Server
Database mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database...
10 Tips & Tricks To Work With SQL Server Management Studio
SSMS provides access for managing and solving queries in SQL. However, besides its primary and most demanded options, it includes lots of...
How to Make Use of SQL Server Graph Database Features
Would SQL Server graph database features fit your next project? While you may not know the...
Using SQL Server 2016 Upgrade Advisor
INTRODUCTION SQL Server is designed to allow multiple databases on a single instance. With this model it is possible to have databases...
Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger
When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool, it is essential to test the “Live”...
Pivoting, Unpivoting, and Splitting Columns in Power BI Query Editor
For reference, Power BI is a data visualization and analytics software developed by Microsoft....
Best SQL Tools for Database Developers and Administrators
For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given...
TeamCity Hosting Plugin
This is the second part of the article related to the question of the TeamCity plugin implementation and hosting. If you haven’t seen the...
Implementing a TeamCity Plugin
Steps for implementing a TeamCity Plugin include: • Preparing the development environment •...
