Scenario
SQL Server 2014 offers many new features and along with that comes many new tools to help manage these new features. In this tip I will introduce the new Dynamic Management Views in SQL Server 2014.
Solution
Every SQL Server release comes with new and improved features and because of this, new Dynamic Management Views are included allowing us to collect metrics about these new features. Continue reading Dynamic Management Views in SQL Server 2014
Scenario
With SQL Server Management Studio you have the ability to do just about everything you can do using T-SQL commands. One problem with using the GUI is that it is difficult to remember everything you clicked on to reproduce the behavior a second time. Another issue is that most of what you do through the GUI is done immediately which may not always be the best scenario. How can I capture what SQL Server is doing so I can reproduce the behavior or run the commands at a later time.
Solution
A nice addition to SQL Server Management Studio is the ability to script out most of the commands and operations that you can do through the GUI. Let’s take a look at doing a database backup as an example. Continue reading SQL Server Management Studio scripting on TSQL commands