SQL Server 2016 Maintenance Plan Enhancements September 18, 2017 by Ahmad Yaseen SQL Server Maintenance Plans is a SQL Server Management Studio built-in feature that helps in creating a workflow of variant database administration tasks, which can be run automatically using a predefined schedule or manually triggered by the user. SQL Server Maintenance Plans allow you to use typical database maintenance tasks or customize your own task using a T-SQL script that runs on the local server or group of SQL Servers, providing more flexibility to the database administration tasks. Read more »
What’s new in SQL Server Management Studio 17.2; Authentication methods, scripting options and more August 31, 2017 by Ahmad Yaseen SQL Server Management Studio is an integrated graphical interface that is used to configure, manage, monitor and administrate the SQL Server instances hosted on the local machine, on a remote server or in the cloud. It provides us with editing, debugging and deploying environment for the T-SQL, XML, MDX and DMX languages. Read more »
What is new in SSMS 17; PowerShell and DAX August 21, 2017 by Daniel Calbimonte Introduction In earlier versions, SSMS was included in the SQL Server installer. Now it is a tool that is installed separately. In this new article, we will emphasize PowerShell and DAX. PowerShell is handled in a different way than it was in SQL Server 2016. We will give you some tips to handle these differences. In the second part of the article, we will talk about DAX. If you do not have experience with DAX, we will give you an introduction to Multidimensional, Tabular databases and you will be able to understand the new features and run your first DAX query in the new SSMS 17. Read more »
How to configure a Linked Server using the ODBC driver August 17, 2017 by Marko Zivkovic Microsoft Open Database Connectivity (ODBC) is an application programming interface (API) designed to access data from a different of database management systems (DBMS). ODBC is designed for relational data stores. Read more »
How to create, configure and drop a SQL Server linked server using Transact-SQL July 5, 2017 by Marko Zivkovic Linked servers allow getting data from a different SQL Server instance using single T-SQL statement. This article will explain how to create, configure and drop a SQL Server linked server using system stored procedures. Read more »
How to create and configure a linked server in SQL Server Management Studio June 9, 2017 by Marko Zivkovic Linked servers allow submitting a T-SQL statement on a SQL Server instance, which returns data from other SQL Server instances. A linked server allows joining data from several SQL Server instances using a single T-SQL statement when data exists on multiple databases on different SQL instances. By using a linked server to retrieve data from several SQL instances, the only thing that should be done is to connect to one SQL instance. Read more »
Custom keyboard shortcuts in SQL Server Management Studio (SSMS) March 27, 2017 by Prashanth Jayaram People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of time; you’ll definitely notice a boost the productivity because you’re not unnecessarily reaching for a mouse all the time. Read more »
10 SSMS Tips and Tricks to boost your Productivity January 6, 2017 by Samir Behara I have been using SSMS for a long time now, and over the period of time I have realized that it’s a very powerful IDE – however, there are lots of hidden features which are less known to lots of developers. In this article, I will be sharing some beneficial Tips and Tricks which will give you an extra edge in your day to day work, and in the process take your productivity to the next level. Read more »
Increase your Coding Speed in SQL Server Management Studio December 23, 2016 by Samir Behara Every developer wants to be productive and get more things accomplished during their day to day work. Given a choice between working harder and working smarter, you will most likely choose the latter. But the big question is – How do you boost your productivity? How do you reduce your development time? How do you increase your coding speed? Read more »
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. Read more »
SQL Server Management Studio 2016 Productivity Enhancements October 11, 2016 by Samir Behara Problem Statement Developers who work in both SQL and .NET world must have experienced the differences between Visual Studio IDE and SQL Server Management Studio IDE. Being a full-stack developer myself, I always felt that SSMS lacked a lot of basic features when compared to the functionalities which Visual Studio IDE provided out of the box. With SSMS being tightly coupled with SQL Server Core engine, the IDE had quite a technical debt associated with it over a period of time. 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. Read more »
Setting SSIS package encryption manually in SSMS June 24, 2016 by Daniel Tikvicki The whole process of encryption of SSIS packages in SSMS relies on the Import Package and Export Package options; specifically, the combination of performing both of mentioned options in particular order, while choosing and setting the appropriate ProtectionLevel in the process. Read more »
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. Read more »
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): Read more »
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. Read more »
Using and troubleshooting SQL Server IntelliSense – For SQL Server 2012 or higher February 29, 2016 by Minette Steynberg When I first heard that Microsoft was going to introduce IntelliSense for SQL Server I could hardly contain my excitement. Much to my disappointment the initial version of IntelliSense left a lot to be desired. From issues like just not popping up at all, to not working on remote servers and sometimes picking incorrect entries could make it a bit tedious to use and for those of us who started out on SQL Server before the advent of IntelliSense it was easier just to revert back to good old fashioned typing from memory. I am happy to report however, that there has been great strides in IntelliSense to such an extent that if I suddenly had to live without it, I would be really really sad and my productivity would probably be affected somewhat as well. Read more »
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. Read more »
How to run multiple queries using the Central Management Server January 25, 2016 by Daniel Calbimonte Introduction When you have thousands of SQL Servers, it is very hard to administer all of them. These article, will show some tips to help you on these types of tasks. In other article, we showed how to backup a database on multiple SQL servers at the same time using ApexSQL Backup. In this new article, we will show how to run T-SQL scripts against multiple Servers using SQL Server Management Studio (SSMS). To do this, we will use the Central Management Server. The main idea of this feature is to administer multiple servers in a centralized way using queries or policies. This feature is available in SQL Server 2008 or later versions and cannot be applied in older versions. Read more »
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. Read more »
Step by step installation of SQL Server Management Studio (SSMS) 2012 January 12, 2016 by Stefan Daniel Plačkov SQL Server Management Studio (SSMS) is the official Microsoft application used for managing all components within Microsoft SQL Server. It is a powerful tool which allows users to control any objects in the SQL Server. It also provides script editing and GUI tools which are easy to use and user friendly.SQL Server has multiple editions including: Enterprise Edition, Enterprise Core Edition, Business Intelligence Edition, Standard Edition, Web Edition, Express and Developer Edition each with its own features and functions. Read more »
How to install SQL Server 2014 Management Studio December 30, 2015 by Stefan Bozovic There are multiple editions of SQL Server 2014 (Enterprise Edition, Enterprise Core Edition, Business Intelligence Edition, Standard Edition, Web Edition, Express and Developer Edition). SQL Server 2014 has a free edition – Express and while the server itself lacks some options that other editions have, SQL Server 2014 Management Studio is the same and can be used with each of these. Read more »
SQL Server Management Studio tutorial – Configuring the environment June 11, 2014 by Muhammad Imran Configuration of the application plays a significant role in any application, when installed. However, some applications are configured at the time of installation (with default settings) while in other cases, manual configuration is done to achieve its real benefits. In the case of SQL Server Management Studio (SSMS), it is configured by default with the standard settings, and it can be further configured to make the work easier. Read more »
SQL Server Management Studio – A step-by-step installation guide May 14, 2014 by Muhammad Imran SQL Server Management Studio (SSMS) is the official and preferred client user interface which can be used to manage, configure, deploy, upgrade and administer a SQL Server instance. The tool interface is quite user friendly and comprehensive. It is shipped with every SQL Server version and is regularly updated and enhanced. If you are planning on learning how to use SQL Server from scratch, consider using SQL Server Management studio as a first step on your journey to learning SQL Server. Read more »