April 2008 - Posts

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?
Published 30 April 8 3:53 AM | SSQA.net
Adding password complexity and password expiration to SQL Server logins is one of best feature I quote for SQL Server version 2005 onwards, similarly such password complexity policies are designed to deter brute force attacks by increasing the number...
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: , , , , , , , ,
Operations Day for SQL Server 2008 in UK - for Premier customers
Published 28 April 8 10:31 AM | SSQA.net
I found an interesting blog in The Premiers blog site that is used by Premier Field Engineering team within Microsoft that serves most of the Customers (Permier contracts), they are conducting an Open day - Operations Day for SQL Server 2008 within their...
Filed under: , , , , , ,
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 - 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 Business Intelligence - adopt sustainable practices on ETL processes with SSIS
Published 24 April 8 6:14 AM | SSQA.net
Making best use of SQL Server Integration Services within your ETL processes is a flexible choice, which has a huge share within the Business Intelligence application platform. You may be aware that SSIS introduces several new and enhanced features and...
Filed under: , , , , , , , , , ,
64 bit computing configuration with SQL Server 2005 - what you can take-on?
Published 23 April 8 6:31 PM | SSQA.net
It has been a while in posting X64 related information here, so that comes now about configuration gotchas you may need, for a starter though. X64 computing platforms have become common installations now a days due to the hardware reduced costing and...
Filed under: , , , , , , , ,
SQL Server databases - checkpoint, cache and I/O request - what you need to know?
Published 22 April 8 1:51 PM | SSQA.net
Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...
Filed under: , , , , , , , , , , ,
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: , , , , , , ,
SharePoint 2007 Conference DUBAI
Published 21 April 8 5:48 AM | SSQA.net
I was present in the SharePoint Conferrence in DUBAI. It was a very interesting 2 days Conference with a dinner with the experts night. For all those interrested , here is a link to some of the presentations. http://www.sharepointconferencedubai.com/Pages...
Filed under:
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?
Published 21 April 8 3:1 AM | SSQA.net
No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the...
Filed under: , , , , , , , ,
Most Valueable 'technical' week so far this year, for me - MVP Global summit 2008
Published 17 April 8 7:7 PM | SSQA.net
In continuation with MVP global summit related posts here I can say since 12th April 2008 it has been a very useful week in terms of Technical knowledge update & networking. As you may know this is a MVP exclusive event that is not one of public wide...
Filed under: , , , ,
SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?
Published 17 April 8 5:6 AM | SSQA.net
What kind of performance issues you see on day-to-day basis within your environment? The following elements are important factors that can add fuel to the fire (problem): Faulty hardware • Hardware that is not configured correctly • Firmware settings...
Filed under: , , , , , , , , , ,
SQL Server problem: Excessive paging and memory bottlenecks
Published 16 April 8 2:2 AM | SSQA.net
Paging and Memory bottlenecks are quite common when a performance problem strikes on your SQL Server. As we discussed here previously and relevant blog posts below talks about them: Paging and Available Memory for Operating sysem, what you need to know...
Filed under: , , , , , ,
SQL Server 2005 Service Pack 3 - work started
Published 15 April 8 4:37 PM | SSQA.net
Ok here is the hot news for SQL 2005 users!!! From the Are you ready for SP3 post here, it has been officially announced the SP3 for SQL Server 2005 will be available in CY2008 (calender year 2008) that means before 31st December 2008! More from this...
Filed under: , , , , ,
Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)
Published 15 April 8 3:58 PM | SSQA.net
Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it...
Filed under: , , , , , , , , , ,
SQL Server Replication - resolving too many snapshots issues?
Published 15 April 8 6:15 AM | SSQA.net
In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and...
Filed under: , , , , , , ,
SQL Server SSIS packages metadata solution pack
Published 14 April 8 3:1 AM | SSQA.net
Do you have hundreds of SSIS packages to manage? Do they run at various times to address the ETL solutions within your environment? Let's say you have to modify the base table columns, so you need to consider what kind of impact this change would...
Filed under: , , , , , , ,
SQL Server 2008 - What's new for IT Pro community [UK Usergroup conference]
Published 9 April 8 10:28 AM | SSQA.net
In continuaton to UK User Group conference (2 day) in Microsoft Campus, Thames Valley Park Reading here is my presentation to download that was delivered on 09th April 2008. Appreciate your feedback....( read more ) Read More...
Filed under: , , , , , , , ,
SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues
Published 9 April 8 2:22 AM | SSQA.net
Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime...
Filed under: , , , , , , , , , ,
More Posts Next page »