Browse by Tags

New SQL Server 2008 Experience web site launched

Published 2 October 8 2:50 AM | SqlServer-QA.net

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

Filed under: sql server, customer, website, new features, experience

Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008

Published 29 September 8 2:15 AM | SqlServer-QA.net

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...

Filed under: sql server, restore, database, dba, backups, task, new features, scripting

What's new for a DBA in SQL Server 2008 - Scottish Area SQL Server User Group

Published 19 September 8 3:28 AM | SqlServer-QA.net

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...

Filed under: sql server, dba, new features, scotland, usergroup, scottish developers, sassug

SQL Server 2008 Performance Data Collection and Analysis, how best you can take advantage?

Published 11 September 8 2:11 AM | SSQA.net

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...

Filed under: sql server, performance, features, sqlbits, conference, new features, data warehouse, policy based framework

Installation gotchas and guidelines - SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1

Published 1 September 8 3:2 AM | SSQA.net

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...

Filed under: sql server, blogs, sql express, installation, developers, new features, isv, guidelines, gotches

Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005

Published 11 July 8 4:38 AM | SSQA.net

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...

Filed under: sql server, 2008, 2000, reporting services, 2005, new features

SQL Server 2008 new features highlights - a short video samples

Published 25 June 8 1:6 PM | SSQA.net

I'm sure that by now you are aware about the list of new features within SQL Server 2008 and recently I have had couple of emails from newbie DBA/users in SQL Server asking about any reference they can get on these new features, with a video. In this...

Filed under: sql server, dba, xml, video, samples, new features

SQL Server 2008 release, 1st anniversary and it is CTP I'm talking!

Published 2 June 8 3:9 AM | SSQA.net

It is 1 year (first anniversary) that SQL Server 2008 Community Technology Preview is released, I have seen many good things and few peeves about this new version of SQL Server. Not to mention about largest conference is lined up for the users aka '...

Filed under: sql server, microsoft, documentation, 2008, ctp, new features, rc, release candidate

SQL Server 2005 Failover Clustering on Windows Server 2008 - webcast

Published 16 May 8 9:13 PM | SSQA.net

Windows Server 2008 is on full fledged wave now after it has been launched in February and it is obvious that many questions will be flying around about supportability & manageability for existing SQL Server versions such as 2005 at the moment. Think...

Filed under: sql server, best practices, clustering, failover, windows 2008, new features

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

Published 14 May 8 3:23 AM | SSQA.net

I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...

Filed under: sql server, performance, blogs, ssms, dba, dmf, best practice, new features, resource governor, policy based framework

SQL Server 2008 and simplified scripting through PowerShell

Published 9 May 8 4:45 AM | SSQA.net

Have you ever seen or used the PowerShell? If so have you worked on PowerShell within SQL Server 2008, it has 2 kinds of snap-ins that are called as Powershell Provider and set of Cmdlets. The provider will enables the simple navigation mechanism similar...

Filed under: sql server, download, documentation, ctp, new features, windows server, scripting, powershell

Windows Server 2008 Terminal Services - extra benefit in using SQL Server 2008 Managment Studio to connect remotely

Published 8 April 8 2:45 AM | SSQA.net

To make better use of features and enhancement within Windows Server 2008 release and SQL Server 2008, where the ability to connect the Management Studio (SSMS 2008) at the server rather than running it locally. Buck Woody SQL Program Manager has given...

Filed under: sql server, machine, 2008, multiple, new features, windows server, benefit, terminal services, remotely

SQL Server 2008 TSQL enhancements - what I like?

Published 4 April 8 9:58 AM | SSQA.net

Simple, short and crisp - I would like to say about TSQL enhancements within SQL Server 2008. You may already aware about what's new and how best you can take advantage within your code, most of the Developers would agree about IntelliSense functionality...

Filed under: sql server, performance, blogs, technet, merge, tsql, plan guide, new features, tvp, table-value

SQL Server 2008 Spatial data - geography & geometry, all in one

Published 20 March 8 3:32 AM | SSQA.net

Geography & Geometry has much significance in day to day life, within that as a data now you can manage within your Database using SQL Server 2008 new data type - spatial, this represents information about the physical location and shape of geometric...

Filed under: sql server, indexes, 2008, labs, data capture, spatial, data type, links, new features, geometry, geography

Query Execution Plans security and new feature within SQL Server 2008 Management Studio

Published 4 March 8 2:4 AM | SSQA.net

If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...

Filed under: sql server, performance, ssms, query, users, execution plan, monitoring, new features, .xml, plan cache, document, .sqlplan

SQL Server 2008 February CTP, is availble to download now!

Published 20 February 8 5:37 AM | SSQA.net

Continuing from this SQL2008CTP blog post it seems there is a confusion on the SQL 2008 CTP downloads page The technet link 851664 refers that Evaluate Microsoft SQL Server 2008 today page was p ublished: November 12, 2007 and further after registering...

Filed under: sql server, microsoft, technet, download, 2008, ctp, share, new features

SQL Server 2008 Change Data Capture - Do you really want to log all the data activities such as audit trails?

Published 1 February 8 9:50 AM | SSQA.net

In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log...

Filed under: sql server, users, ctp, environment, cdc, best practice, testing, triggers, new features, audit trial, change data capture, stored procedures

SQL Server 2008 - what's new, a list would be nice?

Published 4 December 7 4:48 AM | SSQA.net

SQL Server 2008 Community Technology Preview (CTP) instalment 5 is ready to available for the users, I think this is the 3rd instalment since SQL 2008 is announced by Microsoft. The Application support team have been asking for a list of new/enhanced...

Filed under: sql server, microsoft, high availability, download, 2008, ctp, new, 2005, available, new features, many more