Press Release


External Article

SQL Monitor Custom Metric: Buffer Pressure

Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.

2014-10-14

6,901 reads

Technical Article

PASS Summit, Seattle, WA

Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference – planned by and for the SQL Server community. Red Gate will be exhibiting, so drop by their booth and say hello. Register while space is available.

2014-10-13

8,510 reads

Technical Article

SQL Saturday #337 - Portland, OR

SQL Saturday is coming to Portland on November 1! Join us for a free day of SQL Server training and networking. Speakers at this event include Red Gate's Grant Fritchey, Kathi Kellenberger, Benjamin Nevarez, and more. There are also 3 paid-for pre-con sessions for this event. Register while space is available.

2014-10-09

7,670 reads

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

By

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

Are luxury packages in Andaman suitable for a honeymoon?

By andamantourtravelpackage

Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...

Job Opening for ERP Systems Administrator - Hybrid

By rdr1

Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table:

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960
If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers