Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server 2008 (SSQA.net)

Trusted, Productive and Intelligent enterprise data platform.

Browse by Tags

All Tags » sql server » dba   (RSS)
Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008
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 Read More...
SQL Server 2008 new features highlights - a short video samples
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 Read More...
SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?
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 product Read More...
SQL Server 2008 - Activity Monitor a new key to DBA!
Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking/blocking. Read More...
SQL Server 2008 Resource Governor FAQ
Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and Read More...