You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...
This article shows the new features that are available in SQL Server 2008 Management Studio
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
Steve Jones takes a break today and gives you a fun reel of mistakes and bloopers.
SQLBits IV is taking place this March in Manchester. Read on about where to register and how to get some training the day before as well.
Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.
I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
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...
BCA KCP Fatmawati Telpon/wa:0813.7887.595.Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak, Kota Jakarta...
Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto, Jawa Timur 61313
Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
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