intro to sql
TRANSCRIPT
![Page 1: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/1.jpg)
Introduction to SQL Server
By: Paresh MotiwalaSQL Solutions Architect
Twitter:@pareshmotiwalaLinked In: www.linkedin.com/in/pareshmotiwala
Tuesday, March 24, 2015
![Page 2: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/2.jpg)
By: Paresh MotiwalaSQL Solutions Architect
![Page 3: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/3.jpg)
Introduction to SQL Server• History• What’s new in SQL 2014• Client/Server• Components of SQL Server• Tools of SQL Server• Data Warehouse• Backups, Restores, Modes• Virtualization • DBAs• Looking Ahead• Q&A
![Page 4: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/4.jpg)
History1. 1987 – 1994- SQL was from SYBASE2. 1995 – SQL 63. 1996 – SQL 6.54. 1997 – SQL 75. 2000 – SQL 20006. 2005 – SQL 20057. 2008 – SQL 20088. 2010 – SQL 2008 R2 – SQL Azure9. 2011 – SQL 2011 Code Named Denali10. 2012 – SQL 201211. 2014 – SQL 201412. 2016 - ???
Introduction to SQL Server
![Page 5: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/5.jpg)
What’s new in SQL 20141. Database Engine Enhancements:
• In-Memory OLTP• Updatable and clustered Column Store Indexes• Faster query processing• Memory Buffer Pool can now reside on SSDs• Enhance Always ON for better HA/DR situations
2. Cloud Support Enhancements:• Simplified cloud backup and deployment• HA/Always ON in Azure
3. Business Intelligence Enhancements:• Power query• Power Map• PDW for support of queries for Big Data with T-SQL
Introduction to SQL Server
![Page 6: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/6.jpg)
Client Server
Introduction to SQL Server
Internet
Client Laptop
Client Desktop
Database ServerWeb Server
App Server
Client LaptopClient Desktop
![Page 7: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/7.jpg)
Introduction to SQL Server
![Page 8: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/8.jpg)
Components of SQL
![Page 9: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/9.jpg)
Introduction to SQL Server
![Page 10: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/10.jpg)
Introduction to SQL ServerData Warehouse• Fast, accurate application independent data• Unique(non-redundant) data• Highly secure
![Page 11: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/11.jpg)
Introduction to SQL ServerBackups• Database modes – Simple, Bulk Logged, Full• Backup types – Full, Transaction Logs, Differential • Restore types – Full, Transaction Logs, Differential • Recovery types - Full Recovery, No-Recovery, Standby• Post Restore
Red implies, currently not supported by Actifio
![Page 12: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/12.jpg)
Introduction to SQL ServerDBAs• Application DBA• Developer DBA• Mix of the two
![Page 13: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/13.jpg)
Introduction to SQL Server
Looking ahead1. Our support for SQL 2014- Especially the “In-Memory OLTP databases”2. SQL 2016 coming up as well
• Coming soon- SQL 102 training. Concentrating only on Backups and Restores
![Page 14: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/14.jpg)
Introduction to SQL Server
THANK YOURemember, Paresh for President 2016
• Q&A
![Page 15: Intro to sql](https://reader036.vdocuments.us/reader036/viewer/2022070600/58a09e911a28ab9f758b5cc9/html5/thumbnails/15.jpg)
Introduction to SQL ServerDBAs are not like these
DBAs are like these