Press Release


Technical Article

SQL Saturday #255 Dallas

SQL Saturday is coming to Dallas on November 2. This is a free, one day conference for SQL Server training and networking.

On November 1, there will be a pre-conference event featuring Andy Leonard, Grant Fritchey, and Drew Minkin.

2013-10-24

3,031 reads

External Article

SQL Monitor Performance Metric: Buffer Cache Used Per Database in MB

Data pages read from disk are placed in the buffer pool with the intention that they will be reused, and accessing them from RAM is faster than from disk. Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache.

2013-10-15

3,478 reads

External Article

SQL in the City Charlotte 2013

Join Red Gate on the day before PASS Summit for a full-day of free training from SQL Server MVPs and top presenters. Get $200 off your PASS conference ticket when you register for SQL in the City Charlotte, which takes place on Monday October 14.

2013-10-02 (first published: )

4,122 reads

External Article

SQL in the City Atlanta 2013

SQL in the City is coming to Atlanta on October 11. The second stop on the SQL in the City US Tour brings you SQL Server MVP experts including, Steve Jones and Grant Fritchey. Learn top tips and best practices for SQL Server database development and administration, discover the latest Red Gate tools, and network with fellow data professionals.

2013-10-01 (first published: )

3,799 reads

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

By

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...

A Cloud Dependency Failure from Amazon

By

I went to sleep while reading a Kindle book on my phone. I know...

Deploying AI in logistics (the unfiltered version)

By

A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...

Read the latest Blogs

Forums

BCA KCP Mangga Dua HUB/CS 08216977701

By noumanarshad

Pst. Perd. Grosir Psr Pagi Lt. 2, Bl. KA Jl. Arteri M.D No.001A B,002...

Kantor BCA Temanggung Telp/wa 085169998803

By Exam Alert

Telp/wa 085169998803 Jl. R. Suprapto No.21, Kauman, Temanggung II, Kec. Temanggung, Kabupaten Temanggung, Jawa...

BCA KCP Pasar Minggu Center HUB.Tlpn.0821•3111•185

By noumanarshad

BCA KCP Pasar Minggu Center HUB.Tlpn.0821•3111•185 Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu,...

Visit the forum

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      1960
If I run this code, how many rows are returned?
SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers