Browse by Tags

All Tags » dba » sql server (RSS)
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: , , , , , , ,
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: , , , , , ,
SQLBits (III) Cubed - Mark your diary September 13 2008
Published 1 August 8 7:25 AM | SSQA.net
Here it comes again, second one in this year one of the biggest UK based SQL Server conference - SQLBits III aka cubed. It is free to attend and what you will get is: 20 hours of top content from the world of SQL Server presented by the top speakers in...
Filed under: , , , , , , ,
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: , , , , ,
Tech-ed North America - what I'm doing there?
Published 29 May 8 4:18 PM | SSQA.net
This is first time Microsoft has divided the conference into 2 sections, Developer & IT-PRO. Why Attend Tech-ed? IT Pros, you'll gain new solutions and new ideas for being more productive from sessions, product assessments, and interaction with...
Filed under: , , , , , , , , , ,
Red-gate news: New SQL Server DBA Awards - the search for the Exceptional DBA of 2008 begins
Published 28 May 8 5:56 AM | SSQA.net
DBAs look after an organization's most important asset – its data – and yet their contribution to an organization is all too often misunderstood. Now it's time for DBAs to finally get the recognition they deserve with some new community awards...
Filed under: , , , ,
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 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?
Published 29 April 8 5:14 AM | SSQA.net
As a DBA you might be aware that since SQL Server 2005 database maintenace plans have given flexibility in deploying the workflow of tasks required to make sure that your database is optimized, is regularly backed up, and is free of inconsistencies in...
Filed under: , , , , , , , ,
SQL Server 2008 - Activity Monitor a new key to DBA!
Published 11 March 8 3:14 AM | SSQA.net
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...
Filed under: , , , , , , , ,
SQL Server 2008 Resource Governor FAQ
Published 25 February 8 1:36 AM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
Published 21 February 8 6:22 AM | SSQA.net
The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...
Filed under: , , , , , , , , ,
DevWeek 2008 - SQL Server DEVCON 2008 mark your diaries
Published 4 February 8 3:11 PM | SSQA.net
The 11th annual DevWeek conference, the UK's biggest dedicated event for software developers, features a choice of 16 all-day workshops and over 70 breakouts sessions on a wide range of topics, including .NET Framework 3.5, Silverlight, WCF, Visual...
Filed under: , , , , , , ,
SQL Server 2005 DMV - how it can help to consider whether index is useful or not?
Published 4 February 8 8:6 AM | SSQA.net
When it comes to performance, for a DBA indexes are the first one to come to mind in order to fine tune the tasks on the database. In this series we have already covered this huge topic of indexing and how best you can make use of Dynamic Management Views...
Filed under: , , , , , ,
SQL Server Security & Compliance - webcast by IDERA
Published 18 January 8 8:58 AM | SSQA.net
"SQL Server Security & Compliance" Sponsored by Idera : SQL Server security and compliance go hand in hand. With the changes in legislation and new requirements to ensure that database platforms such as SQL Server are secure we will take...
Filed under: , , , , , , , , ,
SQL Server Query Performance - think about page split and fragmentation, measures to reduce the behaviour and best use of dm_db_index_physical_stats DMV
Published 14 January 8 2:22 AM | SSQA.net
It is an universal truth in the database field that due to the fragmentation and page split the performance will be affected even for a simple [ SELECT <ColumnName> from.... ] type of query. So what you need to check or take action in terms of DBA...
Filed under: , , , , , , , , ,
SQL Server TSQL to find complete CONSTRAINT information on a table catalog?
Published 9 January 8 7:26 AM | SSQA.net
I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name...
Filed under: , , , , , , , ,
How to be an Exceptional DBA - free ebook.
Published 2 January 8 12:14 PM | SSQA.net
A new year gift to the SQL Server users!! As the title states every DBA wants to be exceptional within their environment . Within your demanding role there are more things that needs importance in continuing the fire-fighting techniques to keep up the...
Filed under: , , , , , , , ,
SQL Server: How do I identify the queries that are worth tuning?
Published 16 November 7 7:2 AM | SSQA.net
Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...
Filed under: , , , , , , , , ,
How to find whether backup is performed using SQL native methods or third party tools?
Published 23 October 7 4:59 AM | SSQA.net
Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to...
Filed under: , , , , , ,
Calculate size of an index for a new database?
Published 17 October 7 2:6 PM | SSQA.net
How can you calculate size of an index in a database whenever a capacity planning exercise if performed? By default the size allocated for each user objects depends on the user application and on the amount of space that is created by the application...
Filed under: , , , , , , , ,
More Posts Next page »