I do enjoy using application roles and find that many of the defined fixed roles are quite useful, and where they are not adequate at the database level, I am able to create user-defined database roles.
Are there any key features to SQL Server that you feel are too often overlooked or underutilized? I have seen, over and over in SQL Server shops, that capacity planning and scalability concerns is an abused, or even forgotten function. This turn the SQL Server software installation onto a non-robust, incorrectly configured server class system that is not scalable or tunable.
- Rick Sawtell (Author of Sams Teach Yourself Microsoft SQL Server 7 in 21 Days).
- Top SQL Server Books!
- Other titles you might like?
- Behind Every Good Decision: How Anyone Can Use Business Analytics to Turn Data Into Profitable Insight.
- Best SQL server books.
- Livres en anglais.
What do you think is the most important thing that a new DBA should learn? How do you see the role of a DBA changing over the next few years? Reprinted with written permission of the author. Copyright General DBA. No comments yet Be the first to leave a reply!
Linsebardt Mark Stigler Shane Linsenbardt Mark a - AbeBooks
Leave a Reply Click here to cancel reply. Popular Latest Tags. Used properly, SQL Server can help organizations of all sizes meet their data challenges head on.
It guides you through all the new features, explaining how they work and how to use them. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C and compiled using the Visual Studio development environment-that show you exactly how to program SQL Server The book can be used as a primer by developers with little or no experience with SQL Server, as a ramp up to the new programming models for SQL Server for more experienced programmers, or as background and primer to specific concepts.
NET 2. Ce livre est quelque peu en retard de C'est dinausorien!!!!!! Programming SQL Server Hancock, Roger Toren.
In this book, two of Microsoft's leading consultants illustrate how to use SQL Server Business Intelligence BI technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft's strategic customers, John C.
- Emergency Planning for Industrial Hazards?
- Workflow Management with SAP® WebFlow® : A Practical Manual!
- Walking Dead Weekly #26!
- ALS Microsoft SQL Server 2000 System Administration.
- Microsoft SQL Server 2000, Das Handbuch, m. CD-ROM : Das ganze Softwarewissen?
- Interest Rate Risk Modeling: The Fixed Income Valuation Course (Wiley Finance);
Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management. Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform.
Inside SQL Server 2000. 2 CD-ROM included eBook
Each chapter-length case study begins with the customer's business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You'll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation.
Whether you're a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you'll need to derive maximum business value from any BI project. Proposition de solution. Solution technique : mise en oeuvre avec un produit Microsoft. Gestion de la solution : comment maintenir la solution dans le temps. Hancock et Roger Toren.
This step-by-step, hands on guide will take you right into the Visual Studio Integrated Development Interface making you appreciate and understand how Business Intelligence Projects and Packages are created using the Visual Studio designer. This does not mean that it is just an improvement over DTS but a product which is totally different with a vastly improved interface; an extensible architecture; an enlarged tool set; ease of integration with other SQL Server Tools such as Analysis Services; capable of supporting connectivity with third party databases and bringing into a central location many database management tasks.
The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer.