Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
SQL Server Integration Services Features And Properties Part 4
This article is the final article of a 4 part series that explores the Features and Properties of SSIS. This article will explore Validation.
Temporal Data Techniques in SQL
Joe discusses various factors to take into account when using temporal data such as Holidays, and discusses a few techniques using Calendar, Report Usage and History tables
Ways To Build Your Brand
This is in the presentation I've given a few times, but I thought it made some sense to put these things out here as well. I see there are a few major ways for you to build your brand and raise your profile in the modern world that is highly interconnected...
Automate Default Constraints
One procedure that will take care of all default constraint values in the destination.
Data Mining in Excel 2007 Pt.1 - SQL School Video
Excel has greatly helped ease the process of data mining. In this video MVP Brian Knight shows how you can start using the data mining add-ins for Excel to get started.
Trust
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Creating packages in code - OLE-DB Source to Flat File File Destination
This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below.
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
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