Flight or Invisibility: Which do you Choose?
A colleague of mine pointed out a great podcast called This American Life - specifically an episode with John Hodgman (the...
Pivoting, Unpivoting and Aggregating
We asked Phil Factor to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do so, he takes us all the way from getting the data from a published source, transferring it to SQL Server, un-pivoting it, storing it in a relational table, aggregating it and finally pivoting the data in a variety of ways.
Exceptional DBA Josef Richberg: fighting cancer, but still sharing
Josef Richberg is an exceptional person: The Judges of the Exceptional DBA Award were quickly proved right in their decision to choose him, when he subsequently showed extraordinary resilience and determination in the face of an unexpected diagnosis of cancer. His determination to deal positively with a difficult life-event is surely a source of inspiration to all of us.
SQL Server 2008 Upgrade Gotchas & Fixes
Preparation for upgrading SQL Server 2005 production database servers to SQL Server 2008, I tested upgrade in dev/test env.
The Conference Benefit
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
How to Detach and Attach a SQL Server FILESTREAM Enabled Database
Most SQL Server DBAs have questions about how to detach and attach a FILESTREAM enabled databases. In this tip, we will take a look at the steps Database Administrators need to follow in order to detach and attach a FILESTREAM database once Data, Log and FILESTREAM container files have been moved from the default location to a new location. This tip includes a general explanation of the FILESTREAM technology introduced with SQL Server 2008. This is followed by examples and scripts to detach and attach FILESTREAM enabled database in your environment.
SQL Server 2008 Database Mirroring in Action
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
The Conference Benefit
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
The Conference Benefit
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
The Conference Benefit
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
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 Sunter Bisma Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Pertokoan Paradise, Jl. Paradise 11 No.23 Blok J-1 No. 6 & 7, Papanggo,...
BCA KCP Jatinegara Timur Telpon/wa:0813.7887.595
BCA KCP Jatinegara Timur Telpon/wa:0813.7887.595.Jl. Jatinegara Timur No.37 Pav, RT.8/RW.4, Bali Mester, Kecamatan Jatinegara,...
BCA KCP Sidareja Telp/wa 085169998765
Telp/wa 085169998765 Jl. Jenderal Ahmad Yani No.40, Cikalong, Sidareja, Kec. Sidareja, Kabupaten Cilacap, Jawa...
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