SqlServer-QA.net

Here we go again, Scottish Area SQL Server User Group lined up another brain storming user group meeting on November 13th 2008 (Thursday) within Microsoft Edinburgh campus. For registration and more details about this jamming gotchas visit - SQLServerFAQ posting.    

SQL Data Services (SDS), formerly known as SQL Server Data Services (SSDS), are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server technologies and Windows Server, SDS provides highly available, secure, standards based web services that are easy to program and provision. On Monday 10/27/2008, ...

As promised by SQL Server Developmen team about SQL Server 2005 SP3 the public beta is now available for your action and set of tasks for your 2005 environment. So what this public beta provides, this is a rollup Quick Fix Engineering that will have all the work including from SP2 as well as addresses critical issues reported through the SQL ...

I thought I can blog this post in SQL 2008 blog section, but the subject is more appealing towards Transact SQL so here it is. Do you want to know about Transact-SQL (TSQL) fundamentals? Are you interested to get insight of SQL Server 2008 TSQL topic by Itzik Ben-Gan? (I believe no one says, no) Then here is the wonderful opportunity for you ...

A new website about SQL Server 2008 is released by Microsoft development team, SQL Server 2008 Experience web site. Read more from Data_Platform_Insider blog post.

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?  blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking to handle these important tasks in hand with the scripts and not to leave to the GUI or API ...

Here is another meeting scheduled for Scottish Area SQL Server USergroup after the long (summer) holidays, don't miss the event if you want to know:  What’s new for a DBA in SQL Server 2008? There are many great new features in SQL Server 2008. In this presentation Martin will demonstrate some of his favourite features that will be of ...

How many tools (new and enhanced) are available within SQL Server 2008 when you have a need to monitor the performance of queries that are executing/generated? The initial ones you remember is PROFILER and PERFMON (SYSMON) tools, even further few will say Performance Dashboard reports & Dynamic Management Views. The new tools that are ...

You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage.  No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present? issues to resolve. Just to talk in list of documentation, SQL Server Express makes ...

SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know how to perform routine maintenance tasks for server components, and how to manage the content and ...