Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
Barriers to Virtualization
Virtualization, and use of the 'cloud', will be essential to the deployment of new applications, but will existing applications will be quite so amenable?
Best of SQLServerCentral, Volume 6
"Best of SQLServerCentral v6" pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between.
SQL Server Profiler Part 2: Custom Templates and Saving Data
In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.
Determining the source of full transaction logs
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week! Some quick observations: The build quality is outstanding. Nothing cheap at all about this card. The engineering that has gone into this shows in every way. It is made up of modules that...
The Basic Functionality of Report Designer
Recent installments of our series dedicated to the most prominent features of SQL Server 2005 Express Edition have discussed its reporting capabilities. This article illustrates another approach to generating reports, relying on the Report Server Project template, which offers a considerably wider range of flexibility than its wizard-driven counterpart does.
The Exceptional DBA Awards are back in 2009!
It's time for the Exceptional DBA Awards again, and SQLServerCentral.com and Red Gate want to give recognition to a DBA for outstanding work and achievements. Enter Today!
The Simple Estimate
Why can't it be easy for someone to tackle small projects? It is in some areas, and Steve Jones talks a little about some of the issues.
The Simple Estimate
Why can't it be easy for someone to tackle small projects? It is in some areas, and Steve Jones talks a little about some of the issues.
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 KCP Buaran Raya Hub.0851•8812•0691
BCA KCP Buaran Raya Hub.0851•8812•0691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCP Griya Utama HUB/CS 08216977701
Ruko Puri Mutiara, Jl. Griya Utama B Blk. D No.1-2, Sunter Agung, Kec. Tj....
BCA KCU Magelang Telp/wa 085169998765
Telp/wa 085169998765 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
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