Archive for the ‘Uncategorized’ Category

SQL PASS Summit 2010

BID323 – What Every DBA Should Know About SharePoint 2010

Thank you very much for those who attended my session, and the extremely positive feedback.

As I indicated at the beginning of the session, I included almost 90 slides in my slide deck so that you could use them as a reference sheet for SharePoint 2010 projects. (I actually chopped out about 10, as I thought over 100 slides in a 75 minute session would be ridiculous.)

Again, apologies due to the change in the date and time slot. As I said before the session started, I had problems with travel due to an unfortunate incident with an airline, and the subsequent backlog of stranded travellers it created.

As I said at the end of my session, I would like to gather some metrics and statistics of how SharePoint 2010 works with SQL Server out in the field. I would then provide the information back to the community, so that we can all benefit. If you would like to volunteer your SharePoint 2010 solutions, please contact me.


Sharepoint is becoming more ubiquitous in both the enterprise and SME market as a core business application. With Sharepoint 2010 Microsoft has re-engineered Sharepoint 2010 so as to leverage SQL Server 2008 R2’s capabilities. Consequently it is more important than ever for DBAs to be cognisant of SharePoint’s architecture and how to best provision, configure and manage the SQL Server infrastructure for Sharepoint. In this session Victor Isakov (MCT, MCM, MCA) will present the Sharepoint 2010 architecture and considerations that every DBA should know, including capacity planning, performance management, configuration, disaster recovery and high availability.


Categories: Uncategorized

Free Virtual SQL Server Summit (19-20 May, 2010)

24 Hours of PASS: Celebrating SQL Server 2008 R2

In case you haven’t heard, the “countdown is on to the most value-packed 24 hours of SQL Server and business intelligence (BI) training available. Don’t miss out on the 24 free, back-to-back webcasts that make up the 24 Hours of PASS: Celebrating SQL Server 2008 R2 virtual event, May 19-20:

Join Us for 24 Hours of FREE, Nonstop Training (with a special focus on SQL Server 2008 R2)

The countdown is on to the most value-packed 24 hours of SQL Server and business intelligence (BI) training available – and it’s absolutely FREE!   


24 Hours of PASS is bringing an exceptional lineup of SQL Server and BI experts from around the world to your computer in 24 back-to-back webcasts starting at 12:00 GMT (UTC) on May 19.

Get an in-depth look at the hottest SQL Server and BI topics, including – as part of the SQL Server 2008 R2 Community Launch –  the new SQL Server 2008 R2, including business intelligence and data management innovations, and much more. Register today.

The roster of phenomenal speakers features many MVPs and PASS European Conference 2010 presenters, including Donald Farmer, Thomas Grohser, Brad McGehee, Rushabh Mehta, and Jacob Sebastian.

The 24 Hours of PASS sessions will be recorded and made available at a future date (within two months of the event) for online streaming.


More information:

Categories: Uncategorized

Sydney SQL Server Enterprise User Group – March 2010

DBD: Ensuring Optimal Performance in SQL Server 2008 Based Applications

Congratulations to Igor Fiodoroff for winning the major door prize, a license of the Idera SQL Admin Toolset (valued at AU $954) that was generously provided by Idera ( and Tony Finnemore from SQL Tools (

For April we’re going to have a session on SQL Server partitioning. It’ a technology that is still not commonly being used in the field, and there are plenty of questions about how it works, whether you will improve performance, how best to implement/manage partitioning and so on. The session will go through such questions and provide answers.

The content from this month’s meeting is posted below.



Categories: Uncategorized

SQL Server 2008 R2 RTM

SQL Server 2008 R2 Has Been Released To Manufacture

In case you haven’t heard, SQL Server 2008 R2 has RTM’ed, as expected close on the heels of Office 2010, SharePoint 2010 and Visual Studio 2010.

So that just leaves ADFS 2.0. Expect it to RTM soon!

More Information:

Categories: Uncategorized

Sydney SQL Server Enterprise User Group – September 2009

DBD: Analyzing SQL Server Query Plans

Thank you to all of you who attended September’s session on query plans.

Congratulations to Danielle for winning the major door prize, a license of the Idera SQL Admin Toolset (valued at AU $954) that was generously provided by Idera ( and Tony Finnemore from SQL Tools (

Hope to see you at Tech Ed next week.

The content from the meeting is posted below.



Categories: Uncategorized

Free Mini Notebok for Tech·Ed Australia 2009 Attendees

Microsoft Tech·Ed Australia Attendees to Receive Free HP Mini Notebook with Windows 7

Microsoft will be giving away a free HP Mini 2140 Notebook with Windows 7 to most Microsoft Tech·Ed Australia 2009 attendees. (Windows 7 should be in RTM then. Don’t forget that is is slated for release on the 22nd October 2009.)
There are certain criteria for who will be eligible.
There will be an option to give your notebook to the community sector through Microsoft’s local On My Way initiative.
Categories: Uncategorized

SQL Data Services Update

SQL Data Service Update at PDC 2008

From PDC 2008:

SQL Data Services (SDS) Update

This morning, we announced, the latest upgrade of SSDS at the PDC2008 conference in Los Angeles. We have also changed the name of the service from SSDS to SDS (SQL Data Services). In order to support this announcement, the documentation on our DevCenter has been updated to cover the new features in this upgrade.

Key members of our team are at the PDC. We hope to be able to meet with many of you who are attending this event. Please come to our talks, stop by our booth, and say "Hello" to us in the services lounge.

The SDS upgrade announced at the PDC will be made available to you in early November and broadly available as a public CTP (Community Technology Preview) in mid-November.

New features announced today:

Additional Query Support

a) Joins

Join query support in SQL Data Services (SDS) allow you to retrieve entities from a container based on a join condition involving properties on different kinds of entities. For example, if you have a container with customer and order entities, a query to find orders for a given a customer would require you join the customer and order entities based on a common property. Since both the customers and orders are in the same container, you query the same container twice (using aliases); first find the customer and then find orders for that customer using a join condition.

b) OfKind

To simplify the join Syntax, SQL Data Services (SDS) has introduced an OfKind function. This function can specified on the queries From clause to distinguish between multiple Kinds within a container.

An example would be

from c in entities.OfKind("Customer") select c

c) Order By

SQL Data Services (SDS) now supports an Order By clause in our query syntax. This optional clause allows you to have your query results returned order by the property of your choosing in either ascending or descending order

d) Take

SQL Data Services (SDS) now supports a Take function in its query language. This new function can be used to restrict the number of entities returned in a given query.

.Net Access Control Integration (SOAP Only)

The .NET Access Control Service is a hosted, secure, standards-based infrastructure for multi-party, federated authentication and rules-driven, claims-based authorization. SQL Data Services (SDS) supports authentication and authorization via tokens issued by the .NET Access Control Service. This allows applications secure not only their own web service layer, but also their SDS-based data layer using the same, declarative access control mechanism.

Other forms of credentials, besides username/password, can be used to obtain a token from the identify provider. They are:

a) X.509 certificate

b) InfoCard

In this release, using token-based authentication scheme with SDS has the following limitations:

a) When communicating with SDS, the token-based security is available only when using the SOAP protocol. For applications using the REST protocol, only the basic authentication is supported (username/password).

b) Requires a .NET Services solution account.


Service users often want to know the usage pattern of the service. Microsoft® SQL Data Services (SDS) user may want to find:

a) How many containers or entities do I have?

b) What is the total storage consumed by an authority or a container?

c) What is the amount storage used by blobs in a container?

d) What is the aggregate number of requests (GET, POST, PUT and so on) sent against an authority or a container?

e) What is the number of request and response bytes sent with a specific authority or container in scope?

The service provides this information as properties on authorities and containers.

User Limits during the public CTP (this will change, when we go "Live")

a) Each user will be allowed 50gb of storage across all Authorities

b) 1000 Containers per Authority

c) 1gb of Blob Entities per Container (up from 500mb)

d) 100mb of Flexible Entities per Container (up from 20mb)

e) Each Blob Entity will be capped at 100mb

For more detail, please visit SDS DevCenter at

Thank You,

The SSDS Team

Categories: Uncategorized