Database Books And Whitepapers
Jul 20, 2005Does anyone know of a good book or white papers that compare the relative
strengths, capabilities and features of databases like SQL*Server, Oracle,
Informix, MySQL etc? Thanks.
ADVERTISEMENT
Differences Between 2005, 2000, And Express - Documentation, Whitepapers?
Apr 27, 2007Can anyone point me in the direction of some NON-sales documentation on the differences between these product? I am sure, especially with Express, there are considerable functionality and architecture differences.
I've looked in BOL, and I've done searches online.
All i seem to get is sales related stuff.
I'm curious about the architecture of SQL 2005, SQL express. In 2000, there was some fairly detailed documentaiton on this subject, but 2005 BOL seems REALLY diffucult to find things.
I may just need to try different keywords...
Books In Spanish For Database Design And Normalisation?
Oct 22, 2007Hi,Can anyone recommend books in Spanish for Database Design andNormalisation?¿Puede alguien recomendar libros en español para Diseño de Base dedatos y Normalización?Thanks,Michael HolbertonHospedaje Los Jardines & Sacred Valley Mountain Bike ToursCusco Database Development and Cycling Serviceshttp://www.machawasi.com/http://machawasi.blogspot.com/http://databaseservices.blogspot.com
View 1 Replies View RelatedAny Good Whitepapers On Security/deployment For Entire SQL Server BI Solutions?
Aug 1, 2007At my current employer we are struggling with the best way to manage security and deployment of a project that contains databases, SSIS, SSAS and SSRS components, using configurations.
Environment (Dev):
3 SQL Server databases, all using mixed-mode security, using SQL Server security credentials.
12 SSIS packages; one master package, eleven child packages, 3 shared data sources
1 SSAS database; one cube, 15 dimensions, three referenced data sources from the SSIS project (in same solution)
6 SSRS reports, one data source to cube (not shared- doesn't appear SSRS can share datasources among other projects in the solution? Why?)
Everything runs fine in development. Now comes the tricky part.
Deploying SSIS and SSAS into production environments:
-Packages use XML config files for connection strings to three relational data sources.
-Deploy to SQL Server storage. Deploy wizard copies package dependencies (including XML config files) to default location set in INI file. When I do this, no config file shows up in remote server (remote server not set up identical to local, so directory does not exist. Need UNC path?) So, being a developer with no "special" permissions on the PROD server, what security permissions is allowing the deployment wizard from copying files to this location on a production server?
-Using a deploy script using dtutil doesn't copy the SSIS dependencies. Is this matter of using COPY or XCOPY to copy the configuration files to the dependency location? Again, in real-world practice, do developers typically change this location in the INI file to another location, or stick with the default. In either case, how does security work that allows files to get copied to the remote folder? (i.e. manual, or SQL Server manages this file folder permission through some other magic)
When using SSMS and running the package after being deployed on the remote server, if the config path is the default (e.g. C:program filesMicrosoft SQL Server90DTSPackages...) it appears to be read from the local machines directory rather than the remote machines directory path (do I need to use UNC paths? The wizard doesn't give this option it seems)
-When scheduling the job from SQL Agent, does the proxy account need permissions to the folder the config files sit in?
-What about the roles security on the packages themselves? Where does the server roles come into play (dtsltuser, dtsadmin)
-Because the SSAS project uses connection references to the SSIS project in BIDS, and SSIS project uses configurations, will SSAS pick up on these connections?
-What about impersonation levels for SSAS? Leave all data sources set to default, and set the database impersonation level to "UseServiceAccount"? What if the developer is not the same as the OLAP administrator on the production server? In this case, Use Service Account isn't an option, and neither is the current users credentials.
-SSAS database also has security for Full Control, but still doesn't prevent security at the data source level within the database (talking about impersonation level, not source db credentials)
-How can SSRS connections leverage other shared connections?
As you can see, there are a ton of security considerations, none of which are intuitive and can be configured multiple ways and actually work (and a ton of ways that won't work).
I need a simple cheat-sheet about each step to take to configure this so multiple developers can work without interruption, hot-deploying SSIS, SSAS, and SSRS changes into different environments (QA, PROD).
-Kory
FAQ: Are There Any Whitepapers About Building A Disaster Recovery Site At A Remote Location For SQL Server 2000
Sep 9, 2006Hi,
Sorry for the wide distribution.
I'm trying to find any useful whitepapers about how to effectively build and operate a disaster recovery site at a remote location for SQL Server 2000. Does anyone know where to find such information?
I also know that one good option for my customer is using the Mirroring feature of SQL Server 2005. What are the other options? Is Replication an effective one for a mission-critical database (online banking)?
Thanks in advance
Books
Sep 2, 2004any all-rounder good book on SQL Server
View 1 Replies View RelatedSQL Books
Aug 11, 1999I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedSQL Books
Aug 11, 1999I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedSql Books
Feb 5, 2002Hi,
I have to buy two books for the MIS dept for sql server 2000. Which one do you recommend? We are still on sql 7.0 and migrating to 2000 soon. All developers have good experience with sql server 7.0.
Want something that gives you recommendation about better practices for performance issues for writing SPs.
I read all the reviews on amazon and b&N . It's confusing to choose only two.
Any recommendations?
Books
Sep 20, 2001Can Anyone tell where I can found a tutorial about Transact-SQL ?
Thanks
Books SQL
Sep 2, 2004Hello, I wish SQL' Books.
Anyone help me..
Bye :rolleyes:
Sql Books
Jul 20, 2005hipls tell the site's where i can download free e-books,bye,s.premkumar
View 1 Replies View RelatedBooks
May 21, 2007Hi , i am new to certifications in general..
I would like to do the certification exam 70-431. However i want to study on my own instead of going to classes.
what if i get the microsoft e-learning books or microsoft press books? will this be enough in helpnig me with the course requirements?
what are the difference between the two e-learning and MS Press books?
Books On Line
Aug 7, 2001Hi,
I just started at a client's site and have found that the Books On Line has been removed (all other items are there in the program group instead of BOL). Is there a site at microsoft that mimicks BOL? (sybase has a 'sybooks on the web' which mimicks their 'Sybooks' product documentation.
Any help would be appreciated.
jim
Books On SQL Administrations
Feb 28, 2000Hi
I am looking for books on SQL 7.0 Administration. I would appreciate if any body could recomend.
regards
rajeev
Books - For SQL Server 7.0 DTS
Nov 3, 2000Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
Any Good DTS Books
Sep 30, 2002Does anyone know of any good books on DTS? I am currently using SQL 7.
Thanks in advance
Any Good Books
Sep 14, 1998Hi there,
Any good books to Know the internals of MS-SQL server 6.5
Thanks
Vivek
Books Online
Aug 10, 2005How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
Thanks!
CD, Books, Sites
May 24, 2006naresh writes "I would like to learn sql server 2000 and I do not have any programming experienc at all so how do i learn this programme. Do you have any suggestion or any basic books or materials you guys can refer to me
Thank you"
Nice Books?
Jun 14, 2006hi guys,
i m a newbee in SQL. i wanted to know which is the nice book to start with? anyone got ebooks of SQL2005?
Ref: Books/webcast On ETL
Oct 9, 2006we are trying to build warehouse in our company its very small database but still.
we have come to a point where we are able to pull reports from the database that we have created as OLTP which is truncated and reloading everyday .
Now we have to stop doing that and just update the database and check for the changes in the existing data.
Can anyone suggest ETL book/webcast/weblinks that could help me.
Thanks in advance
Srini
Wrox SQL Books
Apr 2, 2007Ok I found these two books
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764589237.html
and this one
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584332.html
Could someone explain the difference between these 2 books besides the fact that one is geared towards the express edition. The SQL Programming book sounds more thorough than the Express Edition book.
Suggestions For Books
Aug 15, 2006I would be teaching an applied database course to buisness majorundergrads. I'm looking for a book that introduces database conceptsusing SQLServer as the database. I would really appreciate if you couldrecommend me a few such books.ThanksNemo
View 4 Replies View RelatedSSIS Books
Apr 2, 2007Hi,
I am new to SSIS and wondered if there are any books around to learn in depth regarding SSIS and exampls for transformation to try and help me understand it better.
If anybody knows any guide, please let me know
Aash.
Books For SSIS
Sep 12, 2006Hi,
Please give the Microsoft suggested book material list for learning SSIS
Thanks & Regards
S.Nagarajan
Recommended Books
Aug 22, 2005Can somebody recoommend me books for sql server 2005. I am interested specially in CLR inside sql and Business Intelligence.
View 4 Replies View RelatedBooks, Articles About ETL
Apr 22, 2008
Hello,
maybe anyone knows good books or articles about ETL, ETL processes, ETL optimization ?
If you know where i can download - post a link
Thanks
AS 2005 References/Books
May 4, 2007Hi All -
I have come across the need to use a cube in AS 2005 for an application. Unfortunately this will be the first time writting an ASP.Net application which uses one. I was wondering if any of you had any good books or references that I could look at to get an idea of how I should approach this issue.
Thanks in advance.
Books For SQL Warehousing Exam?
Jan 4, 2001Can anybody suggest a couple of good books to use to prepare for the SQL Data Warehousing exam (70-019)? I'm starting to get ready for that exam to complete my MCDBA and was wondering if anybody had any good recommendations or those to stay away from.
Thanks for any help that you can provide in this matter.
Tom
HELP ? Good Books To Read !!
Mar 16, 1999Sorry if this has been posted before, but I performed a search on the archives and didn't find anything !
I have just been turned over a SQL 6.5 SP3 / NT 4.0 SP3 server that has several SQL errors in the event log. I need to find a good book to read/scan, so I can get up to speed on SQL.
Thanks,
Mike Givens MCSE
mikeg@iowa.com
Online Books / Tutorials
Aug 2, 2002Hi All...
Can anyone guide me to a place where I can download some Tutorials / Books (Not that new) covering Microsoft SQL 2000 essentials ? I tried to find here, but artices are too advanced for me.. I need something that covers the Basic and that could be used as a small reference/guide while I am learing...
Thanks to ALL
Recommended Books For SQL 2000?
Jul 20, 2001I have a couple of years of light experience with SQL server. I'd like to start studying to take the SQL 2000 exams. I have a good test environment set up and I'm reading through the Books Online. Can anyone recommend a book or books that might be helpful for me? My end goal here is to pass the test in the near future, but I want to really learn SQL rather than just learn to pass the test.
Thanks,
Allie