Using the Sort Transform - SQL School Video
This SQL School video shows just how you can sort the data in your SSIS packages.
Checksum Transformation
The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column.
Life on SQL Server 2008: Interview with Thomas Grohse
Thomas has been running SQL Server 2008 live in production for over 1 year as part of the Microsoft Early Adopter Program. Below is the full interview I conducted with him about his experience with SQL Server 2008.
The Numbers Table
Having a table of just numbers can be very handy, and it doesn't necessarily take up much space in your database. New author Brandon Galderisi brings us a short tutorial on setting this up.
Undocumented Routines: Forbidden fruit.
Phil wonders whether it is time to come up with clear 'best practice' guidelines to cover the use of undocumented routines, and ends up deciding it is a gray area.
Are Your Indexes Being Used Effectively?
This article shows how to use the dm_db_index_usage_stats DMV to identify if an Index is being used on not
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
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 Imam Bonjol TLP/WhatsApp 08216977749
Jl. Tanjung Pura No.457, Benua Melayu Darat, Kec. Pontianak Kota, Kota Pontianak, Kalimantan Barat...
BCA KCU PONTIANAK TLP/WhatsApp 08216977749
Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak, Kalimantan...
BCA KCP Kota Baru TLP/WhatsApp 08216977749
Jl. Prof Doktor Mohammad Yamin, Kota Baru, Kec. Pontianak Sel., Kota Pontianak, Kalimantan Barat...
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