Other SQL Server Blogs around the Web

SQL Server Management Studio (SSMS) plays important role to connect/manage the database estate without having difficulty, also there are few goodies (hidden gems) that you can simply enable on your Management Studio that will make your day-to-day usage life much better! Going on the topic of accelerator BOL defines clearly that it allows you to select a menu command or button by pressing ALT+<single letter> . For instance once you have opened SSMS to goto Edit menu, press ALT+E . Similarly...(read more)

Here is your chance to see a preview of "SQL Server 2008 Reporting Services Scalability and Performance" in this time schedule of Scottish Area SQL Server User Group: Register for Event LiveMeeting Attendee URL Click here to join Meeting Time Starts (UK time) at 18:00 , Finishes 21:00 Cost Free Organiser UK SQL Server User Group Address Microsoft Edinburgh, Waverley Gate, 2-4 Waterloo Place, Edinburgh, EH1 3EG Directions to Event Tags SSRS, Scalability, Performance Scottish Area SQL Server User Group...(read more)

16 th April 2010 Church House Conference Centre, London Registration is Now Open We are pleased to announce SQLBits - The 6th Sets our latest, and if we may be so bold, our greatest event yet. On Friday 16 th April we will be hosting SQL Bits VI at the Church House Conference Centre in Westminster, London. This will be a free event. For SQLBits VI the theme is performance and scalability, anything and everything that you can think on that theme. If you are interested in sponsoring SQLBits please...(read more)

The fifth annual Microsoft Architect Insight Conference builds once again on the success of previous years with another line-up of compelling guest speakers ready to share their opinions. The theme of this year’s event will focus on how successful architecture is rapidly becoming a key business differentiator both for today’s architect, and for tomorrow’s. This time round we are moving back to a full two-day, three-track format, with the added flexibility for architects to attend one or both days....(read more)

In the recent times Microsoft Release Services adopted the 935897 Incremental Servicing Model (ISM) for SQL Server team to deliver hotfixes for reported problems, also the new 822499 naming schema for Microsoft SQL Server software update packages. In this regard here is the 10th instalment of Cumulative Update package for SQL Server 2008, so when you apply the fixes the build of the cumulative update package is also known as build 10.00.1835.00. A note of caution on backout plan if there is any problem...(read more)

At the first instance the error is clear that some problem with SQL resource that was allocated to the Cluster resource. Just a background on SQL Server Failover Clustering, that the server cluster consists of a failover cluster instance that runs under Cluster Services (MSCS). The instance of SQL Server might be hosted by Microsoft MSCS-based nodes that provide the Microsoft Server Cluster, say if problems exist on the nodes that host the server cluster, those problems may manifest themselves as...(read more)

BI - Business Intelligence has become an integral part of data platform since Microsoft revealed the features from SQL Server 2005 version onwards. As per this strategy of Microsoft comprises a suite of server and client-side data integration tools, not to mention about useful, analytical and reporting tools in SQL Server 2005 (and 2008 too) provide the backbone data management infrastructure, while Microsoft Office applications, specifically Microsoft Office Excel, provide the flexibility for information...(read more)

Lets say you have an ongoing Stored Procedure that executes every week, as per the schedule that process might go as planned as reliable execution. Due to the recent changes on SQL Server platform (such as hotfix) or change in hardware configuration it might appear to be hanging after 12 hours. You may also see that particular query/stored procedure is not blocked, and you can even look at the execution plan of that query/statement and it may reveal that a trigger associated with that insert/delete...(read more)

In the database world Performance and Scalability goes in line like a railway track! In parallel SQLBits conferences are more popular in UK and Europe, where you get real-world content to learn and share. For the year 2010 it is SQLBits - The 6th Sets our latest, and if we may be so bold, our greatest event yet. The theme is performance and scalability, anything and everything that you can think on that theme. Once the sessions are submitted and ready for voting, registration will open around the...(read more)

SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are ways to add a plan or data to the SQL Server cache or to remove a plan or data from SQL Server cache, but these techniques are only recommended for testing or troubleshooting purposes. The key point is more you understand about optimal query plans,...(read more)

Here is the news for Scottish Area SQL Server user group members and new comers in Scotland that are enthusiastic to learn tips & tricks to tackle your day to day problems in SQL Server arena. Time Starts (UK time) at 18:00 , Finishes 21:00 Cost Free Organiser UK SQL Server User Group Address Microsoft Edinburgh, Waverley Gate, 2-4 Waterloo Place, Edinburgh, EH1 3EG Directions to Event Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 25th February ** Prize Draw Win £50 of Amazon...(read more)

This April, Microsoft is celebrating a number of product launches and innovations during an exciting week of technology and social events. Join them to find out how you can get the most from our latest technology releases and explore how Microsoft's platform and tools bring together the clients, servers and services needed to build rich engaging applications. Home Developer Days IT Professional Days Reg ister IT Professional Days A week of free technology events FOR developers, IT managers and IT...(read more)

First things first, from the followup of SQL_Server_2005_SP 4 post here is the good news to the community that SQL Server Release Services announcement about S QL Server 2005 SP4. You overwhelmingly requested another servicing release for SQL Server 2005. Given your feedback Microsoft targets now such release in Q4/CY2010. Based on current support volume as well as the fact that SQL Server 2005 will enter into extended support on 4/13/2011 we anticipate this to be the last Service Pack release for...(read more)

First things first, from the followup of SQL_Server_2008_SP2 post here is the good news to the community that SQL Server Release Services announcement about SQL 2008 SP2 release... Microsoft targets release in Q3/CY2010 . Next on the Cumulative Update package releases, here are the most recent cumulative update package for SQL Server 2008 SP1. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008 SP1. · CU#6 KB Article: http://support.microsoft.com/kb/977443/en-us...(read more)

SQL Server 2008 offers Analysis Management Objects (AMO) a complete library of classes designed to manage an instance of Analysis Services from a client application in managed code under the .NET Framework version 2.0. What I believe on the usage of these AMO in Analysis Services 2008 will alert you whenever best practice is not being followed: suggestions and warnings are delivered by AMO and are identified by a curvy blue line underneath the object in question. The message is displayed when you...(read more)