I need a logo
I've been doing the Voice of the DBA podcasts for over a year now, and I really enjoy them. I've heard from many of you that you like them as well, so ...
Monitoring group of Linked Sql Servers from a Sql Server
The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.
Instead of Trigger, Part 1 - SQL School Video
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
Music for DBAs
Tony Davis explains his theory on why developers and DBAs listen to very different types of music, while working, and offers his list of "classic tracks" for all DBAs.
10+ tips for working smarter with SQL
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started
Limit Groups by Number Using Transact-SQL or MS Access
You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a wizard for installing your packages. The benefit to using it is the nice user interface that a wizard provides. The disadvantage of using it is it’s lack of flexibility. When using the Deployment Manifest keep in mind...
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.
SQL Server Memory Configuration, Determining MemToLeave Settings
Tweaking SQL Server memory settings to provide support for managed code.
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 Jalan Panjang HUB/WA (08218573837)
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
BCA KCP Pasar Puri Indah Hub/Wa 08218573837
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
BCA KCP Taman Ratu Hub/Cs (08218573837)
Komp, Jl. Taman Ratu Raya Bl. Bl No.5/8, Duri Kepa, Kec. Kb. Jeruk, Kota...
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