Browse by Tags

SQL Server Expert Seminars in June: SQL Server and Virtualisation

Published 5 June 8 4:47 AM | SSQA.net

Quest Software has lined up 2 events where you can learn more about consolidation and virtualisation for your SQL Server environment. SQL Server Technology Day Tuesday, 24 June 2008 9 a.m. - 5 p.m. (lunch included) Maidenhead, Berkshire Join Douglas Chrystall...

Filed under: sql server, databases, seminar, consolidation, quest, events, sqlpass, virtualisation

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

Published 27 May 8 3:48 AM | SSQA.net

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their...

Filed under: sql server, databases, security, permissions, sqlagent, reporting services, reportserver, reportservertempdb, rsexecrole

SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

Published 12 May 8 4:25 AM | SSQA.net

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...

Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

Published 25 April 8 3:30 AM | SSQA.net

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...

Filed under: sql server, indexes, memory, databases, cache, cpu, monitoring, operating system, huge, dbcc shrinkfile

Why Backup, Why Recovery? You need a good strategy to save your data!

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

The following context is the one I have received from SQL Server Magazine that talks about a good backup tool in the market, study on: Third-Party Tool Enhances SQL Server Backup and Recovery Microsoft SQL Server’s own backup and restore facilities are...

Filed under: sql server, databases, backup, red-gate, recovery, toolkit, third party, strategy

Windows Server 2008 deploy within your environment securely!

Published 6 March 8 2:50 AM | SSQA.net

Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day...

Filed under: sql server, databases, microsoft, security, server, windows, 2008, environment

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: sql server, performance, databases, dba, disk space, error log, monitoring, configuration, alter database, auto grow

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

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

How to monitor transaction activity between the databases?

Published 10 January 8 4:23 AM | SSQA.net

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more...

Filed under: sql server, databases, dmv, i/o, tsql, statistics, activity

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: sql server, databases, dba, function, requirement, tsql, tablename, constraint, values

TSQL to get default location of database data and log files?

Published 8 January 8 6:37 AM | SSQA.net

By default the SQL Server database data & log files are created on the default data directory which is Program Files or based on where SQL binary files are installed. In order to find what is the default location you can run following TSQL: declare...

Filed under: sql server, databases, location, tsql, data file, log file, default, program files

SQL Server SP_HELPINDEX - updated version that includes column names

Published 3 January 8 1:46 PM | SSQA.net

Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA...

Filed under: sql server, indexes, databases, sql queen, script, columns, kalen delaney, sp_help, included, sp_helpindex

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, databases, red-gate, dba, download, ssp, sql-server-performance, ebook, beginners in sql serever

Scottish Developers - Gary Short's Favourite Design Patterns

Published 21 December 7 3:59 PM | SSQA.net

If you've heard of design and enterprise patterns and want to find out a bit more... What: Lecture Host: Scottish Developers When: Wednesday, January 16 at 7:00pm Where: CPDC, Glasgow Caledonian University RSVP & More information: http://www.scottishdevelopers...

Filed under: sql server, databases, microsoft, event, events, developers, scotland, scottish developers, glasgow, design

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

FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005

Published 16 December 7 6:57 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A federated database server stops responding when you run parallel queries...

Filed under: sql server, databases, x64, 2005, multi-processor, parallel queries, numa, federated, architecture

SQL Server 2005 Database Mirroring - basics and related resources

Published 10 December 7 4:33 AM | SSQA.net

To provide High Availability feature within your database environment you could take advantage of Database Mirroring when using SQL Server 2005. As with all critical databases, minimizing data loss and downtime are of the highest importance. Having "AlwaysOn"...

Filed under: sql server, databases, high availability, database mirroring, tsql, best practice, production, testing

Changing ports on production SQL Server - things to watch for 1433

Published 7 December 7 12:29 PM | SSQA.net

What is your criteria on assigning ports to SQL Server? Are you leaving them to default 1433? Is your SQL Server is exposed to Internet or any external sources where there is a chance to produce mass attach or run code injection? Every DBA should give...

Filed under: sql server, databases, microsoft, security, best practice, port, 1433, operating system

Windows Vista SP1 Release Candidate Announcement

Published 6 December 7 12:32 PM | SSQA.net

Windows Vista SP1 RC is released on 05th December to the Beta Testers on the Microsoft-Connect and on 06th December it is available via MSDN and TechNet subscribers. Few things if you want to know about Vista SP1 RC refer to the following notes from Microsoft...

Filed under: sql server, databases, microsoft, best practices, vista, testing, beginners, service pack1, rc