Data Mining with SQL Server 2005 and 2008

Well this is a surprise one! The original session I had planned on BI has been canned and this put in place! This has been happening a fair bit this week and a few of the BI/Analysis Services ones have been cancelled very last minute! Ah well on with the show!

Wow apparently Data Mining is the exact opposite of cryptography! Legal Hacking!!!!

Oh yeh its Rafal again so more Microsoft failures may be posted!

Not only for Business Intelligence but mining can be used for database logs and server logs to explore the hidden answers that exist within any data.

For those who dont know what Data Mining is....

• 
  
  Technologies for analysis of data and discovery of (very) hidden patterns.
  
• 
  
  Uses a combination of statistics, probability analysis and database technologies
• 
  Fairly young (<20>

And this is what it does...

Explores your data --------> Finds Patterns--------> Performs Predictions

OLAP and Data Mining is PREDICTIVE ANALYSIS!

We can apparently even use Data Mining to correct and improve the ETL Process for the Datawarehouse! It works out if things are missing! Surely this is the best thing since sliced bread!

Sorry Im running out of photos now.

Create Mining Model (Sytanx)

CREATE MINING MODEL MyModel

(

[CustID] Text KEY,

[Gender] Text DISCRETE,

...

[Home Ownership] TEXT DISCRETE PREDICT,

...

) USING Microsoft_Decision_Trees

PREDICT is what you want the Mining Model to predict. You can PREDICT Multiple items.

A demonstration followed showing the steps involved with creating a Mining Model and starting to drill!

Next Generation Networking in Windows Server 2008

An excellent talk by Rafal Lukawiecki who surprise, surprise doesn't work for Microsoft so his view was completely unbiased! He pointed out some serious issues with the Networking stack in Vista as a starting note and continued on to some of the excellent new features in Server 2008.

There have been some improvements in the way IPSec is managed in 2008 as apposed to how it is currently done in 2000/2003. I won't bore everybody with the details here.

He also showed us how IPv6 has been implemented within Server 2008 which brought memories of Computer Science 2nd Year lectures come flooding back to me!

NG TCP/IP (Next Gen) also has some really cool features that allow bandwidth on a network to be throttled down to the level of individual applications. This would allow multiple applications to reside on one server and to be able to customise how to share out the available bandwidth between these. Obviously this may not be something that we worry about at the moment but as more and more applications are introduced within the institution this may be a handy feature!

SQL Server Integration Services (SSIS) : Zero to Hero

This was an excellent talk on Integration Servcies for SQL 2005/2008. Integration Services is the new DTS and should be easier and quicker to use.



The Business Intelligence Development Studio





SSIS solutions are designed within part of the BI Dev Studio which is a variation of Visual Studio. The graphical approach used for DTS has been brought to SSIS but has a more Visual Studio drag and drop approach where you can just drag a connection from the toolbox into your SSIS Project.





Components of SSIS

• Control Flow - Specifies the logical flow of a package, defines the steps in a package and defines precedence amongst steps.


• Control Flow Maintenance Plan Tasks - Behind the scenes of Database Maintenance Plans.


• Control Flow Tasks (eek thats smaller than I was expecting)
• Control Flow Containers - Loops through datasets/file systems and links items and tasks together in sequences.
• Data Flow Items - Defines how data flows from source to destination and defines transformations.
• Data Flow Sources - Defines the source of data.
• Connection Manager - Defines source, destination and auxillary connections.

Converting DTS 2000 to SSIS 2005

There is a SQL Updgrade Advisor for this process and the biggest problems seem to be with encapsulation.

Execution of Packages

SSIS packages can be executed from:-

• Execution from within BIDS
• Execution using DTEXECUI
• Execution using DTEXEC
• Execution using SQL Server Agent Jobs

Each of these have advantages/disadvantages over one another. One big advantage I can see of execution through BIDS (Business Intelligence Dev Studio) is the ability to Debug your SSIS projects. This is new and should be really useful when designing and testing your SSIS projects.

DTS is dead long live SSIS apparently...

Windows Vista Service Pack 1

This as expected was a very busy session. No seats were remaining so I had to sit on the floor at the back.

(It's amazing how an application crashing and burning can attract so many numbers!!!!!!!!!!!!)

From past experience in Vista I know how terrible the newly written audio stack and the awful driver support which leaves you with blue screens which frustrate the everyday user can be.

SP1 therefore is of coure the solution............

Noooooo...

Instead Microsoft seem to have focused on improving the speed of unzipping a zipped folder to the desktop. Awww bless. If only I had the courage to stand up and say "Yeh but WinRAR is still quicker and it needs sooooooo much less resources than the out of the box solution.

And think of all the time they have spent on this!!!! They probably forgot about the fact that if people with a Medley Serial ATA 133 RAID PCI adaptor upgrade their driver through the Windows Update Service as reccomended by the speaker in the presentation they can say goodbye to their pc forever. (This is true, I've tested it!)

In my opinion Vista was never ready to RTM (Release To Manufacturer) and it still is not! SP1 focuses on some performance increases that already existed in Windows XP but does not fix the critical errors that have been made with Vista.

TBH I don't believe Vista will be ready for a long time! Yes it looks cool and it's got some see-through stuff but so does Leopard OS-X and that doesnt let you down when you try play an MP3. Maybe when we get to about SP4 it will be useable.

This is a bit of a dissapointer for me and maybe this is why I have posted it last thing but I don't see a lot of encouragement to upgrade to Vista. The specs of machines Microsoft are saying are minimum specs are 800mhz with 512mb or ram. This may sound like just some figures but when entire Microsoft projects are based on these statistics which in my opinion (I have tried Vista on 512mb laptop which was fine until I wanted to do something) are wrong, they need to have a rethink. I don't think there is anything wrong with saying PC's should have at least 1gb of ram but pretending that Vista will work with less is being cruel!

I think I'm whinging so....

Server 2008 however is another story!!!!

Now that's a product we can really use to improve our Microsoft Based Servers.

UK Education Special

Software As A Service

Live @ Edu (Email For Life?)
Logging into Microsoft Live Services with CardSpace. Students are given an email address which can be branded as lancs.ac.uk.... But it isn't hosted by Lancaster's servers. One advantage of this is the whole "email for life" idea is taken out of our hands and Microsoft looks after it! So the Alumni department would not lose track of the students once they leave the University.

Office Live Workspace
Paid for via ads but the ads will only appear when the users searches using "Live Search". This can be thought of as SharePoint Lite or (SharePoint for Students). It acts as a) a place for students to organise events with each other, b) a place for students to share documents when working on projects together etc.. I am not sure on its integration with SharePoint but I must admit it looks very similar! It would be nice if it had the ability for lecturers who keep their slides in SharePoint to push these down to a lecture/seminar group via Office Live Workspaces but this unfortunately was not demoed if it is even possible! It was advertised though as not the "Best Student Experience" but as the "Cheapest to implement"! Remembering that this is a free service it involved some nice ideas especially with the addition of CardSpace to log in to the service. This means you don't actually have to enter a username and password at all if you have your card with you!

It was a very odd way of advertising things but as a very recently graduated student I must admit the idea of being able to have Hotmail type facilities supported by the university is a good idea! Maybe this is why WING was such a let DISASTER!!!!!

Well in true student fashion after obtaining a reliable source of red wine and discussing the finer points of "terroir" with a certain French Man, the following picture (Wey hey a piccy at last!) shows the the UK Party at a place called Opium!

This involved very little speaking but a lot of eating small nibbles and several bottles of red wine! "Terroir" eat ur heart out!

For anyone who is thinking, "My god what the hell is this guy on about!" Terroir is a French word of which there is no direct translation. It is in fact a combination of where the grapes are grown, what conditions they were grown in and what Mother earth has given to the wine.

Wow I wasnt actually just drinking beer! How sophisticated!

This ended at 9:20 which was a bit too early so a night cap of strong lager of course had to follow!

Oh yeh I forgot about the last session!

Deploying Windows Server Update Services 3.0

We are now running WSUS 3.0 within CIS but thought this talk would give me a better overall knowledge of the way Microsoft deploy and use WSUS 3.0 to get the best potential from it. One of the main differences from WSUS 2.0 is the loss of its web based interface for a MMC Snap In which seems to be the way Microsoft wants to go for future server management applications.

WSUS
Provide a simple, low cost, solution for distributing Microsoft Updates within a corporation. Does not natively allow updates from 3rd party software to be pushed out through WSUS but there are ways round it to allow this to happen.

WSUS 3.0 Features

• Initial configuration wizard
• MMC-Based UI, with advanced filtering and sorting
• Email notification of new updated (and/or compliance summary)
• Multiple, more granular, auto-approval rules
• Integrated reporting rollup
• Cleanup Wizard
• Native x64 support
• Vista BITS peer-caching
• Scalability Improvements
• Access to more content - import from the MU catalogue site
• MOM Pack
• Improved logging and audit logging
• NLB and SQL clustering
• Read-only administrative role (WSUS reporters)
• Enhanced targeting
• Upgrade to SCE or Configuration Manager 2007
• A single machine can be added to more than one group.
• Ability to have more than one WSUS Server and manage them all from the same MMC
• Snap-In.
• Lost support for SQL 2000!!!!
• Can manage Windows Server 2008.
  

Guidance For Running WSUS 3.0

• Always ensure WSUS sits behind a firewall.
• Always use SSL
• Windows Internal Database recommended as it does not require a SQL CAL and gives you good performance without an install of SQL 2005.
• Only use Network Load Balancing for WSUS 3.0 if it is required as it is easy to just rebuild a failed WSUS server.
• Cleanup wizard should be used fairly frequently to remove superseded updates and archived updates from more than 12 months ago.
• Any SQL Server 2000 Databases need to be Upgraded to 2005 as these servers will not currently be receiving any updates for SQL 2000.
• Use the WSUSUtil checkhealth option to ensure finished deployment is working correctly.
• The Windows Update log file gives a very verbose audit trail of what has occurred on the WSUS server and from the WSUS server and connected clients.

Service Pack 1 Release

• Added support for Windows Server 2008 release.
• Better support for Partner Products.
• Integration with Server Manager.
• Computer Detailed Status reports to Excel now works!
• Bulk approval of updates now does not overwrite existing approvals.
• Additional APIs added to support Mobile Devices and Richer publishing of drivers within the enterprise using vendor provided catalogues (e.g. Dell, HP, IBM etc...)
• Available at launch of Windows 2008 release.
• Seamless upgrade from RTM.
• Can later upgrade to System centre Essentials or configuration Manager 2007
  
  

New Software and Hardware Capabilities : Next steps in Business Intelligence and Data Warehousing

Well I had high expectations for this one as thought this would key in quite nicely with the ProClarity and Analysis Services stuff we are working on. Rachel and Andrew will back me up here I think when I say this was the biggest advertisement for AMD Processors thats ever been made under the title of BI!

All I can really say on this one is that we now know that AMD Quad Core CPUS are ace and Intel are just crap in comparison! This had nothing to do with BI at all but hey it's AMD!!!!!

I think I've been brainwashed!!! If you suddenly see a big increase in the number of servers in CIS and ICT Focus running AMD processors you can blame IT FORUM!

Really sorry but I don't think this Session improved my knowledge of BI at all!!!!

If u wanna know the advantages of Opteron Quad core on a socket F board tho, feel free to contact Rachel, Andrew or myself who will be able to help you out!


And no Picture! Sorry!

However I did find...

http://uk.youtube.com/watch?v=ZOzKtMtAlHo

You can almost hear the screams from Chris Dixon!

Living the Longhorn Life: What's up with Windows Server 2008

The Guy that ran this session was an absolute comedy genius! Apart from the vision of him suddenly bursting out with "Praise be to Jesus!!!!", "Praise be to God!!!" in a Little Britain Styley, he managed to keep the audience entertained for 1 hour 45 minutes and still managed to present some very neat features of Windows 2008 Server. The entire talk was based on the Longhorn idea and why its a good/bad idea to name an operating system after a COW! (He didnt actually work for Microsoft so I guess he could get away with more).

Stuff I picked up on...

Windows 2008 Server line-up confirmed ship date of 27th February.
WinRM is replacing RPC.
Reliability Monitor introduced
(Front end to event viewer and gives you a score for previous month). You can use this to determine when a system started to mess up and you can restore to before that point in time. Also can be used to measure up time and performance statistics over time.

Server Manager Introduced
Part of the "Vista/2008 Admin Games Pack". Apparently because the stuff you used to know how to do will now cause you to play games with the server until you find out where its now gone to and how to do it.

MOM Microsoft Operations Manager
Replacement to performance manager which looks similar to spotlight for windows.
Self generating Registry key policies for group policy
Multicast Windows Image Files (*.wim) files to desktop workstations.

Hypervisor (Arrives ~ six months post-Longhorn)
Option for Longhorn and Server Core. Similar notion to VMWare ESX, Built to exploit AMD Pacifica/V and Intel Vanderpool//VT's new op-codes. Ends up without Live Migration so no VMotion type capabilities!!!! Possibility of adding at a later date "Apparently".


Network Access Protection (NAP)
Allows pc's entering a domain to be quarantined until it is deemed healthy enough to be connected to the domain/network.
Policies can be set up to say for e.g. "no XP box gets on the network unless it's got SP2 and patches X, Y and Z.

SMB 2.0 offers (Server Message Block) Vista -> 2008 transfers only.
Larger dynamic block sizing - Significantly better file transfer speed. More robust, handles short network glitches better. Apparently 2.5x - 3.0x quicker.

IIS 7.0
No more metabase; sites are configured with an ASCII text XML file called ApplicationHost.config. Very nice and much simpler to pair a site down to its basics, which makes for faster code and more security.

Terminal Services Gets Better
SSL connections , runs on RPC over HTTP.
TS Gateway lets you get past firewalls. Remote execution of an application which looks like it is being run locally.

A SQL Server In Every Box
Longhorn implements "Windows Internal Databases" which means that out of the box Longhorn will have Database functionality like SQL Server 2005. It's basically SQL Server 2005 Express.

DNS Changes
DNAME functionality allows old.com to effectively redirect to new.com.

Server Core
"I want a server OS without the GUI!" I.e. Linux! Server core doesnt quite get there but it is a reduced-function version of Server. This should improve performance for servers running under Server Core. Stops .NET, MMC, IE. This means VM Servers can get away with less RAM. 200mb of RAM suddenly becomes enough! Server Core servers don't need the patches a full blown GUI/Service rich server needs so less WSUS updates need pushing out. Things that work:- Notepad, TaskMgr. TM's, Regedit, vbscript, DnsCMD, WevtUtil, and even edlin!?!?

There are some really cool features in all this which should allow us to...

a) Run servers requiring less memory and better still less patching (and therefore less restarts of servers on patch day)
b) Stop non authorised "Foreign" machines being given full access to the LANCS domain. This I believe has always been an issue for ISS and the quarrentine functionality within Longhorn is a very neat solution!

