SQL Server Integration Services
81 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by Thomas Duclos
Scoop.it!

Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology - SQL Server Team Blog - Site Home - TechNet Blogs

Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology - SQL Server Team Blog - Site Home - TechNet Blogs | SQL Server Integration Services | Scoop.it
Insider news about SQL Server and Microsoft's Information Platform (Nice read !
more...
No comment yet.
Scooped by Thomas Duclos
Scoop.it!

Hardware Considerations for In-Memory OLTP in SQL Server 2014 ...

Insider news about SQL Server and Microsoft's Information Platform.
more...
No comment yet.
Rescooped by Thomas Duclos from IT Books Free Share
Scoop.it!

Microsoft SQL Server 2012 Administration - Free eBook Share

Microsoft SQL Server 2012 Administration - Free eBook Share | SQL Server Integration Services | Scoop.it
eBook Free Download: Microsoft SQL Server 2012 Administration | PDF, EPUB | ISBN: 1118487168 | 2013-06-17 | English | PutLocker

Via Fox eBook
more...
Fox eBook's curator insight, July 14, 2013 9:29 PM

Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

Implement, maintain, and repair SQL Server 2012 databases

As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server’s roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them.

Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certificationExplores the skills you’ll need on the job as a SQL Server 2012 DBADiscusses designing and implementing database solutionsWalks you through administrating, maintaining, and securing SQL Server 2012Addresses implementing high availability and data distributionIncludes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA

Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.

Table of Contents

Part I: Introducing SQL Server 2012
Chapter 1. Understanding SQL Server’s Role
Chapter 2. Installing SQL Server 2012
Chapter 3. Working with the Administration Tools
Chapter 4. SQL Server Command-Line Administration
Chapter 5. Querying SQL Server

Part II: Designing Database Solutions
Chapter 6. Database Concepts and Terminology
Chapter 7. ERD and Capacity Planning
Chapter 8. Normalization and Other Design Issues

Part III: Implementing Database Solutions
Chapter 9. Creating SQL Server Databases
Chapter 10. Creating Tables
Chapter 11. Indexes and Views
Chapter 12. Triggers and Stored Procedures
Chapter 13. Implementing Advanced Features

Part IV: Administering and Maintaining
Chapter 14. Creating Jobs, Operators, and Alerts
Chapter 15. Performance Monitoring and Tuning
Chapter 16. Policy-Based Management
Chapter 17. Backup and Restoration

Part V: SQL Server Security
Chapter 18. Security Threats and Principles
Chapter 19. Authentication and Encryption
Chapter 20. Security Best Practices
Chapter 21. AlwaysOn and High Availability
Chapter 22. SQL Server Failover Clustering
Chapter 23. Database Mirroring and Snapshots
Chapter 24. Implementing Replication

Part VII: Implementing Business Intelligence and Reporting
Chapter 25. Data Warehousing
Chapter 26. SQL Server Integration Services
Chapter 27. Data Quality Solutions

Appendices
Appendix A. Microsoft’s Certification Program
Appendix B. About the Additional Study Tools

BornToDoIt's curator insight, December 30, 2015 6:48 AM

gg

cristian12351235's curator insight, September 20, 8:29 AM
Share your insight
Scooped by Thomas Duclos
Scoop.it!

Update: Microsoft's Office 365 uptime exceeds 99.9%

Update: Microsoft's Office 365 uptime exceeds 99.9% | SQL Server Integration Services | Scoop.it
Dropping the veil of secrecy over Office 365 uptime, Microsoft has released availability data for each of the past four quarters and is celebrating the results.
more...
No comment yet.
Rescooped by Thomas Duclos from IT Books Free Share
Scoop.it!

Microsoft SQL Server 2012 Step by Step - Free eBook Share

Microsoft SQL Server 2012 Step by Step - Free eBook Share | SQL Server Integration Services | Scoop.it
eBook Free Download: Microsoft SQL Server 2012 Step by Step | PDF, EPUB | ISBN: 0735663866 | 2013-03-04 | English | PutLocker

Via Fox eBook
more...
Fox eBook's curator insight, July 29, 2013 9:31 PM

Your hands-on, step-by-step guide to building applications with Microsoft® SQL Server® 2012

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Discover how to:

  • Install and work with core components and tools
  • Create tables and index structures
  • Manipulate and retrieve data
  • Secure, manage, back up, and recover databases
  • Apply techniques for building high-performing applications
  • Use clustering, database mirroring, and log shipping
Table of Contents

Part I: Getting started with Microsoft SQL Server 2012
Chapter 1. Overview of Microsoft SQL Server 2012
Chapter 2. Installing, Configuring, and Upgrading Microsoft SQL Server 2012
Chapter 3. Using SQL Server 2012 administration and development tools

Part II: Designing databases
Chapter 4. Designing SQL Server databases
Chapter 5. Creating your first table
Chapter 6. Building and maintaining indexes

Part III: Advanced database design topics
Chapter 7. Table compression
Chapter 8. Table partitioning
Chapter 9. Database snapshots
Chapter 10. The SELECT statement

Part IV: Using Transact-SQL (T-SQL)
Chapter 11. Advanced data retrieval topics
Chapter 12. Modifying data
Chapter 13. Built-in scalar functions

Part V: Creating other database objects
Chapter 14. Advanced T-SQL topics
Chapter 15. Views
Chapter 16. User-defined functions
Chapter 17. Stored procedures
Chapter 18. Data manipulation triggers

Part VI: SQL Server replication
Chapter 19. Replication

Part VII: Database maintenance
Chapter 20. Backups
Chapter 21. Managing and maintaining indexes and statistics
Chapter 22. Maintenance plans

Part VIII: Database management
Chapter 23. SQL Server Profiler
Chapter 24. Extended Events
Chapter 25. SQL Server security
Chapter 26. Resource Governor
Chapter 27. SQL Server Agent
Chapter 28. Database Mail
Chapter 29. Data definition triggers
Chapter 30. Dynamic management objects

Part IX: High-availability solutions
Chapter 31. AlwaysOn
Chapter 32. Log shipping

Joel Warner's curator insight, October 1, 2014 3:01 AM

Useful book for any Tech..