Browse by Tags

All Tags » sql server » best practices » microsoft (RSS)
MSDN & Technet webcast for SQL Server 2008 and SQL Server Compact 3.5 versions
Published 3 September 8 4:4 PM | SSQA.net
TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change...
Filed under: , , , , , , , ,
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 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 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 Open World - 2008, mark your diaries
Published 5 March 8 4:3 PM | SSQA.net
Wow, its almost one year for me to talk about SQL Server Open World! Last year I have given 2 presentations on Effective usage of Database Mirroring & Business Continuity mesaures & practices, blog posts here for a reference: http://sqlserver...
Filed under: , , , , , , , ,
SQL Server 2005 Best Practices Analyzer January 2008 update
Published 25 January 8 4:8 AM | SSQA.net
Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings...
Filed under: , , , , , , , , , ,
Vote now: Index defragmentation best practices for SQL Server 2005 documentation - feedback received from Microsoft
Published 4 January 8 5:35 PM | SSQA.net
May 25 2007- From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...
Filed under: , , , , , , , ,
What are advantages of 64-bit system in relation to SQL Server?
Published 19 December 7 8:40 AM | SSQA.net
We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has...
Filed under: , , , , , , , , , , , , ,
Want to see Paul S Randal and Kimberley presentation extract?
Published 13 December 7 10:18 AM | SSQA.net
This will be an interesting news for all the SQL Server users and any conference attendees about Paul Randal & Kimberly, may be you or your friend might have asked one of them whether they are writing a book or have any extracts of their presentation...
Filed under: , , , , , , ,
SQL Server Replication - presentation from Scottish Area SQL Server User Group
Published 12 December 7 4:4 PM | SSQA.net
As a part of regular monthly meetings from Scottish Area SQL Server user group [ Scottish Area SQL Server User Group: Wednesday 12th December 18:30 - 21:00 : Edinburgh ] I have given a presentation on SQL Server Replication, type of SQL Server Replication...
Filed under: , , , , , , , ,
Windows Vista SP1 Release Candidate Announcement
Published 6 December 7 12:32 PM | SSQA.net
Windows Vista SP1 RC is released on 05th December to the Beta Testers on the Microsoft-Connect and on 06th December it is available via MSDN and TechNet subscribers. Few things if you want to know about Vista SP1 RC refer to the following notes from Microsoft...
Filed under: , , , , , , , ,
How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?
Published 23 November 7 8:51 AM | SSQA.net
Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & http://sqlserver-qa.net/blogs/tools/archive/2007...
Filed under: , , , , , , , , ,
Development environment for SQL Server databases, gotchas!
Published 9 November 7 4:35 PM | SSQA.net
Do you have any criteria for your Development Environment within the SQL Server platform? Do you perform end-to-end testing whenever a new hotfix or service pack needs to be applied on the SQL Server? So think about having seperate Database Development...
Filed under: , , , , , , , ,
How to find whether that service pack file is a 32 bit or 64 bit?
Published 1 November 7 6:44 AM | SSQA.net
Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...
Filed under: , , , , , , , , , ,
Vote now: Index defragmentation best practices for SQL Server 2005
Published 25 May 7 6:35 PM | SSQA.net
From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...
Filed under: , , , ,