Sorry no Picture for this one!

Accelerating Desktop Hardware Readiness Assessments Using Windows Vista Hardware Assessment 2.1

Allows computers and peripherals to be analysed within a specific subnet on a network to deduce the action required to allow Vista to be easily rolled out across that Subnet. This allows printers to be picked up and a driver to found if required/available for the computers that use that/those printers. It will automatically generate a word report on the current view of how the hardware within the subnet will respond to the installation of Vista. May be useful within CIS if not Campus wide to track which desktop workstations need replacing not only for Vista but when keeping track of the 3 year life cycle of replacing machines.


MAPS tool (Microsoft Assessment and Planning Solution)
http://connect.microsoft.com
Code : MAPS-2YD8-DWXB

SQL Performance Query Tips and Techniques

This was a very useful talk on Optimization of SQL queries and how to discover where bottlenecks are within a database. Some of the things picked up that I have listed below may be of some help across CIS to improve the performance of queries. There are more optimizations in the slides which I will bring back.



Grouping Sets (SQL 2008)

Group by grouping sets (a, (b), (a,b,c))

Avoids having to use Unions:-

Group by a
union all
...
Group by b
Union all
...
Group by a,b

When to Optimize T-SQL Code

The users point out when to optimize
"SQL Server is running slowly"
Or proactive optimization

