By Eitan Blumin
Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so it’s hardly “new” any more. But in reality, many DBAs and database users are still not aware of this feature, don’t know how to utilize it, or are afraid to do so because they’re not familiar with it.
In my previous post in the series, Service Broker Sample: Multi-Threading, I showed a rather advanced scenario where we can implement a multi-threading solution inside the SQL Server database engine. In this post, I hope to show a simpler scenario...
Dikla Aviv has written a post to help each and every one of us figure out a career path. Sometimes you just need to stop and take a look around.
Guy Glantser is on his way home! At the final day of the PASS Summit, he went deep into the internals of SQL Server with four intensive sessions that filled his head with dreams of further study...
Guy Glantser is on his fourth day of the PASS Summit this year and meeting some people whose work he's been reading all these years. Kimberly Tripp, Jonathan Kehayias, and Paul Randal on today's post!
Guy Glantser is getting into the PASS state of mind, the PASS world, the PASS people. Today he covers three learning sessions he attended:
Query tuning step by step
The internals of SQL Server memory
SSIS and PowerShell and how they can be friends
See what he thinks of each one!
Guy's second day at the PASS Summit was all about the PASS organization, meeting with chapter leaders, sharing their stories. He shares with us what it was like. Read along!
Guy Glantser went to the PASS Summit for the first time this year! Follow his adventures day by day...
Yossi Mihailovici explains how data compression works in SQL Server, and why you should be paying attention...Read all about it here: http://www.madeira.co.il/compression-much-more-than-saving-space/
Just before the annual PASS Summit, we picked the best SQL presentations by some of the top SQL Server professionals in the world. Our SQL Server experts took the original webcasts and presentations and added their own demos, tips and best practices.
Tuesday, 23.10.12, 8:30-17:00 at Microsoft offices, 2 HaPnina st. Raanana.
It would be easier to understand the meaning of the server side trace if we only understand that beside being a great tool, SQL Server Profiler is nothing but a user interface that runs several system stored procedures which expose the true functionality of SQL Trace. Read Dudi Rosenthal's post: