Cloud First
SQL Server 2016 is the first cloud first version of SQL Server being released as the on-premise product.
Data Mining Part 38: Text Mining - The term lookup
In this new article, we will show how to use the SSIS term lookup transformation tool.
How to change server level collation for a SQL Server Instance
Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.
SQL Server Resource Governor
Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.
The Practical Problems of Determining Equality and Equivalence in SQL
In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.
A nice whistle and flute
Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.
Verify SQL Backups With SQL Powershell
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables
Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
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