Browse by Tags

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!
14 November 09 04:47 AM | ssqa.net | 1 comment(s)

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback...

Filed under: sql server, benefits, best practice, ssms, shortcuts, keyboard

SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance
08 September 09 01:11 PM | ssqa.net | 1 comment(s)

The subject line of this post is a common factor that every DBA might have (once in lifetime). Performance Monitoring is a big subject when it comes to practice, many factors include such as what to monitor, how often more from here ...

Filed under: sql server, performance, best practices, benefits, dba, monitoring, tempdb, dbcc, transaction log, backup

SQL Server 2008 R2 CTP - BOL : refer to documentation to know what's new!
17 August 09 02:49 PM | ssqa.net | with no comments

In response to the SQL Server 2008 R2 CTP post I have had flurry of emails asking what more they can learn on 'What's New' compared to the existing SQL Server 2008 RTM which has celebrated its first birtday! As a general recommendation I always...

Filed under: sql server, documentaiton, download, msdn, benefits, bol, ctp, best practice, web

SQL Server 2000 to 2005 to 2008 Upgrade Technical Reference Guide
05 December 08 09:02 AM | ssqa.net | 1 comment(s)

What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of...

Filed under: sql server, microsoft, best practices, documentaiton, benefits, upgrade

SQL Server 2008 RC0 and 3.5 Compact edition Books Online - download and update your copy
24 June 08 03:22 PM | ssqa.net | with no comments

As in continuation with the latest release of SQL Server 2008 that is Release Candidate , I strongly recommend you update your local copies of SQL Server Books ONline aka BOL. Here is the link to download the latest copy of SQL Server 2008 RC0 BOL - Link_to...

Filed under: sql server, 2008, documentaiton, books online, benefits, bol

SQL Server 2008 Release Candidate - public download is available now
10 June 08 10:32 PM | ssqa.net | with no comments

In the past week SQL Server 2008 RC0 has been made available for early download by MSDN and TechNet Plus subscribers. RC0 is the final step before SQL Server 2008 RTMs in Q3 of this year. After logging into their respective accounts, subscribers can view...

Filed under: sql server, 2008, microsoft, download, benefits, rtm, release candidate, ctp

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

SQL Server Integration Services and Clustering - confguration gotcha to ensure SSIS works with failover of cluster!
17 March 08 01:06 PM | 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. Read more from here.

Filed under: sql server, best practices, configuration, benefits, management studio, multiple, memory, instances, cpu

Microsoft Empower Program - good deal for ISVs
29 February 08 09:29 AM | ssqa.net | with no comments

Microsoft has rolled out new program called - Empower Program that will enable the ISVs to receive software, support and additional resources designed to help you lower your development costs, test your software and speed your solution's time-to-market...

Filed under: sql server, microsoft, windows server, visual studio, licensing, versions, isv, applications, benefits