Browse by Tags

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, database, dba, blog, best practices, responsibilties, backups, strategy, size

TSQL to change collation of database, whats new in SQL 2008 then?

Published 12 March 8 1:24 PM | SSQA.net

Cross post from my BlogCasts site....( read more ) Read More...

Filed under: sql server, blog, table, tsql, collation, changes

The SQL server specified in SSIS service configuration is not present or is not available. This might occur where there is no default instance of SQL Server on the computer

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

Multiple versions of SQL Server installation is quite common when your enterprise is looking forward to upgrade to latest versions of SQL Server, in this regard recently one of the Application user reported a problem with regard to SSIS & DTS services...

Filed under: sql server, ssis, ssms, blog, service, 2000, 2005, integration services, packages, disabled

Another real world example - Why Do Many Software Vendors Provide Bad Software and Bad Support?

Published 3 February 8 6:29 AM | SSQA.net

Its a nightmare when you have got inefficient support person over phone or onsite for the problem you are facing with software or IT related problem. Here is RealWorld problem that how hard and furstating saga you can go with it!...( read more ) Read...

Filed under: sql server, databases, blog, support, samples

We wish you Happy Holidays - Merry Christmas and New Year !!!

Published 21 December 7 6:29 AM | SSQA.net

Merry Christmas .... HAPPY NEW YEAR... whatever makes your wish come true! Wish you HAPPY HOLIDAYS and be safe/have fun during this season............ Thanks for all the support and registering here.... hope you find this site useful for your tasks.....

Filed under: tuning, services, blog, website, holidays

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?

Published 19 December 7 6:6 AM | SSQA.net

How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes'...

Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring

SQL Server 2005: Slow running queries - Blocking and Index problems

Published 24 September 7 9:19 AM | SSQA.net

As a DBA you must be aware that slow or long running queries can contribute to excessive resource consumption and be the consequence of blocked queries. No database application is exception to this behaviour, so the queries that also run slowly because...

Filed under: sql server, indexes, blocking, dmv, blog, tsql, poor

Other blogs we recommend

Published 12 September 7 5:22 AM | SSQA.net

Today I have started a new section here "Other Blogs we recommend" to roll the blog posts from SQL Server Experts such as Kalen Delaney, Kimberley Tripp, Bob Beauchemin and Paul Randall that I follow regularly. Until now I used to blog roll...

Filed under: business continuity, sql server, msdn, high availability, blog, kalen, business intelligence, kimberly

My Photo albums I would like to share!

Published 12 August 7 1:37 PM | SSQA.net

Tech-ed Orlando Trip MVP Global Summit - Seattle Miracle - SQL Server Open world PASS, 2006-US Trip [13th Nov - 21st Nov] 2006...( read more ) Read More...

Filed under: sql server, pass, mvp, blog, tecd-ed, global, open world, summit, share, photos, copenhagen

Learn about Notification Services - a tutorial

Published 23 July 7 7:44 AM | SSQA.net

The Notification Services tutorial teaches you how to build a simple Notification Services application. The tutorial uses a SQL Server Management Studio solution to make it easy to edit tutorial files and then build the solution using SQL Server Management...

Filed under: sql server, services, blog, notification, tutorial

Database Mirroring: FQDNs are Your Friends!

Published 16 June 7 2:29 PM | SSQA.net

Cross posted from : Adam Machanic SQLBlog that helped me to resolve one issue during a DB mIrroring issue. Read More...

Filed under: high availability, backup, blog, fqdn, database mirroring

SQL Server 2005 how to find a rarely used index?

Published 18 May 7 5:31 AM | SSQA.net

For a SQL Server database having an index is always beneficial and from performance point of view too. But how about the clustered index which is occupying space on the database that is not used by any of the queries in the database. The Query Optimizer...

Filed under: sql server, indexes, databases, blocking, perfmance, blog, monitor