MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

April 2008 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Syndication

News

Blog Archive List

Sort by: Most Recent | Most Viewed | Most Commented

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?

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...

Published Wed, Apr 30 2008 3:53 by SSQA.net

Filed under: sql server, microsoft, security, feature, password, best practice, trustworthy, computing, logins, policies, settings, check_policy, check_expiration
SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?

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...

Published Tue, Apr 29 2008 5:14 by SSQA.net

Filed under: sql server, database, dba, blog, best practices, responsibilties, backups, strategy, size
Operations Day for SQL Server 2008 in UK - for Premier customers

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...

Published Mon, Apr 28 2008 10:31 by SSQA.net

Filed under: sql server, microsoft, support, operations, contact, uk, premier
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

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...

Published Mon, Apr 28 2008 3:01 by SSQA.net

Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout
SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

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...

Published Fri, Apr 25 2008 3:30 by SSQA.net

Filed under: sql server, indexes, memory, databases, cache, cpu, monitoring, operating system, huge, dbcc shrinkfile
SQL Server Business Intelligence - adopt sustainable practices on ETL processes with SSIS

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...

Published Thu, Apr 24 2008 6:14 by SSQA.net

Filed under: sql server, ssis, ssas, ssrs, machine, bids, etl, administrator, biztalk, business intelligence, adapter
64 bit computing configuration with SQL Server 2005 - what you can take-on?

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...

Published Wed, Apr 23 2008 18:31 by SSQA.net

Filed under: application, sql server, performance, x64, hardware, computing, sap, compatability, 64-bit
SQL Server databases - checkpoint, cache and I/O request - what you need to know?

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...

Published Tue, Apr 22 2008 13:51 by SSQA.net

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl
SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object

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...

Published Tue, Apr 22 2008 3:01 by SSQA.net

Filed under: sql server, access, best practices, object, 2005, tsql, schemas, alter authorisation
SharePoint 2007 Conference DUBAI

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...

Published Mon, Apr 21 2008 5:48 by SSQA.net

Filed under: sharepoint
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?

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...

Published Mon, Apr 21 2008 3:01 by SSQA.net

Filed under: sql server, data, backup, blogs, simple, 2005, full, recovery model, changes
Most Valueable 'technical' week so far this year, for me - MVP Global summit 2008

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...

Published Thu, Apr 17 2008 19:07 by SSQA.net

Filed under: sql server, microsoft, team, 2008, global summit
SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?

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...

Published Thu, Apr 17 2008 5:06 by SSQA.net

Filed under: sql server, memory, analysis, disk, IO, monitoring, configuration, iometer, contention, latches, latching
SQL Server problem: Excessive paging and memory bottlenecks

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...

Published Wed, Apr 16 2008 2:02 by SSQA.net

Filed under: sql server, memory, audit, paging, bottlenecks, logical disk, pagesize
SQL Server 2005 Service Pack 3 - work started

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...

Published Tue, Apr 15 2008 16:37 by SSQA.net

Filed under: sql server, blogs, download, 2005, cumulative update, sp3
Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)

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...

Published Tue, Apr 15 2008 15:58 by SSQA.net

Filed under: sql server, microsoft, blogs, download, kba, service pack, cumulative update, downgrade, cu7, affected, releases
SQL Server Replication - resolving too many snapshots issues?

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...

Published Tue, Apr 15 2008 6:15 by SSQA.net

Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule
SQL Server SSIS packages metadata solution pack

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...

Published Mon, Apr 14 2008 3:01 by SSQA.net

Filed under: sql server, ssis, solution, download, report builder, etl, metadata, packages
SQL Server 2008 - What's new for IT Pro community [UK Usergroup conference]

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...

Published Wed, Apr 9 2008 10:28 by SSQA.net

Filed under: sql server, community, 2008, enterprise, best practice, whatsnew, conference, usergroup, itpro
SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues

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...

Published Wed, Apr 9 2008 2:22 by SSQA.net

Filed under: sql server, package, profiler, ssis, xml, error log, 2005, information, warning, logging, event viewer

1 2 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

April 2008 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?

SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?

Operations Day for SQL Server 2008 in UK - for Premier customers

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

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

SQL Server Business Intelligence - adopt sustainable practices on ETL processes with SSIS

64 bit computing configuration with SQL Server 2005 - what you can take-on?

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

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

SharePoint 2007 Conference DUBAI

SQL Server 2005: What percentage of changes happened within the database after the last successful backup?

Most Valueable 'technical' week so far this year, for me - MVP Global summit 2008

SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?

SQL Server problem: Excessive paging and memory bottlenecks

SQL Server 2005 Service Pack 3 - work started

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)

SQL Server Replication - resolving too many snapshots issues?

SQL Server SSIS packages metadata solution pack

SQL Server 2008 - What's new for IT Pro community [UK Usergroup conference]

SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues