Browse by Tags

SQL Server multiple instances and resource utilization - best practices
15 May 08 10:48 AM | ssqa.net | with no comments

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System...

Filed under: sql server, resources, performance, best practices, installation, multiple, instances, consolidation, virtualization

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
08 May 08 09:35 AM | ssqa.net | 2 comment(s)

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, cpu, cache, huge, dbcc shrinkfile, monitoring, databases, operating system

SQL Server 2008 February CTP Bug Bash Contest Results
01 May 08 02:17 PM | ssqa.net | with no comments

Contest-Results

Filed under: sql server, microsoft, contest

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
28 April 08 04:28 PM | ssqa.net | 1 comment(s)

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, best practices, database, benefits, data file, sizes, 64k, allocation

How to configure SQL Server Reporting Services in a DMZ environment?
22 April 08 07:27 AM | ssqa.net | with no comments

Many questions will come out if you need set your Reporting Server on Internet within DMZ environment? The important aspects involves SQL Server database, Reports Services & Report Manager, for the sake of discussion say if Report Services and Report...

Filed under: sql server, report builder, reporting services, security, best practices, ssrs, tcp, report server, port, udp, 1433

SQL Server 2008 - What's new for IT Pro community [UK Usergroup conference]
16 April 08 01:22 PM | ssqa.net | with no comments

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. If you are unable to download from SkyDrive then click here . During that conference...

Filed under: sql server, 2008, whats new, conference, features, itpro, presentation

SQL Server 2005 Service Pack 3 - work started
16 April 08 12:26 AM | ssqa.net | with no comments

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: sql server, microsoft, blogs, sp2, service pack, sp3

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)
15 April 08 10:16 PM | ssqa.net | with no comments

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, microsoft, best practices, download, service pack, cumulative update, package, releases

SQL Server Reporting Services - avoid restarting IIS when security groups are added
14 April 08 10:07 AM | ssqa.net | with no comments

You may be aware that using normal method of http://servername/reports will give access to the users and if you grant reporting service permissions using the folder properties security (or report manager) to the Windows groups you might need to restart...

Filed under: sql server, report builder, reporting services, registry, cache, iis

End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?
08 April 08 06:04 AM | ssqa.net | with no comments

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...

Filed under: sql server, 2005, microsoft, product, mainstream, support, extended, 2000, lifecycle

SQL Server Integration Services - think about Transactions and Checkpointing?
07 April 08 07:21 AM | ssqa.net | with no comments

Transactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I'm covering this important task for the sake of newbie & junior DBAs, also the similar question was...

Filed under: sql server, best practices, ssis, setup, package, checkpoint, bol, commit, rollback, dts, ssis package, transaction

MVP Global Summit - where all the attendees are coming from, view map geographically?
31 March 08 07:19 AM | ssqa.net | 3 comment(s)

MVP Global Summit, what it meant for MVPs? At one place, global connections with peers with a shared insight with a flavour of engagement with relevant product manager, sounds terrific isn't it! Who can attend - as per the previous post on MVP Global...

Filed under: sql server, 2008, microsoft, conference, visualisation, mvp, virtual earth, convention, global summit

Webcast 31st March 2008: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform
30 March 08 11:41 AM | ssqa.net | with no comments

Another part of Technet webcast series on SQL Server 2008. In this part a focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity...

Filed under: sql server, 2008, security, technet, trusted platform, data loss, business continuity, high availability, data platform

SQL Server 2008 Express features and variation from previous version
28 March 08 09:26 AM | ssqa.net | with no comments

Flood of questions fromthe users during a recent usergroup meeting. What will the specification for the SQL Server 2008 Express version be? What will be the differences between it and the 2005 version, not with MSDE? How about SQL Agent attachment to...

Filed under: sql server, 2008, 2005, licensing, features, sqlexpress, express, limitation, ram

How to get rowcount efficiently within a SSIS package?
26 March 08 07:51 AM | ssqa.net | with no comments

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components...

Filed under: sql server, performance, ssis, component, package, call, rowcount

More Posts Next page »