Integrating SQL Server Tools into SQL Change Automation Deployments
Phil Factor shows how to integrate use of SQL Change Automation, SSMS registered servers, SMO, and BCP to automatically build or update a database on all servers in a group.
6 steps to a more secure SQL database
Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]
T-SQL Context Switching
Being a standards advocate, Steve has a few thoughts on team code structure.
DevOps Self-Service for Databases with SQL Clone
Phil Factor describes the freedom of being able to "self-serve" databases, during testing and development, and explains how it works with SQL Clone.
How to Use Parameters in PowerShell
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that takes parameters.
Which Service in Azure Should You Use for SQL?
I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]
Documenting with Tests
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
Real-time moving averages for IoT with R
Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.
SQL Server Security Part 2
In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.
Database Build Blockers: Cross-Server Database Dependencies
Phil Factor demonstrates how to tackle builds when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
Blogs
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...
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...
Forums
BCA Syariah KC Samanhudi Hub/Wa 08216977701
Komplek Perkantoran Mitra Krekot, Jl. Samanhudi No.21 1, RT.1/RW.7, Ps. Baru, Kecamatan Sawah Besar,...
Bca Kcp Pembangunan Hub/Wa (08216977701)
Jl. Pembangunan I No.25A, RT.11/RW.1, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Pintu Air Hub/Wa (08216977701)
Jl. Pintu Air Raya No.36 Q, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
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