A look into the world of database testing, how to go about it, why do we really need it and how to work well with your peers and managers for greater project success.
We'll focus on the awesome new SQL Server 2012 stuff that will make your T-SQL development a breeze. We'll look at new stuff like OFFSET, WINDOWING FUNCTIONS, SEQUENCES, ERROR HANDLING, FORMAT & CONVERT functions and METADATA DISCOVERY.
This session will give you insight into both of the current tracing technologies in SQL Server.
Old SQL Trace has served us well but new times call for new technology. The new Extended Events are a new lightweight tracing mechanism built into SQLOS.
Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader()
In this session we'll take two queries, a read and a write one, and look at the whole trip from the client through the server and back to the client. On this journey we'll try to identify where things might go wrong.
Full support for SSMS 2016 RTM which came out June 1st 2016.
This new release brings the following feature improvements:
SQL Editor Plus
Renamed tabs get the custom name stored and properly restored in the SQL History's Tab Session.
Global Replacement Texts
Now you ...
This new release brings the following new features and feature improvements:
Export to Excel:
Properly export result sets, one or multiple tables or the whole database to Excel files.
This feature doesn't need Excel installed to work. It correctly converts SQL Server data ...
This new feature brings the following improvements:
Support for SSMS 2016 CTP 2.3 and up:
With each new SSMS 2016 CTP the compatibility might break. Future updates will come as soon as possible.
Search Database/Table Data:
Completely new Search ...
The new feature is called Global Replacement Texts. It gives you the ability to add custom replacement texts to your scripts in four different features. Licensing now gives you the ability to upgrade your existing license from the previous major version. This upgrade path is around ...
With version 3.0 the SSMS 2014 is fully supported. Since this is a new major version you'll eventually need a new license. Please check the EULA to see when. As a thank you for your patience with this release, everyone that bought the SSMS Tools Pack after April 1st, the release date of SQL ...