A tour through tool improvements in SQL Server 2016

Ayo Olubeko talks through the improvements being made to SQL Server tooling in 2016.

Byte Me: Forget It

Implementing Azure SQL Database Elastic Database Jobs

Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'. In this article, David Fitzjarrell takes a look at one such example in action.

Inside-SQL Conference: SQL Server Deep Dives in London

14th June, Londo, UK - Inside-SQL conference offers deep dives on a range of SQL Server topics, with tracks focusing on DBAs, Developers and BI.

Use the discount code "Redgate" for £40 off the price of a ticket.

Unified Approach to Generating Documentation for PowerShell Cmdlets

Now, it is easy to provide professional-quality documentation for PowerShell cmdlets, and to keep it in sync when you make changes, whether they are written in PowerShell or C#. While this has always been easy to do in PowerShell, it was always painful to do in C# or VB because it meant having to build your own MAML file. Michael Sorens completes his three-part series by summarising, in a wallchart, how to go about it.

Sharing on-premises SQL Server Data Analyses in the Cloud with Power BI

In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data

Database Hardware and Infrastructure Trends

Glen Berry talks through a number of useful new developments in hardware, storage, and the Microsoft Windows and SQL Server ecosystem.

Natively Compiled Stored Procedures: What they are all about

What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?

Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys

Denzil Ribeiro looks at the validation phase of transaction lifetime.

A Comparison of JDBC Drivers for MySQL

A brief comparison of three different JDBC Drivers built for connecting with MySQL