Using a gMSA with SQL Server. Comparing Inline and Multi-Statement Table-Valued Functions. Does a Clustered Index really physically store the rows in key order? .

At the End of One Chapter and the Beginning of a New Chapter. I have been told by hundreds of DBAs that I have the best DBA job in the world as Director of DBA Education for Red Gate Software. Reprinted from my editorial in the Simple-Talk. Has uncovered a number of DBAs who might otherwise not have ever been publically recognized for their skills as master DBAs.

2018 Live Class Season Pass. How to Think Like the SQL Server Engine. Diagnosing Slow SQL Servers with Wait Stats. Query Plan Analysis and Tuning.

But what did I want to write about? Is my highlight reel, full of pictures and happy memories from my trips.

Groceries as a Data Problem. Regular Expressions in SQL Server. Buying a Van Using Data. Two of my most popular posts have been about the unpleasant process. A second car would have been useful. My wife and I decided it was time to get one, and the practical choice was a minivan. A vehicle is the 2nd largest purchase most folks make.

Comments Off on Cursor Transformation. One of my favorite presentations to give is called, Changing Your Habits to Improve the Performance of Your T-SQL. After giving this presentation in Austin, TX this past January, I had one of my students contact me. He saw in one of my demonstration how bad cursors can perform. He wanted to see if his stored procedure could be written using set theory. The Reason For the Rewrite. What does this have to do with Cursors? .

Programming Basics - май 2015, Варна. Programming Basics - юни 2015. Programming Basics - юли 2015. Programming Basics - август 2015. Teamwork and Personal Skills - май 2015. Качествен програмен код - юли 2015. Приложения с бази данни - юли 2015. Уеб услуги и Cloud август 2015. Структури от данни - юни 2015. QA Fundamentals - юли 2015.

We tried something new this time, and broadcast the show live on Persicope. Periscope is a service by Twitter that allows each one to start a live broadcast anywhere and anytime from his phone or tablet. We will try it out a few more times, so watch for our announcements about future broadcasts on Twitter. SQL Server Developer Edition vs.

When companies have SQL Server problems, they come to us. With our in-depth SQL Server health checks,.