Browse by Tags

All Tags » dba (RSS)
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: , , , , , , , ,
Solid Quality Mentors - Don't miss our SQL Server DBA Bootcamp in Dallas, TX
Published 17 October 7 12:55 PM | SSQA.net
Don't miss our SQL Server DBA Bootcamp in Dallas, TX November 12-16, 2007 Register Now for this SQL Server DBA Bootcamp taught by Randy Dyess 5-Day Bootcamp only $3,200! Course Information: This course will give you a broad look at the enhancements...
Filed under: , , , , , , , , ,
Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.
Published 10 October 7 4:31 PM | SSQA.net
A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...
Filed under: , , , , , , , ,
Disk Space Requirements for Index DDL Operations
Published 28 September 7 8:38 AM | SSQA.net
Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information...
Filed under: , , , , , , , , , ,
More Posts Next page »