Taking Care of Things Today
Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.
2015-01-19
113 reads
Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.
2015-01-19
113 reads
I was going to call this an upgraded HDD, but that’s not right. Technically it’s a drive update, but really...
2015-01-19
2,045 reads
There’s a neat switch in SQL Compare that lets you build rollback scripts. It looks like this:
I’ve used this before...
2015-01-16 (first published: 2015-01-07)
6,567 reads
Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.
2015-01-15
142 reads
Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.
2015-01-15
6,511 reads
This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which...
2015-01-14
1,278 reads
Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.
2015-01-14
684 reads
2015-01-14
2,550 reads
We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.
2015-01-13
224 reads
The invitation for T-SQL Tuesday this month comes from Robert Pearl. It’s called HealthySQL and it’s a topic I like....
2015-01-13
804 reads
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Jl. Barata Jaya No. 76-76A, Baratajaya, Kec. Gubeng, Surabaya, Jawa Timur 60245
BCA KCP Gatot Subroto Telpon/wa:0813.7887.595.Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit...
Jl. Ngagel Jaya Selatan No.25, Pucang Sewu, Kec. Gubeng, Surabaya, Jawa Timur 60283
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