Every week, Pragmatic Works offers up its "Training on the Ts" webcast series and this month, in honor of Women's History Month, the series is showcasing all of its sessions with women speakers. Doing this offers all of us a chance highlight some of the female voices in our male dominated field. Hopefully, this focus inspires some … Continue reading Pragmatic Works Webcasts This Week #passwit
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of the Performance Impacts of User Defined Functions. A Function by Any Other Name is a Function from Jason Strate Download: [download id="68"] Other resources: http://msdn.microsoft.com/en-us/library/ms189294.aspx http://www.sqlteam.com/article/intro-to-user-defined-functions-updated http://www.amazon.com/Transact-SQL-User-Defined-Functions/dp/1556220790/ref=sr_1_1?ie=UTF8&s=books&qid=1268026139&sr=8-1
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could be. But if you don't know enough about them, they may turn out to be the source of all of your problems and opening the door to architecture choke full of disaster. This week, I'll … Continue reading Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works
Here are the presentation materials for today's Pragmatic Works Training on the T's session What Are You Waiting For – Explanation of the Value of Performing Wait Analysis. The other session that I mention during the presentation is Extended Events: Work Smarter, Not Harder. http://www.slideshare.net/JasonSStrate/slideshelf Materials: [download id="67"] If you have any questions from the session, please … Continue reading Presentation Materials “What Are You Waiting For?”
Ever have your SQL Server slow down for reasons that you can't explain? Or did you spend all night tuning a query to perfection only to have it bog down in production? Want to find out what's going on? If so, read on... This week, I'll be presenting my session "What Are You Waiting For … Continue reading Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works
Seems so early in the year, but it's already time to start getting ready for this year's PASS Summit. There are two things to think about early on with the summit. First, what are you expecting from the summit? The summit is built based on community input and PASS needs to hear your opinions on what … Continue reading Start Getting Ready for PASS Summit 2013
Next month... on March 2... I'm going to jump into a lake in Minnesota. Now it's cold in Minnesota. In fact, they're going to have cut a hole in the ice so that we can do this. Why are me and a few friends doing this? Well, partly because we are a little bored. But … Continue reading 2013 Polar Plunge #SQLPlunge
Do you know anyone that lives in or around the great white north that is Fargo, North Dakota? If so, then I'd like your help in with an introduction on LinkedIn. Let's see how many people in the area are 6 or less degrees from me. Even if the person isn't in IT or doesn't … Continue reading Six Degrees of SQL Saturday Fargo
It’s been a while since I mentioned anything about the SQL Saturday in Fargo. So I thought I would let people know that we’ve now got ourselves three sponsors – Confio (Silver), PASS (Bronze) and Steve Stedman (Blog). Every little bit helps and we appreciate all of our sponsors. Are you interested in helping to … Continue reading SQL Saturday Fargo Update
In the past couple weeks, I've gotten a couple reports of issues with sp_indexanalysis. The update today fixes those issues. It's fun to finally be playing with these scripts again. I'm hoping to start writing blog posts showing the scripts in action in the next couple weeks. INDEX ANALYSIS UPDATES The main updates to the … Continue reading Index Analysis Update – January 2012
Strate SQL 