Other SQL Server Blogs around the Web

Take advantage of SQL Server Business Intelligence tools with Sharepoint

Sun, 28 Feb 2010 22:37:00 GMT

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...(read more)

SQL Server - TSQL to get details of existing query that is running for long hours

Sun, 28 Feb 2010 22:13:00 GMT

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...(read more)

SQLBits - The 6th Sets :: theme is performance and scalability

Fri, 26 Feb 2010 00:46:00 GMT

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...(read more)

SQL Server Memory Cache - take help of DMV for optimal query plans

Wed, 24 Feb 2010 07:48:00 GMT

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...(read more)

An evening of performance troubleshooting and Ways to learn SQL Server, with a prize draw - Scottish Area SQL Server User Group February 25 2010

Wed, 24 Feb 2010 04:38:00 GMT

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...(read more)

A week of free technology events FOR developers, IT managers and IT professionals

Thu, 18 Feb 2010 17:28:00 GMT

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...(read more)

SQL Server 2005 Service Pack 4 announement

Thu, 18 Feb 2010 05:38:00 GMT

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...(read more)

SQL Server 2008 Service Pack2 announcement and Cumulative Update package releases

Thu, 18 Feb 2010 05:23:00 GMT

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...(read more)

Build an Alert mechanism by using Analysis Management Objects (AMO) - implement SQL Server 2008 OLAP Best Practices

Thu, 11 Feb 2010 22:34:00 GMT

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...(read more)

IT PRO content of RC & Community Technology Preview software

Thu, 11 Feb 2010 21:43:00 GMT

Evaluate Microsoft Forefront Unified Access Gateway 2010 Check out Forefront Unified Access Gateway (UAG) 2010, part of our identity and access management solution . You can also read the white paper on the DirectAccess feature of Forefront UAG and watch...(read more)

SQL Server - SSIS package transformation performance issues, follow up

Fri, 05 Feb 2010 13:59:00 GMT

To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance...(read more)

Opportunity to contribute to Government of India - Unique Identification Project, a Developers initiative.

Fri, 05 Feb 2010 07:56:00 GMT

Government of India has started the process & project of implementing the Unique Identification (UID) project for whole of India. For those who don’t know what it is find more about this initiative and see this PDF attachment too. Another face and...(read more)

End of Support and lifecycle of Windows operating system

Thu, 04 Feb 2010 09:37:00 GMT

Here is the information about Windows Operating System support life cycle that you need to concentrate: With the end of support (EOS) coming for several products, moving to Windows 7 and utilizing the many features built into the product can help you...(read more)

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure

Mon, 01 Feb 2010 15:38:00 GMT

A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; The buffer manager...(read more)

TSQL to get list of operations in active transaction of the current session

Wed, 27 Jan 2010 13:46:00 GMT

SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever...(read more)