Out of Space - Pawel Potasinski's Web Blog

Polish SQL Server User Group has won a drawing after filling Culminis survey. The prize is $250. We are going to spend it for books I guess. First try and first win! We definitely should try again :-)

Today I attended the BI Day conference organized by Microsoft. The whole event was a success as I understand meeting some nice people and having a good time on technical sessions. This time I was rather disappointed with our local speaker but everything was leveled up by three sessions of Davide Mauri (SQL Server MVP, Solid Quality Mentors). Davide was talking about not very common aspects of SSIS and SSRS 2005. He also had a session about new BI features in SQL Server 2008. I hope to see people like Davide on Polish conferences as they produce not as many slides and provide many real life demos. We exchanged our experiences on leading the user groups in Poland and Italy too.

I've decided to move my technical blog to http://zine.net.pl/blogs/sqlgeek/default.aspx. SQLGEEK is the codename of my new blog. Spaces.live will remain my blog on PLSSUG and non-technical stuff. Two blogs? Why not! Oh, and one more thing, SQLGEEK is going to be written in Polish.

Several days ago I joined a program called "Friend of Red Gate". This is a community related program founded by Red Gate Software. By becoming a member of the program you get full NFR licence for every single Red Gate product and also you get one year free upgrade opportunities. This is really good idea by Red Gate.

One of the first applications I have looked into is SQL Prompt 3 (3.6.0 prcisely). This powerful tool adds intellisense and code snippets to QA and/or SSMS (also SSMS Express) and/or VS2005. I must say Red Gate has made a big step forward with this tool. Last time when I tried previous version SQL Prompt against my database (over 80k objects) the tool failed. This version performs much better. 

After about 5-10 minutes of collecting my database metadata (meanwhile I could work with SSMS with no noticeable performance issues) it created its own file with the snapshot of the object list. When I started SSMS again the list was taken from the file and the differences only were loaded so I had object names intellisensed immediately.

The second thing is that Red Gate's tool supports JOINs as I always wanted it to support. Just write your tables and the tool will give you a list of potential joining conditions. Moreover, you can set the options how the tool will guess the joining conditions (data types, column names, foreign key parts).

The other features I like in SQL Prompt are: keywords uppercasing, ability to add custom code snippets, setting connections to ignore, star wildcard expanding.

Generally speaking - this version of the tool seems to be much better than the prevoius one. It works quicker, offers more options, has more intelligence and more sense than before. If you really need intellisense in SSMS or QA then SQL Prompt is what you can try! 

Below is a little screenshot of SQL Prompt in action.

More about SQL Prompt on www.red-gate.com

Polish SQL Server User Group is still growing! It has over 60 members registered. And this week two companies - Red Gate Software and Bonair S.A.. - joined the "firends of PLSSUG" list. We hope that with their help our group will have more power to create really strong, countrywide community.

Visit PLSSUG website

Yesterday I got a new book from MS Press - "Inside Microsoft SQL Server 2005 Query Tuning and Optimization" edited by Kalen Delaney (written by Kalen and well known SQL guys: Adam Machanic, Ron Talmage, Lubor Kollar, Sunil Agarwal and Craig Freedman). The very first look tells me that this is going to be a fascinating book. I am going to read the book ASAP and let you know if it is really as good as I suppose.

At last! IT Forum calendar is available. I could sit down and choose the sessions suitable for me. And my draft calendar looks like below.

Monday, 12 November 2007

DAT201 - An Overview of the Next Release of Microsoft SQL Server (Francois Ajenstat)
DAT202 - Introducing SQL Server 2008 Resource Governor (Boris Baryshnikov)

Tuesday, 13 November 2007

DAT03-ILL - SQL Server Always On Technologies Instructor-Led Lab: Part 1 - Database Mirroring (Kimberly Tripp, Paul S. Randal)
DAT307 - SQL Performance Query Tips and Techniques (Bob Beauchemin)
DAT305 - Secrets to Fast Detection and Recovery from Database Corruptions (Paul S. Randal)
SPN206 - Microsoft SQL Server 2005: Server and Storage Performance (Jerome Mas, Christophe Dubois)
DAT04-ILL - SQL Server Always On Technologies Instructor-Led Lab: Part 2 - Database Snapshots (Kimberly Tripp, Paul S. Randal)

Wednesday, 14 November 2007

DAT04-IS - New T-SQL Programmability Features in Microsoft SQL Server 2008 (Bob Beauchemin)
DAT206 - Microsoft SQL Server 2005 Security Best Practices (Al Comeau)
DAT309 - Predictive Analysis for Everyone with SQL Server and Office (Donald Farmer)
DAT310 - SQL Server 2008 – Enhancement for the Relational Data Warehouse (Steffen Krause)
DAT01-IS - SQL Server Upgrade Best Practices, Tips, and Tricks (Kimberly Tripp, Paul S. Randal)

Thursday, 15 November 2007

DAT05-ILL - SQL Server Always On Technologies Instructor-Led Lab: Part 3 - Online Operations (Kimberly Tripp, Paul S. Randal)
DAT07-IS - DBCC Internals (Paul S. Randal)
DAT301 - SQL Server Indexing - Unraveling the Unknown (Kimberly Tripp)
DAT02-IS - SQL Server 2005 Database Mirroring: Setup to Implementation to Monitoring (Kimberly Tripp, Paul S. Randal)
SEC313 - Dive Deeper Inside Windows Server 2008 Security – Keeping the Bad Guys Out! (Andy Malone)

Friday, 16 November 2007

DAT205 - The Next Release of Microsoft SQL Server: Manageability Overview (Kimberly Tripp)
MGT324 - How We Built the TechEd IT Forum Infrastructure
DAT304 - Scale-up or Scale-out Microsot SQL Server (Marco Manuello)
DAT401 - Dude, Where Is My Memory? Understanding SQL Server Memory Usage And Management (Maciej Pilecki)

As this is only a draft the calendar above can change. I think I will look for some sessions of Rafal Lukawiecki and I will probably visit hands-on labs. But as you can see IT Forum is full of SQL Server content (dominated by "SQL marriage" - Kimberly Tripp and Paul S. Randal - congratulations, wonder if you talk about SQL at home ;-)). Barcelona, I am ready to go!