Press Release


Technical Article

SQL Saturday #310 - Dublin, Ireland

SQL Saturday is coming to Dublin on September 20, 2014. Come for a free day of SQL Server training and networking. This year's conference features a mix of levels, topics, and speakers like Buck Woody (Big Data), Jen Stirrup (PowerBI), Denny Cherry (Storage), Red Gate's Tom Austin (Continuous integration), and more. Register while space is available.

2014-08-22

10,155 reads

Technical Article

SQL Saturday #300 - Kansas City

SQL Saturday is coming to Kansas on September 13, 2014. Our very own Steve Jones will be presenting, alongside other big names like Glenn Berry, Kathi Kellenberger, Sean and Jen McCown, Jason Strate, and many more. Register while space is available.

2014-08-18

8,088 reads

Technical Article

SQL Saturday #323 - Paris

On September 13, 2014 the French SQL Server Community (GUSS) will be holding a SQL Saturday conference. The event is free to attend, with 4 paid-for pre-conference sessions available. Register while space is available.

2014-08-15

7,687 reads

Technical Article

SQL Saturday #320 - Raleigh, NC

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. The Triangle SQL Server user group (http://www.tripass.org) of Raleigh, NC is hosting this event on September 6, 2014. Register while space is available.

2014-08-12

8,228 reads

External Article

SQL Monitor Custom Metric: WriteLog Wait Time

During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.

2014-07-25

9,844 reads

Technical Article

SQL in the City: Save the Date

SQL in the City is coming back to London and Seattle in 2014. The London event will take place on October 24 (before Tech Ed Europe) and in Seattle on November 3 (before PASS Summit). Keep an eye on the event website and @redgate for updates.

2014-07-21

11,275 reads

Technical Article

SQL Saturday #302 - Albany

SQL Saturday is coming to Albany, NY on July 26, 2014. This is a free full day of training and networking for SQL Server professionals. This event also features a paid-for precon session with Grant Fritchey on query performance tuning. The event is soon so register while space is available.

2014-07-16

9,085 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

setting an ssis param dynamicaly when the sql agent job runs

By stan

hi i was hoping for a more elegant way of setting a pkg level...

Query compile/runtime issue

By as_1234

I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

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

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 n;

See possible answers