Since it's Sunday (almost Monday), I thought I would chip into Un-SQL Friday. Before I get down to brass tacks, an explanation is probably in order. Last week, Jen McCown (Blog | @midnightdba) suggested a new blog round table that has nothing to do with SQL Server but is adjacent to SQL Server. This month’s … Continue reading Un-SQL Friday 001: Branding
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed the nodes() method in my XQuery for the Non-Expert series. With this next post, we’ll be looking into the query() method. The main use for the query() method is to retrieve child … Continue reading XQuery for the Non-Expert – Query
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed XMLNAMESPACES in the XQuery for the Non-Expert series. With this post, we’ll be looking into the nodes() method. Where XMLNAMESPACES is the map through the XML document, the nodes() method is the … Continue reading XQuery for the Non-Expert – Nodes
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Let’s talk about XMLNAMESPACE. Are you excited? Does your skin crawl with excitement – or rather unease at the thought of leveraging this T-SQL clause? The goal here is to make XQuery and it’s functions and clauses easier … Continue reading XQuery for the Non-Expert – XMLNAMESPACE
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. It’s time for a new series to blog posts – XQuery for the Non-Expert. The purpose for these posts will be to provide a foundation for using XQuery against XML. Myself, I am not an XQuery expert. These … Continue reading XQuery for the Non-Expert – Terminology
Finally up to the last post of this series resurgence. Time to update the Index Analysis Custom Report that I developed last year. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find … Continue reading Return of the Index Analysis Report
If you don’t know where you've been, how can you expect to know where you are going. Seems like such a simple little line and I’m sure many of us can look at history, politicians, and maybe that restaurant review that you didn't heed when it comes to this line. But this also applies to DBAs and more specifically … Continue reading If You Don’t Know Where You’ve Been
Shrinks have no idea what’s wrong with you when you walk in the door. In you come you try to describe what appears to be the problem and then they start asking about your mother. But you don’t want to talk about your mother, most likely you’d like some relief to whatever the concern is … Continue reading Analyze This – Your Indexes Analysis – Part 1
Have you ever needed the definition of a view, stored procedure, or user defined function? I sure hope you have - otherwise reading any more of this posting will be more than pointless. For those of you still with me, have you ever also not wanted to find that definition without have to browse through … Continue reading I Don’t Want To Use the Object Browser (sp_helptext)
Strate SQL 