|
|
Browse by Tags
All Tags » bol ( RSS)
-
|
In many case within the forums and newsgroups I still see many questions from the users asking about SSIS (SQL Serve Integration Services) and here few bits I'm covering on basics on this important service in SQL Server arena. SSIS is a key part of...
|
-
|
From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News...
|
-
|
Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
|
|