Top 5 Reasons for Wrong Results in SQL Server
Tip : Top 5 Reasons for Wrong Results in SQL Server
Monthly Archive: November 2016
VS Code on Mac Meets SQL Server on Linux (in Docker)
I describe my steps for setting up a development stack, with VS Code on Mac, managing SQL Server on Ubuntu, inside a Docker container.
A Big Deal : SQL Server 2016 Service Pack 1
Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.
New Features in SQL Server 2016 Service Pack 1
Tip : New Features in SQL Server 2016 Service Pack 1
Can comments hamper stored procedure performance?
After a recent conversation on Twitter,I show where excessive comments in your stored procedures might have an impact on performance.
#BackToBasics: CAST vs. CONVERT
I explain why I always opt for one of these options over the other.