Configuring Alerts for Policy-Based Management
How can I receive notifications when the policies I have implemented have been violated so I don't have to manually look at each server?
Becoming Highly Productive
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
SQL CLR Data Types and Performance
Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.
Gathering Perfmon Data with Powershell
Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.
Incompetent or Malicious
When someone else doesn't do a good job to prove a point, are they incompetent or malicious? Steve Jones comments.
Turn on CHECKSUM after an upgrade
When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.
Binary Trees in SQL
A number of hierarchies and networks are most conveniently modelled as binary trees. So what is the best way of representing them in SQL? Joe Celko discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap
Backup Isn't Enough
When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.
Setting All Tempdb Data Files to the Same Size
How to set all tempdb datafiles to same size to meet best practice.
SQLRally
A new event is coming to the East Coast next year that will give people a chance to experience a SQL Server conference at a much lower cost.
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 Andalas TLP: WA 08218573837
Jl. Andalas No.75, Bontoala Parang, Kec. Bontoala, Kota Makassar, Sulawesi Selatan 90174
BCA KCU SURYOPRANOTO Telpon/wa:0813.7887.595
BCA KCU SURYOPRANOTO Telpon/wa:0813.7887.595.Jl. Suryopranoto No.40, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
BCA KCP Sungguminasa TLP/WA 0821°857°3837
Jl. Sultan Hasanuddin No.167 & 169, Pandang Pandang, Kec. Somba Opu, Kabupaten Gowa, Sulawesi...
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