Browse by Tags

All Tags » article (RSS)
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 2008 - TSQL behavioural changes and enhancements
Published 31 March 8 2:0 PM | SSQA.net
As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...
Filed under: , , , , , , ,
SQL Server license with multi-core CPU technology, confusing concepts?
Published 20 February 8 2:47 AM | SSQA.net
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology...
Filed under: , , , , , , , , , , ,
SQL Server licensing with having multi-core CPU technology, confusing concepts?
Published 19 February 8 2:47 AM | SSQA.net
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology...
Filed under: , , , , , , , , , , ,
SQL Server Lockdown - Step by Step procedure
Published 13 February 8 2:31 AM | SSQA.net
Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices...
Filed under: , , , , , , , , , ,
Keep Everything Clear of the Doors - get safe online
Published 14 December 7 1:52 AM | SSQA.net
Security, whether it is for your home or systems you have to be very careful! Ed Gibson, Chief Cyber Security Advisor from Microsoft has articulated very nice article that will talk more about these aspects, we have had a brief meeting with Ed when I...
Filed under: , , , , , , ,
Can we do logshipping from sql 2005 to 2000? How it is different between 2 SQL versions?
Published 27 September 7 7:17 AM | SSQA.net
This was the question asked by one of the user in the forums. Precisely the answer is no, as you cannot restore a log or database from SQL 2005 to 2000 version due to the differences in the design. Moreover for the sake of high availability the method...
Filed under: , , , , , ,
SQL Server 2005 unable to shrink the transaction log, help? (peculiar issue)
Published 15 June 7 5:19 PM | SSQA.net
On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located...
Filed under: , , , , , ,
What's about KBA's blog here?
Published 22 May 7 12:34 PM | SSQA.net
I'm a big fan and follower of Microsoft Knowledge Base Article which I call them 'KBA' at all the times. If you are beginner in Microsoft technologies then these KBAs are nothing but the support engineers regularly document the solutions to...
Filed under: , , ,