Browse by Tags

All Tags » blogs (RSS)
Cumulative Update 8 package for SQL Server 2005 Service Pack2
Published 16 July 8 4:50 AM | SSQA.net
I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...
Filed under: , , , , , ,
SQL Injection attacks - don't forget to visit guidance information from Microsoft
Published 31 May 8 3:59 PM | SSQA.net
One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding...
Filed under: , , , , , , ,
SQL Server CTP6 Error FILESTREAM feature is disabled - save your day!
Published 16 May 8 9:16 AM | SSQA.net
I have had annoying moment when I'm trying to restore the sample database AdventureWorks on the test database server that consists SQL Server 2008 CTP6 and previous to this I have tried bits and pieces on FILESTREAM, but it seems CTP6 has changed...
Filed under: , ,
SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?
Published 14 May 8 3:23 AM | SSQA.net
I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...
Filed under: , , , , , , , , ,
Most popular blog posts since we started blogs here: sqlserver-qa.net
Published 12 May 8 4:30 PM | SSQA.net
Post Subject Post Views Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' 4,845 SQL Server 2005 & 2000 - Index optimization best practices 4,425 SQL Server 2005 - Ad hoc updates to system...
Filed under: , ,
SQL Server databases - checkpoint, cache and I/O request - what you need to know?
Published 22 April 8 1:51 PM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?
Published 21 April 8 3:1 AM | SSQA.net
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...
Filed under: , , , , , , , ,
SQL Server 2005 Service Pack 3 - work started
Published 15 April 8 4:37 PM | SSQA.net
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: , , , , ,
Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)
Published 15 April 8 3:58 PM | SSQA.net
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 2008 TSQL enhancements - what I like?
Published 4 April 8 9:58 AM | SSQA.net
Simple, short and crisp - I would like to say about TSQL enhancements within SQL Server 2008. You may already aware about what's new and how best you can take advantage within your code, most of the Developers would agree about IntelliSense functionality...
Filed under: , , , , , , , , ,
What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
Published 26 March 8 3:1 AM | SSQA.net
Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...
Filed under: , , , , , , , , , , ,
Various blog links for sharepoint and office products
Published 19 March 8 7:32 AM | SSQA.net
Though I'm an expert within SQL Server arena, sometimes I find it bit difficult when the sharepoint database are involved with an added flavour of performance issues within this farm. So in this regard recently I have been searching through the web...
Filed under: , , , , ,
SQL Server 2008 - What's new and what's coming up!
Published 17 March 8 3:11 AM | SSQA.net
You may be aware that MVP s have the advantage of getting to know about the product information before it is let to the user community, that is the main advantage (I feel) to make the most of MVP award experience, Microsoft keeps MVPs informed of award...
Filed under: , , , , , , , ,
SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?
Published 29 February 8 4:4 AM | SSQA.net
Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the...
Filed under: , , , , , , , , ,
Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!
Published 27 February 8 2:1 AM | SSQA.net
I have been following Dan Jones's blog on " Launch_T-1 , Launch_T-3 & Launch_T-5 " series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as...
Filed under: , , , , , , , , ,
How long DBCC CHECKDB process runs on SQL Server instance?
Published 14 February 8 5:43 AM | SSQA.net
In order to keepup the database logical and physical integrity of all the objects, you must run the DBCC statement such as DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG. Overall you can do this with another statement DBCC CHECKDB that will avoid...
Filed under: , , , , , , ,
See how Resource Governor can help you 'in action' in managing SQL Server resources?
Published 8 February 8 2:11 AM | SSQA.net
As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of...
Filed under: , , , , , , ,
SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?
Published 5 February 8 2:57 AM | SSQA.net
SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question...
Filed under: , , , , , , , , , ,
Security best practices - personally & technically
Published 26 January 8 8:12 AM | SSQA.net
See this awesome post about how best you can adopt security and beaware about which is right and which is wrong Avoiding the bad guys - detecting potentially malicious advertising campaigns that is applicable on both personal security & techinical...
Filed under: , , , , ,
SQL Server indexing - when to reorganize or rebuild?
Published 21 January 8 4:30 AM | SSQA.net
Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...
Filed under: , , , , , , , , , ,
More Posts Next page »