Additional Articles

Development Delusions: That it is Enough to Build a Better Mousetrap

by Additional Articles

SimpleTalk

Development

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.

2017-01-20

3,650 reads

What's New in Reporting Services 2016 Service Pack 1

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.

2017-01-19

5,038 reads

SQL Server v.Next : STRING_AGG() performance

by Additional Articles

SQLPerformance.com

SQL Server v.Next

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.

2017-01-18

3,620 reads

SQL Server in Azure Virtual Machines - Performance Optimizations

by Additional Articles

Database Journal

Azure VM

When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. This article explores a couple of these enhancements, with a particular focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).

2017-01-17

5,354 reads

Free Webinar – Database DevOps Demo

by Additional Articles

Redgate

Learn how to extend DevOps practices to SQL Server databases in our free demo webinar on January 17th. Microsoft Data Platform MVP, Steve Jones will demonstrate how Redgate’s database automation tools plug into Git, Jenkins & Octopus Deploy. Learn how to branch and merge with SQL Source Control then automate the build and deployment of changes with DLM Automation. Register now.

2017-01-16 (first published: 2017-01-11)

5,646 reads

Using Power BI Desktop to Visualize SQL Server Metadata

by Additional Articles

SimpleTalk

Power BI Desktop

You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.

2017-01-16

3,767 reads

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

by Additional Articles

MSSQLTips.com

always on

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.

2017-01-13

3,309 reads

Identifying Last Night’s SQL Agent Job Failures

by Additional Articles

Database Journal

SQL Agent

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.

2017-01-12

4,563 reads

SQL Server Database Provisioning

by Additional Articles

SimpleTalk

provisioning

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.

2017-01-11

4,829 reads