Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
Improved Application Availability During Online Operations in SQL Server 2014
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact.
SQL Saturday #213 Providence, RI
Join us for a free day of SQL Server training and networking on September 21 in Providence Rhode Island. Featured speakers include Paresh Motiwala, Wayne Sheffield, and Jason Brimhall.
Versions of Disaster
Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.
Condensing a Delimited List of Integers in SQL Server
In real-world applications, it often makes sense to show denormalized data, such as delimited lists, within the application's user interface. Dwain Camps shows why, and how, the distribution business stores information about 'islands' in sequences in order to track the status of the shipping of a consignment. It makes a great SQL puzzle.
SQLskills and SQL Intersection
This fall SQLskills is running the SQL track at SQLIntersection, with an amazing lineup of speakers and sessions. Join Paul Randal and Kimberly Tripp in Las Vegas for the event, Oct 28-30.
SQL Saturday #249 San Diego
Join SQL Saturday San Diego for a free day of SQL Server training and networking on September 21st. There will also be a free SQL in the City Session on the 20th presented by Steve Jones and Grant Fritchey.
The Future of Knowledge Measurement
In part 3 of his thoughts on certifications, Steve Jones gives an idea for how we might move forward from here.
How to Recognize When a Relational Database is "Good Enough"
In this Webinar on Tuesday September 12, Louis Davidson will explain the differences between good and bad database design. He'll discuss characteristics such as comprehendible, documented, secure, well performing, and normalized (naturally). Register to come along.
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