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.
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.
Meeting ID: GW2GD2