SqlServer-QA.net

I have been thiking to write this topic in this blog since last 3 months, before that I have done fair amount of work to get you sensible & helpful resource in securing your SQL Server environment.  This was the question asked by one of the user when there was a discussion about securing the SQL Server code. The obvious answer is yes ...

Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test and apply to your production environment.  SQL Server 2008 Report Builder 2.0 ...

In continuation with the BOL update topic on SQL2008-RC0_BOL post here I have had troubles in installing the RC0 Books Online on to my laptop. As per the error below I thought it may be problem with the Windows Installer service on my laptop (Vista Ultimate) and tried to install afresh on a central monitoring server (Windows 2003 server) ...

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-Download and also I recommend the SQL Server 2008 ...

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 Product Keys and download SQL Server 2008 RC0 from the following links: MSDN subscribers: ...

It is 1 year (first anniversary) that SQL Server 2008 Community Technology Preview is released, I have seen many good things and few peeves about this new version of SQL Server. Not to mention about largest conference is lined up for the users aka 'Tech-ed 2008' which is a huge learning opportunity too. So what you have learned from last 4 ...

Have you ever seen or used the PowerShell? If so have you worked on PowerShell within SQL Server 2008, it has 2 kinds of snap-ins that are called as Powershell Provider and set of Cmdlets. The provider will enables the simple navigation mechanism similar to file system paths, within that associated to SQL management object model and ...

SQL Server User Education blog on MSDN has this update about SQL Server 2000 BOL Update - Don't forget to update your local version copy with this latest release. You can download the updated SQL Server 2000 Books Online from the Microsoft Download Center. .

SQL Server version 2005 Books Online aka BOL has been updated by SQL Development Team in September 2007 and not available for download yet. As usual they are awaiting customer feedback from the BOL or via MSDN/Technet pages. Refer in their words: In the past, our processes for building the Books Online downloads have been faster than the ...

As you may be aware SQL Server installation (70 & 2000) will automatically install the sample databases pubs and northwind, if you aren't using them or not a training institute then simply drop them. Whereas this behaviour is changed in SQL Server 2005 as the Northwind and pubs sample databases are not installed by default in ...