This month’s T-SQL Tuesday is hosted by Brent Ozar and he’s asked everyone to find interesting bug or enhancement requests in Microsoft Connect related to SQL Server. The Connect item doesn’t have to have anything to do with T-SQL – it could be about the engine, SSRS, R, the installer, whatever. Now, more than ever, Microsoft has…

Read More T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests

The Rochester, NY chapter of PASS is holding our 6th annual SQL Saturday on April 29th, 2017! As always, RIT is hosting our event on campus.

SQL Saturday is a free day of training centered on the Microsoft Data Platform. Volunteer speakers come from all over the country (and sometimes beyond) to share their knowledge with attendees. There are sessions available for professionals of all skill levels, whether you’re just starting to learn about databases or a seasoned veteran, in addition to valuable professional development guidance.
Why should you attend?

Read More SQL Saturday Returns to Rochester!

It’s 2016. So why are we still dealing with T-SQL code and design patterns that were designed 7 versions ago?   In the 15 years I have been using databases professionally, we’re still dealing with: Peoples’ names are split into first name, last name and middle initial fields. Ignoring that this falls afoul of several of the…

Read More T-SQL Tuesday #83: Why Leave Well Enough Alone?

This week’s #sqlnewblogger posts! Author Post @eleightondick [T-SQL Tuesday] Data modeling: The trouble with prefixes | The Data Files @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug Automatically name primary key constraints in SSDT | the.agilesql.club @rabryst Born SQL on Twitter: “Temporal Tables – Under the Covers with the Transaction Log.  @YatesSQL Community Involvement–Why Wait?…

Read More SQL New Blogger Challenge November 2015 Edition – Week 3 Digest

This week’s #sqlnewblogger posts! Author Post @arrowdrive Anders On SQL: T-SQL Tuesday #72: Data modelling gone extremely wrong @rabryst Time After Time – An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean @EdDebug Deploy SSDT INSERTS in Batches | the.agilesql.club @ALevyInROC Don’t Trust the Wizard @DBA_ANDY Nebraska SQL from @DBA_ANDY: T-SQL Tuesday…

Read More SQL New Blogger Challenge November 2015 Edition – Week 2 Digest