What's running slowly (SQL 2005)

Select * from sys.dm_os_wait_stats
Select * from sys.dm_exec_query_stats

Can help deduce where the bottlenecks are and the most frequent run statements. Also got shown how to use Database Tuning Advisor which can tune multiple databases at once. Can be run without taking the system down which will bring back a reduced set of recommendations how to increase the performance of a database. A further set of recommendations can be found by taking the database offline. You can also get the application to apply the recommendations you approve at a scheduled time/date possibly out of office hours.

Auto Parameterisation of Queries

This is bad! When constructing your queries e.g.
...
Where price = 17.99
SQL Server will guess the format of this number as Decimal(4,2)
Changing any part of the query (i.e. Where price = 7.99 or adding a --comment at top of query) will cause SQL to use a different query plan every time you change the query.

If you always specify the format of your where e.g.
...
Where price = £17.99
You are telling SQL Server that this value is MONEY. This will now always use the same query plan. It stops guessing the format of your parameter as you are telling it what it is!





And a picture for this morning...

View of the exhibition hall. Lots of free goodies to be found here!

Updated: Microsoft Office Excel and Analysis Services: An In-Depth Look at Integration

Session 2. After a quick coffee it was time to go and find out some more about the Excel Performance Point plugin, Excel services and how cubes can be queried from excel using MDX and Excel formulae. Another couple of points I picked up from this.

