Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
The Ultimate Tool List
This week Steve Jones looks at a few tools that can help your productivity and links to a few more.
Migrating SQL Server Database to Windows Azure - Deploying SQL Database
There are a few challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. In this article we turn our attention to an actual deployment and migration of locally stored data to SQL Database.
The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)
This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)
Memories of 2013
It's the last Friday of 2013 and Steve Jones asks you to look back at the year. What stands out in your mind that relates to SQL Server.
The Importance of Validating Backups
You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.
The PoSH DBA - SQLPSX: SQL Server PowerShell Extensions
Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. Laerte Junior, who is one of the developers on the open-source project, describes how to use it.
It's not the platform
Steve Jones doesn't think that it matters which platform you choose. It's more about the people you have.
Generate multiple SSIS packages using BIML and metadata
Although BIML is very powerful, you wouldn’t use it to generate one package at a time. Using metadata, we can generate multiple packages on the fly. Koen Verbeeck illustrates how to convert the BIML script for generating the import package to a dynamic package generating machine.
How to Compare Rows within Partitioned Sets to Find Overlapping Dates
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers