SqlServer-QA.net

Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window in terms of 24/7 usage. By default you can enable of disable this PAGE_VERIFY option by ...

You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage.  No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present? issues to resolve. Just to talk in list of documentation, SQL Server Express makes ...

After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet premium subscribers all over the world were attempting the same. Ok, I have got ...

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 951217 here. Obviously this is for the installations that will have SQL Server 2005 SP2 and ...

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 security-related configuration settings since the good & bad times of SQL Server version 2000, ...

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 it all the way. So then the day is saved (Thanks to Bob Beauchemin) from the Configuring ...

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 product milestones for SQL Server.  Microsoft is excited to deliver a feature ...

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 ...

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 occur in a database the changes are formed as transactions that are held in buffer pool ...

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 backup sequence comes the database RECOVERY model comes as another important ...