Browse by Tags

All Tags » BOL (RSS)
SQL Server 2008 - Replication and Filestream, are both supported together?
Published 26 May 8 4:1 AM | SSQA.net
Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every...
Filed under: , , , , ,
SQL Server Integration Services (SSIS) - learning materials and web resources for beginners
Published 7 April 8 5:38 AM | SSQA.net
Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs...
Filed under: , , , , , , , , ,
Let a user with minimal privileges see another user, simple with TSQL - SQL Server 2005
Published 11 March 8 7:5 PM | SSQA.net
You may be aware that by default, users that have minimal privileges cannot see other users in the sys.database_principals and sys.server_principals catalog views. This means that a user with minimal privileges that owns a table cannot see other users...
Filed under: , , , , , ,
SQL Server logins - enforce Password Expiration and policies
Published 7 January 8 1:11 PM | SSQA.net
Here is a quick snippet on enabling a SQL login to password expiration and password policies as per the Windows server: Open the SQL Server 2005 Management Studio. In the left pane, go to the desired server and navigate to the Security folder and expand...
Filed under: , , , , , , , , , ,
SQL Server Reporting Services - Do you cache popular reports for better performance?
Published 7 January 8 5:30 AM | SSQA.net
Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required...
Filed under: , , , , , , , , , , , ,
SQL Server 2005 Books Online September 2007 available for download - update your local copy
Published 18 December 7 4:25 AM | SSQA.net
As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will...
Filed under: , , , , , , , ,
SQL Server 2005 ETL process - made simple and easy to learn with SSIS tutorials
Published 5 November 7 9:47 AM | SSQA.net
Still most of the users in SQL Server 2005 are afraid of using SSIS - SQL Server Integration Services for their ETL process and procedures. I would say the newbie users are in luck to obtain help easily on the web by referring to the blogs and forums...
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: , , , , , , , , , ,
Is SQL Server 2005 Books Online updated in September 2007?
Published 28 September 7 4:38 AM | SSQA.net
Well this is confusing me, this DownloadLink refers SQL Server 2005 Books Online as May 2007 update that can be installed on the machine. But when you search for any content on MSDN library for SQL Server it refers " SQL Server 2005 Books Online...
Filed under: , , , , ,
Getting Started with SQL Server 2008
Published 7 September 7 4:53 AM | SSQA.net
Recently I have had few emails asking about how to get hands-on in SQL Server 2008. As of now still July 2008 CTP is available to download as per this OtherBlogPost. Further as usual I would suggest the SQL 2008 'newbie' to review the books online...
Filed under: , , , , , ,
SQL Server Books Online update with July 2007 CTP
Published 1 August 7 3:16 AM | SSQA.net
By now you are aware that July 2007 CTP for SQL Server 2008 is available to download, if you are not ready to test this installation even you can take a tour by referring to the BOL for July CTP. Exclusive Link to download BOL only. As you can see above...
Filed under: , , , ,
SQL Server 2008 Books Online: How to find out what features are in a CTP release
Published 20 July 7 4:41 AM | SSQA.net
Whenever a CTP release is available it is best to refer to the documentation to know about t he features that are available in this CTP are documented. In this case ensure you have downloaded the Books Online from that CTP release and open the BOL then...
Filed under: , , , , ,
No more sample databases and applications are included with SQL Server installation!
Published 6 July 7 12:8 PM | SSQA.net
As you have seen since SQL Server 2005 release the sample databases are not included and as I mentioned in SampleDBs blog you have to download from the SQL Server Samples Web site. Also SQL 2008 BOL will no longer include the databases & applications...
Filed under: , , , ,
Books Online topics in SQL 2008 (Katmai) are incomplete!
Published 15 June 7 3:41 PM | SSQA.net
One of our Developer asked me this question that they are unable to find complete informaiton about the compatibility between SQL 2000, 2005 and 2008 versions. The answer is yes, its obvious and don't worry this is a temporary feature as the current...
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: , , , , ,
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: , , , , , , ,