Posts tagged ‘sqlu’

SQL University History Week II: Current Events

pass_logo Welcome back students! In our last lesson we covered the history of SQL Server, the product. This is important stuff to know in order to understand the evolution of the technology you’re working with. SQL Server has made many strides and it continues to do so to this day. Today’s lesson we’re going to cover current events. The reason we’re covering current events is because this past week was the annual conference for PASS called the PASS Community Summit. PASS Summit Unite 2009 is the largest, most focused, and intensive Microsoft SQL Server conference in the world.

Sounds great doesn’t it? Well you might be asking yourself: What is PASS? I’m glad you asked! PASS stands for the Professional Association of SQL Server. PASS is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (Virtual Chapters) to webcasts and the annual PASS Community Summit – the largest gathering of SQL Server professionals in the world – PASS is dedicated to helping its members Connect, Share, and Learn by:

  • Facilitating member networking and exchange of information through our websites, Chapters, annual Summits, regional and local events, and virtual communities
  • Working with Microsoft to influence the evolution of SQL Server products and services
  • Delivering high quality, up-to-date, technical content, presentations, and other educational material for professional development

PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. (Source: About PASS)

If you’ve been following anyone in the SQL community either via Twitter, reading SQL blogs, or browsing around any SQL-related forums you may have noticed a very large buzz in the community about the conference this week. There’s very good reason for this: The PASS Summit is the Superbowl of SQL Conferences (or World Cup for my international friends). This is the one conference during the year where folks from all over the world unite in one place and share their SQL skills, experiences and friendships. The motto for PASS is Connect, Learn, Share and that’s definitely what the Summit embodies. I personally have never been but this year I followed along via Twitter and it almost felt like I was there (Twitter is even funnier when you see the after-hours activities like Karaoke).

There have been a slew of blog posts about why the Summit (and I stress that the conference is called Summit, the organization is called PASS but many mistakingly refer to the conference as just PASS) is so great to attend. This post will try to not turn into one giant PASS Summit commercial but its hard not to gush over how awesome it is when you see all the knowledge shared and how the community rallies together. Suffice to say the annual conference is definitely worth your time and money to try and attend.

Beyond the conference PASS offers much more to the community. As a professional association they offer education resources for all members. How does one become a member? Don’t worry, it’s free and everyone is invited to join! Just follow this link to register. So what kind of learning resources does PASS offer? Well for starters the website offers links to resources to just about anything you can think of from technical articles, webcasts, tips/tricks from the experts, newsletters, tips/resources for speakers and much more. But the website is just the tip of the iceberg! PASS truly is a worldwide organization and that fact can be seen through the proliferation of local and regional SQL Server User groups. PASS has chapters all over the world and with each passing year it keeps growing! You can check the PASS Chapters page and check your region to see if there is a user group in your area. If there isn’t a user group located near you then guess what? You can establish one yourself! To get started on that journey check out the page on what steps are needed to set one up and become an official PASS chapter!

PASS Chatpers Worldwide as of 2009

PASS Chatpers Worldwide as of 2009

Another great resource PASS has established in the past year has been the proliferation of Virtual Chapters (formerly called Special Interest Groups or SIGS). These virtual chapters each have a focus on a different aspect of SQL Server such as Business Intelligence, Application Development, Professional Development, Virtualization, Women in Technology, Performance and Database Administration. These Virtual Chapters act just like local chapters in that they meet on a regular basis but rather than meeting in a physical location they meet online via LiveMeeting. These meetings are great and open to everyone. At these meetings they have someone in the community do a one-hour presentation (much like you would see at a conference or a local user group meeting). These are fantastic, and best of all free, learning resources which helps you advance your knowledge and career!

Another great item to come out of the PASS umbrella are the free, local training events called SQLSaturday. These are free 0ne-day training events modeled after code camp events. At SQLSaturday there are several tracks based on different aspects of SQL Server (i.e. Administration, BI, Development etc.). These events attract speakers from all over and gives a chance for attendees to not only learn about SQL Server and PASS but gives them a taste of the community as well. If you’re interested go check out their events page and see if there is one scheduled for your area!

While there are many, many learning resources for SQL Server out there such as SQL Server Central, SQLShare and SQLServerpedia, know that we are all united when it comes to PASS since we are all members of the same fraternity of data professionals.

In our last class for this week I’ll cover the future of SQL Server, PASS and you!

Continue on to part III

SQL University: History Week Pt. 1

stockxchng-history-lesson-3-by-lusi Well this is going to be an interesting week as we have the PASS Summit going on. What’s the PASS Summit? What’s PASS? Why are the people on Twitter so excited about #sqlpass? Well by the end of the week my hope is you’ll have an understanding of where the Microsoft SQL Server (the product) came from, where its going, what PASS is and why its important to us.

So the past few weeks you’ve been working with Microsoft SQL Server. Some of you may have worked with it for years and others may be using it for the first time. So how did this fantastic relational database product come to be? Microsoft SQL Server’s humble beginnings started in 1989 with the release of SQL Server 1.0. This was Microsoft’s first entry in to the database market and the product’s codebase was based on Sybase SQL Server 3.0 code.Eventually Sybase and Microsoft went their separate ways. Starting from version SQL Server 7.0, released in 1998, the codebase was re-written from the legacy Sybase code.

In 2000 Microsoft released the first version that did away with the previous numbering scheme and was released as (and the originality award goes to…) SQL 2000. This product marked the first time the product was available with an edition aimed at the IA-64 architecture. The IA-64 version of SQL 2000 was available some time after the x86 version. It was also a little finicky, being more prone to crashes than the x86 edition (thanks to Gail Shaw for this info!). This evolution of the product also saw the introduction of SQL Server Reporting Services (SSRS) as an add-on in 2004. Reporting Services would re-emerge in SQL Server 2005 with many improvements in regards to end-user tools, self-service ad-hoc reporting and ease-of-usability. This release also gave us a built-in ETL (extract,transform,load) tool called Data Transformation Services (DTS).

For the 2005 release, SQL Server 2005 was considered a revolutionary release by many. Quite a few things were overhauled and improved upon. The Enterprise Manager was replaced by the SQL Server Management Studio (SSMS). SSMS is basically a Visual Studio shell with SQL Server components built in which made for a cohesive development/management environment for users. As well as getting a new management interface there were huge new features and enhancements to the database engine itself. SQL Server 2005 was the first SQL Server to include support for managing XML data types. Some other improvements 2005 brought were better indexing algorithms, better recovery systems, Dynamic Management Views, instant file initialization, better security (granular role/schema/object permissions), introduction of SQL CLR which allows developers to use native .NET code within SQL Server (assuming your DBA allows it, hehehe). Another huge change in this release was the replacement of DTS with a far superior and more polished ETL solution in SQL Server Integration Services (SSIS).

The most recent iteration of the product is SQL Server 2008. This version built upon the leaps from its previous release and improved upon them. These improvements came in the form of new features such as Policy-Based Management, the Performance Data Collector, data compression, resource governor (which allows dba’s to restrict resources for certain queries), transparent data encryption, data auditing, server group management in the form of the Central Management Server, the introduction of the MERGE statement, introduction of LINQ, support for geospatial data, filtered indexes, new DATE/TIME data types (until this point date/time was one column and together, this release allowed you to separate the two), BI improvements, and much more.

So what’s next? Glad you asked! The next announced release is referred to as SQL Server 2008 R2. This release offers mostly higher spec bumps (such as support for more processors, more memory, etc.) but also offers a few new feature additions as well. Some of these new features include Master Data Services, SQL Server Utility (a new way of managing databases as Data-Tier Applications), Data-Tier Application capabilities (DAC), PowerPivot (formerly known as Project Gemini) and more. Here’s a full list of all the various improvements available in the R2 release.

Note: This article was heavily drawn upon entries from Wikipedia. Click here to read the full SQL Server entry from there.

Continue on to part II

SQL University:Computer Lab at SQLServerbeta.com

Good afternoon students, this is just a quick announcement to let you know that SQL University (sort of) is offering a computer lab for students to cut their teeth on SQL 2008 technology. I say sort of because this lab is actually offered via a partnership with PASS, Maximum ASP, and DELL Computers at http://www.sqlserverbeta.com .

The labs offer up a virtual sandbox environment where you can discover and practice everything you learn here in a dedicated hosted environment! Here’s the lab description:

The beta team has created a Microsoft® Hyper-V™ based private cloud to host individual instances of Microsoft® SQL Server® 2008 on which you can perform your experiments.  You will have access to a Hyper-V instance and SA rights to a SQL Server Instance. The instance is available to you for three continuous hours and you are welcome to come back and use the beta instance as often as you like.
 
We have included the following sample databases for you to perform your experiment upon:
  • Adventure Works 2008 OLTP
  • Adventure Works 2008 DW
  • Adventure Works 2008 AS
  • Adventure Works 2008 LT

We will be adding additional labs in the coming months in preparation for the release of SQL Server 2008 R2, so check back often.

So how do you get in on this great deal? Well just head on over to http://www.sqlserverbeta.com and Register!