Speaker of the Month: January 2015

I love it that my first post of the new year is going to be Speaker of the Month. I’m...

Building Debug Symbols – Troubleshooting symbol building

Recently,I have been working with the Debugger Symbols for SQL Server to generate call stacks and learn more about the internals of SQL Server.  I approached one of...

Building Debug Symbols – Troubleshooting symbol building

Recently, I have working with the Debugger Symbols for SQL Server to generate call stacks and learn more about the...

How to insert value in Identity column ? TIP #80

 
Happy new year 2015 .
Suppose you have a source table and one destination table (Which is exact replica of source...

I’m an MVP: now what?

Today when I checked my mailbox I found an amazing surprise: I joined the ranks of the Most Valuable Professionals...

Powershell – Copy the Latest Backup

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess...

Tracing call stacks in SQL Server – Installing the Debugging Tools for Windows (WinDbg) on Windows 8.1 and generating debug symbols for SQL Server binaries

Where to get the debugger tools To generate the needed symbols you will need the “Windows Software Development Kit (SDK) for Windows 10” download here: https://dev.windows.com/en-us/downloads/windows-10-sdk and click “Download the standalone SDK” ...

Tracing call stacks in SQL Server – Installing the Debugging Tools for Windows (WinDbg) on Windows 8.1 and generating debug symbols for SQL Server binaries

Where to get the debugger tools
To generate the needed symbols you will need the “Standalone Debugging Tools for Windows (WinDbg)” download here: http://msdn.microsoft.com/en-us/windows/hardware/hh852365

How to...

[SQL Snacks Video] Performance Tuning 103 – T-Logs and VLFs

Finally the arrival of Part 3 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand...

2014 – A year in review.

TweetG’day,
And so another year passes, and as I’ve never wrote a “year in review” post before now seems like a...