Aging in Technology
As we grow and evolve in our careers, we face new challenges all the time. Steve highlights on of those that some tech workers worry about today.
Building Machine Learning Models to Solve Practical Problems
Machine learning is a skill that many data professionals are learning as they plan their careers over the next five to ten years. In this article, Supriya Pande gives an overview of machine learning and walks through a practical example.
Capturing the business value of Compliant Database DevOps
You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.
Moving beyond principal components analysis
Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.
The Work of the Ancients
We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.
Find SQL Server Installation Date for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.
Foreign Keys and Multi-Table Inserts in Oracle
Referential constraints ensure data integrity, but in at least one case can cause occasional problems. Read on to see what can happen and why it can occur...
Free Solution Brief – Dedicated Database Environments for Dev, Test and CI
Developers and testers can be blocked from having a local, private database to work in because of disk space, refresh times, and data privacy. Download this free solution brief to learn how SQL Provision removes these blockers and enables production-like data to be delivered at speed.
Feedback and Change
Today Steve asks you to be a part of the change you'd like to see in our professional organization.
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 KCU RAWAMANGUN Tlpn.0821•3111•185
BCA KCU RAWAMANGUN HUB.Tlpn.0821•3111•185 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
BCA KCU SUDIRMAN TLP/WA 08216977701
Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah...
BCA KCP Pulogadung Telpon/WA:085188120691
BCA KCP Pulogadung Telpon/WA:085188120691 Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo...
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