How to Persuade Your Company to Change
Like a lot of developers and database administrators, I do a fair amount of short-term problem solving during the course of my normal work week. I get to join...
2019-07-19
11 reads
Managing Cross-Database Dependencies in Builds (Redgate video)
Building your database code is an essential practice to ensure that it compiles from source and that dependencies are met. But things can get tricky when you have objects...
2019-06-25
10 reads
How Developers and DBAs Collaborate in a DevOps World (video)
You’re a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for...
2019-06-13
7 reads
A letter to my 20 year-old self
This post is a part of #tsql2sday, a monthly community ritual where a topic is proposed by a community member and everyone is invited to join in. This month’s...
2019-06-11
12 reads
DBAs: Stop Denying Sysadmin to Developers
I recent chatted with some folks who have a permissions problem in SQL Server. The permissions problem isn’t technical — it’s a process problem. The issue is that these...
2019-05-30
7 reads
What’s Unique About SQL Saturdays: Nearly Everyone Interacts with Other People
Today I was looped in on an email thread about the pros and cons of attending a specific event. One person on the thread asked if any of us...
2019-05-21
6 reads
How to recognize the early stages of burnout, and my treatment plan
I recently realized that I’m in the early stages of burnout. This isn’t an unfamiliar place for me, but it is new for me to recognize the early signs...
2019-05-14
7 reads
Paying down technical debt
One of the cool things that I do as an Evangelist at Redgate is to periodically visit company headquarters in Cambridge. The other Evangelists and I get to meet...
2019-05-07
6 reads
What is Automation?
Today I got a bit closer to a meaningful definition of automation, as it applies to the software development process. I’ve been turning this concept over in my head...
2019-04-29
10 reads
Should release cadence be slowed if you don’t have database load testing?
I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development...
2019-04-23
10 reads
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 KCP Ngagel Jaya Selatan TLP/WA 083800209966
Jl. Ngagel Jaya Selatan No.25, Pucang Sewu, Kec. Gubeng, Surabaya, Jawa Timur 60283
BCA KCP Kertajaya TLP/WA 083800209966
Jl. Kertajaya No.35, Airlangga, Kec. Gubeng, Surabaya, Jawa Timur 60281
BCA KCP Golden City Mall TLP/WA 083800209966
Golden City Mall, Ground Floor G-23-27, Jl. KH Abdul Wahab Siamin Surabaya No.2-8, Dukuh...
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