PASS Data Architecture Virtual Chapter presents Steve Simon

On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.

SQL Saturday #229 - Dublin

SQL Saturday Dublin is hosting a two-day training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development. The free training event will be Saturday June 22 2013, and three preconference sessions (not free) will take place the 21st.

Help us improve SQL Source Control

We've been working really hard on SQL Source Control, and need your input. We're currently working on suggestions from our user forum and on an updated migrations feature that supports all source control systems and works across branches. We'd love it if you could spare 10 minutes to complete this survey. If you complete the survey by Friday June 14, you could win a $100 Amazon voucher. There are two up for grabs!

New Custom Metric: Percentage of blocked connections

This metric reports the number of connections that are currently blocked, divided by the total count of current connections.

Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention.

SQL Saturday #202 - Edinburgh

Join us for a free day of SQL Server Training on June 8, 2013. There's also a Friday Preconference Training Day with Jonathan Kehayias and Joseph Sack.

Show off your Solutions

We're looking for scripts that you use in your daily job to find, fix, and solve issues in your environment.

New SQL Monitor Custom Metric: Issues found by sp_Blitz

This custom metric adds Brent Ozar's popular SP_Blitz scripts to Red Gate SQL Monitor. It looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. It’s great for quickly understanding the state of a server you've been asked to look after.

Red Gate Software Brings Free SQL Server Training Back to US Due to Popular Demand

Red Gate Software is bringing SQL in the City, the popular free training event, back to the US in three new cities. This October, the events will take place in Pasadena, Atlanta and Charlotte.

Transaction Log Stairway Series available as a book

Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.

SQLServerCentral Hosts AdventureWorks on Azure

SQLServerCentral and Red Gate software have agreed to host the AdventureWorks database on the Azure platform and give free access to anyone that wants to practice querying it.