SQLAuthority News – PASS Sessions – I will be there!

As PASS is now one week away and I am all excited for the same. I am going to attend following two sessions for sure. I encourage all of you to also visit the same sessions. We can all talk about SQL , SQL Integration as well Beyond Relations.

First sessions I will be attending of Rushabh Mehta, he is Managing Director of Solid Quality India.

RushabhSmall SQLAuthority News   PASS Sessions    I will be there!

Overcoming SSIS Deployment and Configuration Challenges

Rushabh Mehta (Solid Quality Learning)

Session Details

It is no secret that a main deficiency of SSIS is deployment. Have you wanted to punch a wall before when trying to move a package from one server to another? You’re not alone. This session will be more than just SSIS deployment anger management. We’ll look at how to overcome the deployment challenges by considering configurations, package and connection security, and deployment approaches. And don’t miss the decision workflows that will help you down the right path on choosing the right storage and deployment approaches depending on your situation!

Second sessions I am going to attend of Jacob Sebastian, he is founder of BeyoundRelational.com.

jacobsmall SQLAuthority News   PASS Sessions    I will be there!SQL Server 2008 – Create powerful XML Schema collections to validate your XML documents

Jacob Sebastian (beyondrelational.com)

Session Details

XML is getting more widely used both inside and outside SQL Server. Stored procedures and functions that accept XML parameters or generate XML documents are part of almost every database project these days. When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. Using an XSD (XML Schema Definition) Schema, you can validate the structure and content of an XML document. SQL Server introduced XML Schema Collections in SQL Server 2005 and added a number of enhancements in SQL Server 2008. An XML data type variable or column that is bound to an XML Schema collection is called TYPED XML. When a TYPED XML column or variable is modified, SQL Server will validate perform the validations defined in the SCHEMA Collection and the operation will succeed only if the validation succeeds. In this session we will discuss SQL Server XML Schema collections and see how to create powerful XML Schema Collections to validate XML documents with diverse structure and content.

I am also preparing my schedule as I want to attend almost all the sessions as I can. Please read following related post about SQL PASS.

Related Articles:
Why I am Going to Attend PASS Summit Unite 2009- Seattle

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational

SQL Server MVP and my personal friend Jacob Sebastian has published my interview on subject of Beyond Relational on his famous site Beyond Relational. Jacob is quite known for his T-SQL challenges as well. If you have not ever tried one, I suggest you give it a try and you will be addicted to it.

Beyond Relational is interesting term. In simple terms, this means that it is beyond relations to traditional RDBMS. There are so many things to talk about when we stop thinking in terms of relationals. When we say “beyond relationals”, this does not mean that we move away from the relational database. In fact, for me words suggest quite the opposite; they imply strong ties to relational databases. It would not be termed “beyond” if it had nothing to do with relationals. The science of “beyond relational” picks up relationals where traditional RDBMS stop.

Please read my complete interview here and let me know what you think about Beyond Relational.

Reference : Pinal Dave (http://blog.sqlauthority.com)