SQL Azure Reporting Automation
This article will talk about preparing a runbook in Azure to schedule the report of space usage of databases in Azure environment
Dealing with High Concurrency with Table Hints
Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.
Migrating Schema Between Platforms
The decision to change platforms isn't one Steve Jones takes lightly.
Properly Persisted Computed Columns
Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.
Statistics in SQL: Kendall’s Tau rank correlation
Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating correlation, regression and variance on large quantities of data. It just isn't always immediately obvious how. In the second of a series of articles, Phil factor shows how calculating a non-parametric correlation via Kendall's Tau or Spearman's Rho can be stress-free.
DevOps Can Help
DevOps can help, not just development, but also infrastructure, if you spend time adapting the practices to your environment.
Help for DBAs Who Support SSIS…
SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.
Scoring Outliers with R
What is normal? More to the point, what is abnormal? We will look at using R to score outliers in a typical monitoring dataset.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Cara Penghapusan Annual Fee Kartu Kredit DBS
Untuk menghapus iuran tahunan (annual fee) kartu kredit DBS, hubungi DBS Customer Center di...
BCA KCP Santa HUB/CS 0821•697•7701
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
BCA KCP AHMAD YANI II TLP/WA 083800209966
Jl. A. Yani No.280, Kacapiring, Kec. Batununggal, Kota Bandung, Jawa Barat 40271
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers