Serverless
The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.
Introduction to SQL Server Security — Part 5
SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions
Which Database is Causing the Problem?
You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first?
Are you a Data Scientist?
A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.
SQL Server Trigger on View Example
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
Build an OLAP Cube in SSAS using an ADO.NET Data Provider
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
Guest editorial: SQL Code Metrics
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
Compressed Microsoft SQL Server Backups by Default
Learn how to create default database compression for your SQL Server databases.
Row Pattern Recognition in SQL
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Jalan Panjang HUB/WA (08218573837)
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
BCA KCP Pasar Puri Indah Hub/Wa 08218573837
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
BCA KCP Taman Ratu Hub/Cs (08218573837)
Komp, Jl. Taman Ratu Raya Bl. Bl No.5/8, Duri Kepa, Kec. Kb. Jeruk, Kota...
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