Other SQL Server Blogs around the Web

Compatibility Level of a database

SqlServer-QA.net — Mon, 05 Jan 2009 15:05:00 GMT

When users migrate from SQL Server 2000 to SQL Server 2005, not all databases are set to Compatibility Level 90 which is required to make use of the newly available functions There are many methods to know the Compatibility Level of a database using queries...(read more)

SQL Server TSQL security concerns - highlights for a newbie reference

SqlServer-QA.net — Mon, 05 Jan 2009 07:01:00 GMT

Here it is first post in the year 2009, still I would like to visit the good old advice of securing your SQL Server environment. For any user in IT, Security must be a top priority in order to ensure their PC or environment is secured. You might have...(read more)

December Cumulative Update for Office SharePoint Server 2007 and Windows SharePoint Services 3.0

SqlServer-QA.net — Fri, 02 Jan 2009 10:33:00 GMT

Here is the extract from Sharepoint Team blog about December Cumulative Update for Office Sharepoint Server 2007 and Windows Sharepoint Services 3.0. The first and foremost advice from the team is you need not install these updates unless your installation...(read more)

SQL Server 2008 tools installation issues when SQL Server 2005 client tools are present - FAQ and gotchas.

SqlServer-QA.net — Fri, 02 Jan 2009 10:25:00 GMT

How many times you have faced the problems in installing SQL Server client tools? Have you ever tried to install latest version of SQL Server tools on previous version? Recently I have run into such a problem when installing SQL Server 2008 client tools...(read more)

Happy New Year

SqlServer-QA.net — Wed, 31 Dec 2008 14:20:00 GMT

set nocount on select space ( 7 - len ( replicate ( char ( 42 ), no )))+ replicate ( char ( 42 ), no * 2 - 1 ) from ( select top 5 row_number () over ( order by name ) as no from sysobjects ) as t union all select space ( 5 )+ replicate ( char ( 124 ...(read more)

Keep SharePoint Growth in Check with Effective Content Lifecycle Management

SqlServer-QA.net — Mon, 29 Dec 2008 18:11:00 GMT

Make information archival a component of your SharePoint content lifecycle management strategy Organizations are generating large volumes of mission-critical information on Microsoft SharePoint. As hundreds of gigabytes or even terabytes of unstructured...(read more)

Managing all your ETL requiement and file system tasks using SQL Server Integration Services

SqlServer-QA.net — Mon, 29 Dec 2008 10:33:00 GMT

In many case within the forums and newsgroups I still see many questions from the users asking about SSIS (SQL Serve Integration Services) and here few bits I'm covering on basics on this important service in SQL Server arena. SSIS is a key part of...(read more)

Windows Communication Foundation (WCF) - very good starter for developers of all levels

SqlServer-QA.net — Wed, 24 Dec 2008 22:15:00 GMT

During the Microsoft Tech-Ed North America conference Windows Communication Foundation (WCF) is one of the interesting topics I would like to go about, it provides a unified framework for rapidly building service-oriented applications that makes it easy...(read more)

SQL Server stored procedure vulnerability heap buffer overrun in SQL Server, MSDE, and SQL Express

SqlServer-QA.net — Tue, 23 Dec 2008 09:46:00 GMT

You may have seen the sp_replwriterovarbin - New SQL Server Injection-Based Attack Found vulerability about the new public reports of a vulnerability that could allow remote code execution on systems with supported editions of SQL Server 2000, 2005, 2005...(read more)

DEVConnections - Orlando FL March 22-25 2009

SqlServer-QA.net — Fri, 19 Dec 2008 13:53:00 GMT

--> --> --> DevConnections rocks the technology industry as the largest and most exciting event focused on Microsoft technology and your needs. Hands-down this event has the best speakers in our industry, not to mention the coolest attendees...(read more)

Microsoft security bulletin MS08-078, Security Update for Internet Explorer (960714)

SqlServer-QA.net — Thu, 18 Dec 2008 16:43:00 GMT

Microsoft security bulletin MS08-078, Security Update for Internet Explorer (960714) to address a vulnerability in all currently supported versions of Internet Explorer . This security update was released outside of the usual monthly security bulletin...(read more)

sp_replwriterovarbin - New SQL Server Injection-Based Attack Found

SqlServer-QA.net — Wed, 17 Dec 2008 07:10:00 GMT

Another security vulnerability or rather call in the sense of security experts that " A zero day vulnerability has been reported in SQL Server "! Though its a not serious flaw or problematic loophole to worry but still its a security flaw in...(read more)

Business Intelligence - control what you want with your hands!

SqlServer-QA.net — Tue, 16 Dec 2008 15:48:00 GMT

How about you control what you want to see and get with your hands? A global view of information get a real-hands-on on business intelligence! Here is the newest invention from Microsoft about it, Business Intelligence Surface - click on this link: http...(read more)

SQL Server 2005 Service Pack 3 (SP3) is released

SqlServer-QA.net — Tue, 16 Dec 2008 08:15:00 GMT

From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News...(read more)

Replication and Database Mirroring - things to take care and best practices to administer the environment

SqlServer-QA.net — Mon, 15 Dec 2008 11:37:00 GMT

Replication and Database Mirroring are the ones which can provide high availability option without an extra cost what it implies on a Clustering setup. So in this scenario Database mirroring can be used in conjunction with replication to provide availability...(read more)