Browse by Tags

All Tags » documentation (RSS)
How to write or deploy Secure Transact-SQL - gotchas & tips?
Published 18 September 8 2:16 AM | 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...
Filed under: , , , , , , ,
Technical Rollup email pertaining to SQL Server, documents & guidelines
Published 3 September 8 3:59 AM | SSQA.net
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...
Filed under: , , , ,
Unable to install SQL Server 2008 RC0 Books Online
Published 26 June 8 4:54 AM | SSQA.net
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...
Filed under: , , , , ,
SQL Server 2008 RC0 and 3.5 Compact edition Books Online - download and update your copy
Published 24 June 8 8:3 AM | SSQA.net
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...
Filed under: , , ,
SQL Server 2008 Release Candidate - public download is available now.
Published 10 June 8 5:36 AM | SSQA.net
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...
Filed under: , , , , , ,
SQL Server 2008 release, 1st anniversary and it is CTP I'm talking!
Published 2 June 8 3:9 AM | SSQA.net
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 '...
Filed under: , , , , , , ,
SQL Server 2008 and simplified scripting through PowerShell
Published 9 May 8 4:45 AM | SSQA.net
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...
Filed under: , , , , , , ,
SQL Server 2000 Books Online updated, now available for local download
Published 29 September 7 11:57 AM | SSQA.net
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...
Filed under: , , , , , ,
SQL Server 2005 Books Online update - September 2007 on MSDN & Technet
Published 29 September 7 9:49 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
Shall I drop pubs and northwinds databases, how about Adventureworks?
Published 21 June 7 3:36 AM | SSQA.net
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...
Filed under: , , , , , ,
Install Books online only for SQL 2008 (Katmai)
Published 12 June 7 5:10 AM | SSQA.net
Few out there are still not comfortable to install or test the SQL 2008 (Katmai) as SQL 2005 is still new in the field and users are getting eventually hands-on experience. So in order to get hands on for the documentation 'only' for SQL 2008...
Filed under: , , , ,
SQL Server 2005 Books online May 2007 updates are available now
Published 11 June 7 3:22 AM | SSQA.net
Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For...
Filed under: , , , , ,
Changes to SQL Server TechCenter
Published 30 May 7 8:45 AM | SSQA.net
You might have observed or not there is a change in the MSDN documentation User Interface (UI) and the way it is connected with regard to the feedback from the user. Well SQL Server TechCenter has been given a new look with an UI face-off in addition...
Filed under: , , , , , , , ,
Behaviour of SP_READERRORLOG in SQL 2000 and 2005
Published 22 May 7 3:3 AM | SSQA.net
You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that...
Filed under: , , , , , , ,