Getting Started with Cloud-hosted Databases using Spawn
This article will get you started with Spawn, a hosted database cloning service running entirely on Amazons AWS.
How to filter DAX for paginated reports
DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.
Where the World Takes You
We're launching into a new year and there are lots of "looking into the future" articles out there. Personally, I'm pretty jazzed for the coming year for any number of reasons (can you say "SQL Server 2022"?). However, I also get a little retrospective at times like this. Now, I'm not going to talk about […]
Analyze Live Salesforce Data in Infragistics Reveal
Infragistics Reveal is a data visualization solution that simplifies the way you add embedded analytics and visualizations to your apps. Reveal supports connecting to OData APIs, but many enterprise APIs are not built using the OData standard. By combining Reveal with CData solutions, you can instantly build dynamic dashboards from live enterprise data sources like Salesforce. […]
Query control made easy
Overview As we all know, data security is a never-ending battle. Every day, we hear of new data breaches. It's a hard problem, and there is no single solution, other than a defense in depth. Let's look at one of those defenses for databases: query control. Query control is a simple idea: most applications access […]
What Were Your 2021 Wins
The first poll question of the year has Steve asking you to look back at 2021 and pick something good that happened.
Azure Policies and Management Groups
You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood explains Azure Policies and Management Groups.
Using Flyway Teams with SQL Change Automation PowerShell Cmdlets
Use Flyway to run your database migrations, each time automatically creating a SQL Change Automation release object to provide object-level scripts and a build script for the new version, along with change reports and code analysis reports.
Challenging Trends
Steve notes the changes in the world might affect how to view and use data in our work.
Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator
The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers