Learn more about SQL Server tools


SQL Server Developer Tips and Tricks

Latest SQL Server Tips
Simple SQL Server Code Deployments with xSQL
To put it mildly we have been having challenges with our code deployments. Just about every time we have a deployment there are issues. It never fails. Some small and others causing downtime. We have issues with consistently deploying code partially because my team is stretched thin. Unfortunately, the code deployments are starting to reflect poorly on our Developers and DBAs. I think I am finally getting through to my team that our code de
What's Trending?
Rolling up multiple rows into a single row and column for SQL Server data
I need a way to roll-up multiple rows into one row and one column. I know I can roll-up multiple rows into one row using Pivot, but I need all of the data concatenated into a single column in a single row. In this tip we look at a simple approach to accomplish this.
SQL Server Tutorials
SQL Server Webcasts
Improving SQL Server Performance by Writing Faster T-SQL Code
Stored procedures and functions are the mainstay of SQL Server coding. In this session you will learn techniques to locate problematic code and to improve the performance of procedures and functions.

Step one is to discover where the time is going using standard server traces, code that analyzes the trace, and the new SQL Server Extended Events. Once we know where the time is going we will look at strategies to improve performanc
All Categories

Sponsor Information