SQL Nuggets - Database tips for developers

SQL Server Tips for Developers!

The primary focus of SQL Nuggets is to offer useful tips for developers and other IT professionals who are using SQL Server. Written in short, to the point posts I will highlight a specific feature, how you can use it, and why you should use it. Simply put, the goal of this blog is to help others enhance their applications by taking advantage of what SQL Server has to offer.

Discover Which Deprecated Features Are Being Used

Eric Cobb • September 13, 2016DB Engine, System Views

With each new release of SQL Server comes a list of new features, along with a list of features that have been deprecated. These deprecated features are not immediately disabled or removed, but they are considered to be features not supported in a future version of SQL Server, and should no…

Slides From Dev Data Day 2016

Eric Cobb • August 21, 2016Conferences

Dev Data Day 2016 wrapped up yesterday, and I really enjoyed it. The organizers did a fantastic job, and I think everything flowed exceptionally well, especially considering that this was the first year for this conference. I’m already looking forward to Dev Data Day 2017! I had a good turnout…

Speaking At Dev Data Day 2016

Eric Cobb • August 16, 2016Conferences

If you’re in the Birmingham, AL area this Saturday (August 20, 2016), come join me at Dev Data Day at Samford University, where I’ll be presenting SQL Server Tips For Everyday Programmers. I’m looking forward to this event, as it has more of a focus on Microsoft technologies than some…

You Can Now Specify MAXDOP For DBCC CheckDB!

Eric Cobb • August 8, 2016DB Engine

I just stumbled on this today. According to the DBCC CheckDB documentation, as of SQL Server 2014 Service Pack 2 you can now specify MAXDOP when running DBCC CheckDB! The documentation states: MAXDOP Applies to: SQL Server 2014 SP2 through current version. Overrides the max degree of parallelism configuration option of sp_configure…