Microsoft SQL Server is an enterprise database server that is the cornerstone of modern business applications, and is at the centre of the business processes of many leading organizations. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. A variety of new in-memory features enable you to design high performance database applications that can improve the performance of your applications, making them as much as ten times more efficient in some cases.
Whether you are thinking about becoming a database developer, architect, or administrator, or you are a seasoned database expert, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2014. Starting from the beginning, this book gives you an insight into the key stages of the SQL Server database process, provides in-depth knowledge of SQL Server database architecture, and provides you with tips to design new databases. By sequentially working through the steps in each chapter, you will gain hands-on experience of designing, creating, and deploying SQL Server databases and objects. You will learn how to use SQL Server 2014 Management Studio and advanced Transact-SQL queries to retrieve data from SQL Server databases. You will also learn how to add, modify, and delete data stored within a database. You will use Transact-SQL statements to create and manage advanced database objects that include scalar and table-valued functions, views, stored procedures, and triggers. Finally, you will learn about how SQL Server works, how indexes and statistics improve query performance, and the new SQL Server 2014 in-memory technologies.
|Product dimensions:||7.50(w) x 9.25(h) x 0.45(d)|
About the Author
Basit A. Masood-Al-Farooq is an internationally-known lead SQL DBA, trainer, and technical author with 12 years of experience of the Microsoft technology stack. He is an accomplished development and production SQL Server DBA, with a proven record of delivering major projects on time and within budget. He is an expert at evaluating clients’ needs against the capabilities of the SQL Server product set, with the objective of minimizing cost and maximizing function through making innovative use of advanced capabilities. Basit has authored numerous SQL Server technical articles on various SQL Server topics for different SQL Server community sites, including SQLMag.com, MSSQLTips.com, SQLServerCentral.com, SSWUG.org, SQL-Server-Performance.com, and SearchSQLServer.com. He has also developed and implemented many successful database infrastructures, data warehouses, and business intelligence projects. He holds a Master's degree in Computer Science from London Metropolitan University and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft, and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000, and MCTS .NET Framework 2.0 Web Applications. He also has a good understanding of ITIL principals. He can be reached via Twitter (@BasitAali), his blog (http://basitaalishan.com), or via LinkedIn. His LinkedIn profile address is http://uk.linkedin.com/in/basitfarooq.