January 2012 Las Vegas SQL UG

Categories: News, Professional, SSC, SSSOLV
Tags: , ,
Comments: No Comments
Published on: December 30, 2011

This month I am attempting to get a jump on things a bit.  I am hoping to get the info out in a more timely fashion throughout this new year for the User Group meetings for S3OLV.

Out with the old and in with the new.  Let’s ring in the New Year for the Las Vegas SQL User Group together and with a bang.

Helping us will be Joshua Lewis as he presents the first part in his three part series on XML.

XML for the DBA – A Series (part 1)

XML has been a feature available in SQL Server for a long time, but the capabilities were limited, and it was never very easy to use.  This was always a huge disappointment to me, because XML in itself should be any DBA’s best friend when it is used properly. What we typically see in applications is not the prettiest example of XML;  it is typically used by developers to accomplish things very quickly when it comes to data.

For the most part, XML is a heap of data that can get very large, doesn’t store well, and isn’t easily indexed.

But consider this:  What if a very data-centric person were the one dictating the XML (like a DBA)?  XML, when used properly, can be a very powerful tool in data storage and presentation.

About Josh

Joshua is a Database Professional, with over 10 years’ experience in Configuration / Administration of Data Infrastructures, Performance tuning, Development, and Business Intelligence Architecture, using Microsoft’s suite of SQL Server Products.

Over the years, and in varied industries, he has supported and optimized large DataCenters, developed multiple ETL platforms for handling client eligibility / enrollment / claims, and designed security policies and procedures to meet various industry security certifications (Sarbanes-Oxley, HIPAA, and CISP).

Currently, Joshua is expanding his knowledge and skills to .NET, building Value-Add interfaces and integrations to SQL Server and Integration Services through the use of SQL-CLR and Custom SSIS Components.


LiveMeeting Information:

Attendee URLhttps://www.livemeeting.com/cc/UserGroups/join?id=GW2GD2&role=attend

Meeting ID:  GW2GD2

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

December 2011
« Nov   Jan »


  • @JanosBerke: I got high # of threadpool wait since DBM set up (4 DBM sessions) on Std. ed. Can it be due to single threaded redo? #sqlhelp
  • @sql_r: @MJSwart I'm thinking no, unless you have something to trap it, like extended event or event notification, etc. #SQLHelp
  • @MJSwart: #sqlhelp If client code catches a deadlock SqlException (ex.Number = 1205), is there a way for the client to retrieve the deadlock graph?
  • @edvaldocastro02: Os it possible to check the percentage of filling for the active VLF? #sqlhelp
  • @lundnak: #SQLHelp Bulk Insert from DFS path failing with "Access is Denied". UNC path using svr name works. Both Using Kerberos Delegation.
  • @sqlsurfer7: Is there a process to provide basic monitoring for Windows and SQL Server that if a problem occurs I can go back in time? #sqlhelp
  • @Bobr_1981: Why do we have to script out logins,linked servers n other stuff? 2/2 #sqlhelp
  • @Bobr_1981: Why can't master db backup from 1 inst restored directly to another inst.Say from default inst to a named inst of same build? 1/2 #sqlhelp
  • @retracement: @DJSQL Youll also find benefit querying partition_stats which show even uncommitted row counts of tables. Useful. cc. @SQLSoldier #sqlhelp
  • @retracement: @DJSQL If you are asking for the reasons I think you are :) then execution time/row count gonna give part of story cc. @SQLSoldier #sqlhelp

Welcome , today is Friday, August 29, 2014