Learn SQL Server from your favorite aunt! Resources for Kids and Tech. I got to meet with the team who creates SQL Monitor today. When I went to the to the configuration page, I was hoping to see a way to add a database name that was set offline on purpose. My First Look at SQL Monitor.

MERGE Learning AS Target USING SQL. Trying to become someone in the SQL Community. Make sure the package exist on the SQL Server and you have the correct credential to access it. Can anyone help me with this? June 20, 2011.

One, guaranteed to stand out like the beaming smile on my face. And her post My Six Month Plan, Post Brent Ozar Unlimited. He was the primary reason that Rodney and I attended SQLSaturday Baton Rouge. Will always have a special place in my heart. After planting a few see.

Generate a Change Script to Move System Databases. I set this up to be modular and reusable, because I like reusing things. It just outputs a change script and a revert script. You still have to run the generated script, then log on to your server and stop the services and move the files yourself. Copy and paste that in.

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? .

Thursday, August 13, 2015. Our website is currently under construction. If you have any question please email us. Is our Sponsor for the next 3 months! March 12th, 2015.

Documentation, the Necessary Evil. As a consultant, I understand wholeheartedly the importance of documentation as it correlates to the success of the project at hand. Have insomnia? I have just the solution for you! Posted in Random Musings. First Pre-Con is in the Books! That we promised you.

Life, The Universe and SQL Server. Friday, February 13, 2015. PASS presents Business Analytics Conference April 20-22. The Program Team at PASS has outdone themselves this year to recharge and direct the content to include incredibly meaningful, useful and timely training to data professionals in all industries.

So long, and thanks for all the fish. After the strangest pre-employement assessments and interview process I had ever been involved in I eventually got a call that they wanted me to start at the end of August.