• Excel Services required MOSS Enterprise edition to run.
• It seems really slow. Yes it allows people who have been using Excel for years to start looking into Business Intelligence but it requires setting up what you want to slice by one line at a time. You also need to have a fairly good understanding of MDX which is a black art in itself! It took the speaker around 1/2 an hour (although he was talking us through it) to come up with a view of some data that I reckon could have been knocked together in ProClarity in a couple of seconds. (Maybe I'm missing the point?)
• Someone asked the question which I must admit had not crossed my mind about scalability. The speaker rolled out the usual "Microsoft Noddy Company's are us" cubes which consisted of about 20 products and 3 countries. He then used Excel to list all these in what is basically a Pivot Table. Now as many long time Excel users will realise it's not going to like attempting to show records of thousands/ten thousands of students. The speaker pointed out that Excel 2007 can now handle X Billion rows of data no problem. Im not entirely sure the older pc's still around campus running less than 1gb of ram are gonna agree with that.
• I did like the ability to start mixing and matching MDX and Excel Formulae from a developers point of view but am not 100% sure the every day ProClarity user would feel very happy with this.

I am collecting all the slides and information gained from these sessions so I'm not going to go into too much detail.

The night was rounded off with a joint trip out to a fish restaurant. This for some reason started a very odd conversation into why Chris Dixon finds it impossible to eat more than 1 fruit at the same time. So like apple and blackcurrent crumble is out of the equation but a crumble with just one fruit is perfectly acceptable! Not sure how this started and the look on Chris' face when his Fishermans Stew arrived was to be remembered forever!

Bed Time!!!!!

Performance Point 2007: Bringing value to the performance management process

Ok, onto session 1. This was basically a demo of Performance Point 2007 which could possibly see drastic changes on the Business Intelligence front.

He showed us how a scorecard should work along with a dashboard and demos of the Excel plugin and web based interface.

I picked a couple of things up from this one which were of interest.

Throughout the entire session I felt I was missing some functionality that ProClarity currently offers people wanting to analyse data. This was the ability to "slice" and "dice" by a particular dimension and look at changes over varying time. I asked the question...

"Our current users are familiar with the ability to quickly analyse data by slicing and dicing in proclarity, can this still be done in Performance Point 2007?"

The Microsoft answer....

"No but it should be coming in Version 2"

My follow up...

"When is Version 2 coming out?"

Microsoft Typical Answer...

"We don't know..."

I was slightly astonished by this lack of knowledge on the topic and realised straight away that Performance Point 2007 would not really be a comparable upgrade to ProClarity at least until version 2 is released.

Another interesting point is the lack of visualisations available within Performance Point 2007. We had just seen from the Key Note that Reporting Services 2008 offers some new visuals such as tachometer style dials which suddenly seemed to be missing from PP2007. So with PP2007 it looks like we are back to bar charts, line graphs and pie charts. HOW BORING! Well unless they were hiding all the good ones!?!?!?

For those not in the know with PP2007 here are some piccys of where we all went before the keynote started to keep you interested.

Amazing place!

Key Note

Well first up, the Key Note.....

This involved these....

Apart from these devices of torture we got introduced to the new family of Microsoft applications under the 2008 badging. This was a fairly good introduction to what they have lined up for the future in terms of Windows Server 2008, SQL Server 2008 and Microsoft's view on how virtualisation should work.

Oooooo pretty colours.

On to the real stuff...

We have landed!

Arrived Barcelona.... just.... We had some minor taxi issues and Rememberance Sunday is not the best day to travel.
Keynote is at 2:00 and then 2 sessions after that.


Will keep ya posted.

Proposed Schedule for the week

Monday, 12 November 2007

08:00 - 21:00
Registration Open

08:00 - 21:00
Self-Paced Hands-on Labs and CommsNet Open

11:30 - 13:30
Lunch

14:00 - 15:30
Keynote

15:30 - 16:00
Break

16:00 - 17:15
Session Slot 1

16:00 - 17:15
OFF208 - PerformancePoint Server 2007: Bringing Value to the Performance Management Process Remove
Stephen Rauch, Venky Renganathan
Export to PC

Room 121

17:15 - 17:45
Break

17:45 - 19:00
Session Slot 2

17:45 - 19:00
DAT202 - Introducing SQL Server 2008 Resource Governor Remove
Boris Baryshnikov
Export to PC

Room 113

19:00 - 21:00
Exhibition, Community Lounge, Ask The Experts Open

19:00 - 21:00
Welcome Reception

Tuesday, 13 November 2007
Updating...


08:00 - 19:00
Registration Open

08:00 - 18:30
CommsNet Open

08:00 - 18:15
Self-Paced Hands-on Labs Open

09:00 - 10:15
Session Slot 3

09:00 - 10:15
CLI12-IS - Internet Explorer 7 Security & Deployment Remove
Matt Heller
Export to PC

Room 134

10:00 - 15:30
Exhibition, Community Lounge, Ask The Experts Open

10:15 - 10:45
Break

10:45 - 12:00
Session Slot 4

10:45 - 12:00
DAT307 - SQL Performance Query Tips and Techniques Remove
Bob Beauchemin
Export to PC

Room 114

12:00 - 13:30
Lunch

12:15 - 13:00
Lunch Session Slot

12:15 - 13:00
SEC04-PD - How to Secure Your Network using Windows Server 2008 Technology! Remove
Marcus Murray, Hasain Alshakarti
Export to PC

Room 117

13:30 - 14:45
Session Slot 5

13:30 - 14:45
DAT03-IS - Spatial Support in Microsoft SQL Server Remove
Bob Beauchemin
Export to PC

Room 132

14:45 - 15:15
Break

15:15 - 16:30
Session Slot 6

16:30 - 17:00
Break

17:00 - 18:15
Session Slot 7

17:00 - 18:15
DAT207 - SQL Server 2005 Security and Innovations in SQL Server 2008 Security Remove
Al Comeau
Export to PC

Room 113

Wednesday, 14 November 2007
Updating...


08:00 - 19:00
Registration Open

08:00 - 19:00
CommsNet Open

08:00 - 18:45
Self-Paced Hands-on Labs Open

09:00 - 10:15
Session Slot 8

09:00 - 10:15
DAT04-IS - New T-SQL Programmability Features in Microsoft SQL Server 2008 Remove
Bob Beauchemin
Export to PC

Room 130

10:00 - 16:00
Exhibition, Community Lounge, Ask The Experts Open

10:15 - 10:45
Break

10:45 - 12:00
Session Slot 9

10:45 - 12:00
MGT303 - Deploying Microsoft Windows Server Update Services 3.0 Remove
Joseph Dadzie
Export to PC

Room 116

12:00 - 13:30
Lunch

12:15 - 13:00
Lunch Session Slot

13:30 - 14:45
Session Slot 10

14:45 - 15:45
Break and Expo

15:45 - 17:00
Session Slot 11

15:45 - 17:00
DAT310 - SQL Server 2008 – Enhancement for the Relational Data Warehouse Remove
Steffen Krause
Export to PC

Room 116

17:00 - 17:30
Break

17:30 - 18:45
Session Slot 12

17:30 - 18:45
DAT01-ILL - Advanced Analytics in Excel with the Microsoft SQL Server 2005 Data Mining Add-ins Remove
Donald Farmer
Export to PC

Room 119

19:45 - 00:00
Country Drinks (times subject to country specifies)

Thursday, 15 November 2007
Updating...


08:00 - 19:00
Registration Open

08:00 - 19:00
CommsNet Open

08:00 - 18:45
Self-Paced Hands-on Labs Open

09:00 - 10:15
Session Slot 13

09:00 - 10:15
DAT308 - SQL Server Integration Services (SSIS): Zero to Hero Remove
Dandy Weyn
Export to PC

Room 115

10:00 - 16:00
Exhibition, Community Lounge, Ask The Experts Open

10:15 - 10:45
Break

10:45 - 12:00
Session Slot 14

10:45 - 12:00
DAT07-IS - DBCC Internals Remove
Paul S. Randal
Export to PC

Room 131

12:00 - 13:30
Lunch

12:15 - 13:00
Lunch Session Slot

13:30 - 14:45
Session Slot 15

13:30 - 14:45
DAT02-ILL - Building Predictive Key Peformance Indicators (KPIs) and Scorecards with Microsoft SQL Server 2005 Data Mining Remove
Donald Farmer
Export to PC

Room 119

14:45 - 15:45
Break and Expo

15:45 - 17:00
Session Slot 16

17:00 - 17:30
Break

17:30 - 18:45
Session Slot 17

17:30 - 18:45
SEC313 - Dive Deeper Inside Windows Server 2008 Security – Keeping the Bad Guys Out! Remove
Andy Malone
Export to PC

Room 112

Friday, 16 November 2007
Updating...


08:00 - 17:00
Registration Open

08:00 - 16:30
Self-Paced Hands-on Labs and CommsNet Open

09:00 - 10:15
Session Slot 18

10:00 - 14:00
Exhibition, Community Lounge, Ask The Experts Open

10:15 - 10:45
Break

10:45 - 12:00
Session Slot 19

12:00 - 13:30
Lunch

12:15 - 13:00
Lunch Session Slot

12:15 - 13:00
DAT03-PD - Predictive Business Intelligence with Microsoft SQL Server Remove
Donald Farmer
Export to PC

Room 113

13:30 - 14:45
Session Slot 20

14:45 - 15:15
Break

15:15 - 16:30
Session Slot 21

15:15 - 16:30
DAT401 - Dude, Where Is My Memory? Understanding SQL Server Memory Usage And Management Remove
Maciej Pilecki
Export to PC

TechEd IT Forum 2007 Barcelona

This year I have been invited to attend the Microsoft TechEd IT Forum in Barcelona. The event runs for a week from the 12th-16th Nov.