Browse by Tags

Cumulative Update 8 package for SQL Server 2005 Service Pack2

Published 16 July 8 4:50 AM | SSQA.net

I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...

Filed under: sql server, blogs, best practices, service pack2, 2005, cumulative update, cu7

DTS Packages migration webinar - get tips and tricks from a MVP

Published 15 July 8 10:44 AM | SSQA.net

Brian Kinight is well known SQL Server Professional in the community, every user will know about SQL Server Central website which was founded by him. Join Brian to discuss the strategies of upgrading DTS packages to SQL Server Integration Services (SSIS...

Filed under: sql server, webcast, mvp, dts, best practices, migration, webinar

SQLKnowHow - gear up for exclusive training from professionals

Published 8 July 8 8:27 AM | SSQA.net

SQLKnowHow is the new organisation that is focused on training services based on SQL Server. In this regard they have lined up very interesting list of events in coming months, it will be a great time for the SQL Server Users in United Kingdom to grab...

Filed under: sql server, performance, sql queen, concurrency, best practices, locking, design, training, indexing

SQL Server Technical Rollup July 2008 - Important & Interested links for you

Published 7 July 8 2:51 AM | SSQA.net

As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena. Downloads Source Code Analyzer for SQL Injection...

Filed under: sql server, msdn, technet, download, best practices, information, beginners in sql serever

Why Do People Bash Microsoft?

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

I found an interesting article by Kalen Delaney aka SQL Goddess (as I call) about a topic stating ' why do people bash Microsoft? ' The article was printed in SQL Server Magazine: Last week, I read a post from one of my colleagues, which shared...

Filed under: sql server, microsoft, sql queen, best practices, kalen delaney, business practices

SQL Server Cumulative Update uninstallation fiasco. Dude, can I remove SQL Server setup files?

Published 28 May 8 3:10 AM | SSQA.net

We have been struggling to uninstall the Cumulative Update package 7 on a development SQL Server! As it is an important aspect of installation to rollback or to have a backout plan tested if you are performing any kind of installation against your Production...

Filed under: sql server, kba, best practices, setup, cumulative update, installallation

SQL Server 2005 Connectivity, Security policies & Network protocols: simple practice to follow, after installation?

Published 23 May 8 3:44 AM | SSQA.net

Secured by default, secured by design is the buzzword and catchy stuff for any Enterprise IT administrators. Then it comes about standards and policies to follow such as ISO , with the recent threats (last 10 years) and vulnerabilities within IT world...

Filed under: sql server, blocking, security, best practices, hotfix, service pack, cumulative update

Install cumulative update package 7 on a SQL Server Cluster?

Published 22 May 8 3:3 AM | SSQA.net

IN continuation to the post Rollback_of_CumulativeUpdate-hotfix-ServicePack I was asked about any procedure or steps on installing Cumulative update package 7 for SQL Server 2005 Service Pack 2 on Active node SQL 2005 cluster. The simple answer is all...

Filed under: sql server, best practices, hotfix, clustering, uninstall, cumulative update, css

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process

Published 21 May 8 4:20 AM | SSQA.net

The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is...

Filed under: sql server, best practices, 32 bit, 64 bit, configuration, service account, sp_configure, lock pages in memory

SQL Server Service Pack or Hotfix patch or Cumulative Update: do not attempt Windows System Restore as a backout plan?

Published 19 May 8 4:28 AM | SSQA.net

To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...

Filed under: sql server, restore, best practices, system, uninstall, windows 2003, cumulative update, downgrade

SQL Server 2005 Failover Clustering on Windows Server 2008 - webcast

Published 16 May 8 9:13 PM | SSQA.net

Windows Server 2008 is on full fledged wave now after it has been launched in February and it is obvious that many questions will be flying around about supportability & manageability for existing SQL Server versions such as 2005 at the moment. Think...

Filed under: sql server, best practices, clustering, failover, windows 2008, new features

SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?

Published 15 May 8 3:59 AM | SSQA.net

Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server...

Filed under: sql server, performance, dmv, best practices, tempdb, monitoring, benchmarking, performance monitoring

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 - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

Published 8 May 8 3:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

SQL Server Release Services - Cumulative Update or frequent Service pack releases, which one you favour?

Published 7 May 8 3:26 AM | SSQA.net

Here is the hot news, SQL Server Global Release Services (GRS) has revised their schedule of releasing Service Packs for SQL Server product by stating ' changed approach to Service Packs '. Now the big question how far you can stretch in deploying...

Filed under: sql server, microsoft, high availability, best practices, service pack, cumulative update, releases

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

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

Published 28 April 8 3:1 AM | SSQA.net

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...

Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout

SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object

Published 22 April 8 3:1 AM | SSQA.net

Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was...

Filed under: sql server, access, best practices, object, 2005, tsql, schemas, alter authorisation

SQL Server configuration disk layout - best practices from field

Published 3 April 8 3:17 AM | SSQA.net

Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...

Filed under: sql server, performance, data, log, disk, best practices, tempdb, monitoring, configuration, layout

Web Seminar: True High Availability for SQL Servers

Published 27 March 8 4:27 AM | SSQA.net

Another sponsored link I have got from Windows magazine: When: Thursday March 27, 2008 12:00 PM EDT Register today! (now) Simply put, your critical applications use SQL. It is the silent engine behind the curtains doing the heavy and important work keeping...

Filed under: sql server, webcast, high availability, best practices, seminar, applications, HA, helpful