Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
Bookmark Lookups
Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.
Return Query Text Along With sp_who2 Using SQL 2000
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
Avoid Untrusted Constraints in SQL Server
Some time ago, I loaded a large set of data into one my tables. To speed up the load, I disabled the FOREIGN KEY and CHECK constraints on the table and then re-enabled them after the load was complete. I am now finding that some of the loaded data was referentially invalid. What happened?
Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services
This document assists Crystal Report designers with migrating to Microsoft SQL Server 2005 Reporting Services using a step-by-step migration strategy.
The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
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 PURI INDAH HUB/WA 08216366654
Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blok 02, Kec. Kembangan,...
BCA KCP Puri Anjasmoro Telp/wa 085169998765
Telp/wa 085169998765 Kompleks Ruko Puri Niaga Centre, Jl. Madukoro Raya DD III No.5 No....
BCA KCP Rantai Mulia Kencana HUB/WA 08216366654
Jl. Pesanggrahan Jl. Puri Kencana No.28 29, RT.2/RW.7, Kembangan Sel., Kec. Kembangan, Kota Jakarta...
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