T-SQL Tue #51-I see your bad decision and raise a horrible one
TSQL2sday topic number 51 is outstanding. Hosting Adam Machanic‘s rotating blog party this month is Jason Brimhall aka Twitter @SQLRnnr who asks “when has somebody (a CTO, Developer, Business User) placed a bet … Continue reading
XEventaphobia: Conquer your fear
When Extended Events first came out in 2008, I – like many people – took a look and sheepishly walked away. I knew what was being communicated was important and cool, but it … Continue reading
The next DBA I hire. Junior ?
There are some initiatives on the horizon that even the mustaches upstairs can interpret as creating a future that will require more hands on deck. So I was given some spots to … Continue reading
T-SQL Tue #50 Log Shipping With Powershell – A Better Mousetrap?
This month the Tsql2sDay topic is automation – props to our host SqlChow for the topic. Props to Adam Machanic for the rolling party. Post Disclaimer: Normally if there is a process that Microsoft … Continue reading
Can you read the syntax of books online?
If you have any professional experience with SQL Server I guarantee at some point you have relied heavily on books online (Tech Net, MSDN). The last Microsoft test I passed I mostly focused on the “skills measured” summary … Continue reading
XQuery for the SQL Server DBA
A few weeks ago I embarked on a series to present the basics of XQuery and XPath for the SQL Server database administrator. This is the final post and will also serve … Continue reading
XQuery for the SQL Server DBA: Iteration and FLWOR
Let’s face it. XQuery is at odds with almost everything a relational database holds dear. Working with both at the same time can make the DBAs mind a blur of mixed messages. Often, it just feels … Continue reading
XQuery for the SQL Server DBA: Math & Strings
Up until now we’ve covered path statements and namespaces to retrieve values from XML within SQL Server. It’s pretty common once you start pulling values from any data source that you’ll need … Continue reading
XQuery for the SQL Server DBA: Namespaces
Do you hate XQuery? You’re not alone… heck, I’m writing this blog post and I’m not that big a fan of it. Dr David DeWitt has said a couple times … Continue reading
T-SQL Tuesday #49 – What are you WAITFOR?
It’s TSQL Tuesday again !! Props to host SQLSoldier for the topic, WAITS. We have been trying to grow the DBA team – so the past few months have been busy on the … Continue reading
Russ Thomas - SQL Judo 