The Busman's Holiday
It's a holiday weekend, but for some DBA's it's hard to escape the unwanted clutches of IT...
Different ways to execute an SSIS package
In SQL Server 2005 and higher versions there are different ways in which one can execute an SSIS package. Let us go through each option one by one.
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds of technical questions hiring managers can ask a prospective DBA candidate in order to determine their technical proficiency. While technical skills are...
Resources for Upgrading to SQL Server 2008
Use these resources as aids in upgrading to SQL Server 2008. These references are from the downloadable white paper:
Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
A Generic Process to Convert XML Data - Part 1
Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.
The Independence Day Ruckus
Steve is away this Fourth of July, so we asked Brian Donahue, head of the Red Gate product support team, and an American "exiled" in the UK, to reflect on what Independence Day means to him.
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I "pay" for content. I said "no" at first, but wanted to follow up with more details. Since this was across Twitter , 140 characters...
Remote BLOB Store Provider Library Implementation Specification
This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.
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
Langkah praktis cara menonaktifkan - menutup kartu kredit UOB
Untuk menutup kartu kredit Bank UOB, Anda dapat mengh??bungi UOBCall melalui Whats?????? (62 0882-201^14008):...
BCA KCP Samarinda Seberang TLP/WhatsApp 08216977749
Jl. Bung Tomo, RT.001/RW.01, Baqa, Kec. Samarinda Seberang, Kota Samarinda, Kalimantan Timur 75132
BCA KCP Pangkalan Bun TLP/WA 08216977749
Jl. Ahmad Yani, RT.015/RW.04, Baru, Kec. Arut Sel., Kabupaten Kotawaringin Barat, Kalimantan Tengah 74112
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