Other SQL Server Blogs around the Web

Take advantage of SQL Server Business Intelligence tools with Sharepoint

2010-02-28T22:37:00Z

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)

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

2010-02-28T22:13:00Z

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)

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

2010-02-26T00:46:00Z

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 Memory Cache - take help of DMV for optimal query plans

2010-02-24T07:48:00Z

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)

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

2010-02-24T04:38:00Z

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)

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

2010-02-18T17:28:00Z

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

SQL Server 2005 Service Pack 4 announement

2010-02-18T05:38:00Z

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)

SQL Server 2008 Service Pack2 announcement and Cumulative Update package releases

2010-02-18T05:23:00Z

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

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

2010-02-11T22:34:00Z

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)

IT PRO content of RC & Community Technology Preview software

2010-02-11T21:43:00Z

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 these videos to learn more: technical demonstration , technical deep-dive on UAG and DA . Download the Virtual Machines for Evaluating Office 2010 and SharePoint 2010 This set of virtual machines enables you to demonstrate and test Office 2010 and...(read more)

SQL Server - SSIS package transformation performance issues, follow up

2010-02-05T13:59:00Z

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 throws the error as per above blog post, the amount of memory that can trigger this issue varies for different computers. If the package is really handling huge number of rows such as millions of rows during import/export operations, then allocate...(read more)

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

2010-02-05T07:56:00Z

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 lead of this project is Mr. Nandan Nilekani, CEO Infosys and the project has been regularly making public their progress (and it has been good hands). In order to take this further and flexible t he UID team has come up with a unique opportunity to...(read more)

End of Support and lifecycle of Windows operating system

2010-02-04T09:37:00Z

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 achieve a more secure and compliant platform for your users, reduce your help desk costs, and increase performance and reliability for your end users. Here are some key dates to remember: March 1, 2010 – Windows 7 RC pre-expiration shut downs begin....(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

2010-02-01T15:38:00Z

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 failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure. 235 buffers were considered and 195 were locked. Either not enough memory is available to the pipeline because not enough are installed...(read more)

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

2010-01-27T13:46:00Z

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 so much data was flowing back and forth between the application server and the database server, too many things could go wrong. Here is the quick DMV that can get you list of operations in active transaction of the current session declare @xactid...(read more)