The Hibernate ORM and SQL Server
Using an ORM with SQL Server introduces unique challenges. I have listed a few of my experiences, hoping it can help someone.
Retrieving SQL Server Query Execution Plans
Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how.
DBAs Need to Learn to Develop
SQL Server is growing as a platform and Steve Jones says that DBAs need to learn development skills.
Generate Deadlock Summary Information
This article will show you how to extract a summary of tables affected by deadlocks.
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.
Creating SSRS Tabular Reports with Sparklines and Charts
Learn how to add a sparkline and line chart to your SQL Server 2014 Reporting Services reports.
The Five Year Plan
Is your IT department outdated? There's a prediction that they won't be around in five years. Steve Jones doesn't agree.
Your Professional Development and the PASS Organization
There are so many ways of keeping your technical skills and knowledge up-to-date. There are books, articles, conferences, video courses and so on, but nothing beats discussion and debate with professional people in other organisations facing a similar range of technical challenges, some of which you share, and others you maybe haven't yet. PASS is unique in providing just this vital ingredient for database professionals using the Microsoft Data Stack.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers