Archive
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.
Abstract:
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.
Presentation:
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: http://www.sqlpass.org/24hours/2010/
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 (www.idera.com) and Tony Finnemore from SQL Tools (www.sqltools.com.au).
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.
News:
Presentation:
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: http://www.microsoft.com/Presspass/press/2010/apr10/SQL08RTMPR.mspx
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 (www.idera.com) and Tony Finnemore from SQL Tools (www.sqltools.com.au).
Hope to see you at Tech Ed next week.
The content from the meeting is posted below.
News:
Presentation:
Free Mini Notebok for Tech·Ed Australia 2009 Attendees
Microsoft Tech·Ed Australia Attendees to Receive Free HP Mini Notebook with Windows 7
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.
Metrics
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 http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx
Thank You,
The SSDS Team
Windows Live OpenID Support
Windows Live ID Committed to OpenID
From PDC 2008:
Beginning today, Windows Live ID is publicly committing to support the OpenID digital identity framework with the announcement of the public availability of a Community Technology Preview (CTP) of the Windows Live ID OpenID Provider. You will soon be able to use your Windows Live ID account to sign in to any OpenID Web site!
You will soon be able to use your Windows Live ID account to sign in to any OpenID Web site!
The Windows Live ID OpenID Provider (OP) enables anyone with a Windows Live ID account to set up an OpenID alias and to use that alias for identification at an increasing number of OpenID 2.0 relying party sites.
Windows Server 2008 Unauthenticated
Windows Server 2008 Unauthenticated Edition
As part of a IIS / SQL Server hosting project I was perplexed when "Windows Unauthenticated Edition" came up in a discussion. I had certainly never heard of it. Neither did had anyone else. Neither had Microsoft Australia. 
Windows WebServer 2008
Windows Server 2008 Unauthenticated
Windows Server 2008 Standard
Windows Server 2008 Enterprise
Windows Server 2008 Datacenter
The differences between the more "common" editions would seem to be:
| Feature |
Web |
Unauthenticated |
Standard |
Enterprise |
| Maximum RAM (32-bit) |
4 GB |
64 GB |
4 GB |
64 GB |
|
Maximum RAM (64-bit) |
32 GB |
2 TB |
32 GB |
2 TB |
|
Network Access Connections (RRAS) |
0 |
Unlimited |
250 |
Unlimited |
|
Network Access Connections (IAS) |
0 |
Unlimited |
50 |
Unlimited |
|
Terminal Services Gateway |
0 |
Unlimited |
250 |
Unlimited |
|
Remote Desktop Admin Connections |
2 |
2 |
2 |
2 |
|
Can run Active Directory |
No |
No |
Yes |
Yes |
|
Internet Information Service 7.0 |
Yes |
Yes |
Yes |
Yes |
|
SQL Server Express or better |
Yes |
Yes |
Yes |
Yes |
|
SQL Server Workgroup or better |
No |
Yes |
Yes |
Yes |
|
Hyper-V |
No |
No |
No |
No |
|
Network Access Protection |
No |
Yes |
Yes |
Yes |
|
AD Rights management Services(i) (RMS) |
No |
No |
Yes |
Yes |
|
Terminal Services Gateway & RemoteApp(ii) |
No |
No |
Yes |
Yes |
|
Server Manager |
No |
Yes |
Yes |
Yes |
|
Windows Deployment Services |
No |
No |
Yes |
Yes |
|
Server Core |
Yes |
Yes |
Yes |
Yes |
|
Windows Powershell |
Yes |
Yes |
Yes |
Yes |
Firefox 3.0 Release Date
FireFox 3.0 Download Day
Finally… Mozilla Firefox 3 will be released on Tuesday 17th June, 2008.
Firefox will be able to be downloaded next Tuesday as part of Firefox Download Day when, "hopefully", millions of users will attempt to set the Guinness World Record for the most software downloads in 24 hours.
You can pledge to download Firefox 3 on the 17th June at http://www.spreadfirefox.com/worldrecord/.
Victor Isakov 