title
SQL Server Management Studio (SSMS) | Full Course

description
In this comprehensive video you will learn the features of SQL Server Management Studio (SSMS). You will start with connecting SSMS to SQL Server and then start navigating and writing SQL queries. You will learn about the many feature of SQL Server Management Studio. Install SQL Server Developer Edition: https://www.youtube.com/watch?v=05ZivSteGJg Install SQL Server Management Studio (SSMS) https://www.youtube.com/watch?v=CqpURYqK_wU SQL Server Management Studio (SSMS) | Full Course TABLE OF CONTENTS 0:00 - Intro 0:26 - Installing SSMS 0:09 - Introduction and Prerequisites 1:19 - Connecting to SQL Server 3:15 - Multiple Connections 4:12 - Different Types of Connections 6:08 - Object Explorer 8:51 - Opening a Query Window 9:33 - Exploring the Query Window 10:54 - Executing SQL 12:43 - Executing SQL with F5 13:18 - SQL Intellisense/Autocomplete 14:30 - Multiple SQL Statements 16:04 - RowCount 16:49 - Multiple Query Windows 17:17 - Database Objects in the Object Explorer 18:10 - Dragging a Table into SQL 18:31 - Back to Rowcount 19:13 - Scripting a Table to a New Window 20:54 - Scripting a View to the Clipboard 22:07 - Errors and Red Squiggly Underlines 22:23 - Intellisense - Refresh Local Cache 24:14 - Altering a View 24:45 - Saving Files 25:41 - Opening a File 26:24 - Docking a Window 27:12 - Previewing Records 27:29 - Editing Rows 29:23 - Creating a New Table 29:51 - Properties Window 30:44 - Refreshing the Object Explorer 31:18 - Scripting from an Object Window 32:07 - Script Table as Insert 33:01 - Dragging Columns into Query 33:52 - View Dependencies 34:24 - Table Properties 35:00 - View Designer 35:52 - View Dependencies 36:44 - Script a Stored Procedure 37:36 - Script the Execute of a Stored Procedure 38:14 - Scripting a Function 39:01 - Database Security 40:06 - Server Security 41:50 - Other Server Folders 42:30 - Job Activity Monitor 43:48 - Job Activity Monitor - Auto Refresh 44:32 - Actual Execution Plan 45:52 - Live Statistics 46:14 - Include Client Statistics 47:01 - Parse Query 47:50 - Estimated Execution Plan 48:36 - Query Options 49:23 - Results to Grid, Text, and File 50:12 - Copy Results to Excel 51:38 - Code Snippets 53:41 - Surround With 54:22 - Other Right Click Options 55:58 - Pinning Windows 56:21 - Template Browser 1:00:12 - Adding Custom Templates 1:01:19 - SQL Profiler 1:04:34 - Azure Data Studio 1:05:27 - Increasing Grid Fonts 1:07:27 - Line Numbers and Line Wrap 1:09:16 - Query Shortcuts 1:10:02 - SP_Help 1:10:54 - Projects and Solutions 1:12:34 - Vertical Editing 1:14:04 - Help Documentation - F1 1:14:52 - Splitting the Query Editor 1:15:51 - Object Explorer Details 1:17:31 - Registered Servers 1:19:40 - Database Reports 1:20:23 - Color Coded Connections 1:21:39 - Conclusion YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! LinkedIn: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com

detail
{'title': 'SQL Server Management Studio (SSMS) | Full Course', 'heatmap': [{'end': 1696.352, 'start': 1635.693, 'weight': 0.762}, {'end': 4570.575, 'start': 4515.048, 'weight': 1}], 'summary': "The 'sql server management studio (ssms) | full course' covers installation, connection, navigating object explorer, executing queries, database management, security settings, query tools, query editor snippets, modifying tables, sql profiler, azure data studio, and management studio settings, emphasizing efficiency and user experience.", 'chapters': [{'end': 493.58, 'segs': [{'end': 32.028, 'src': 'embed', 'start': 1.164, 'weight': 0, 'content': [{'end': 4.736, 'text': "In this video I'm going to help you learn how to use SQL Server Management Studio.", 'start': 1.164, 'duration': 3.572}, {'end': 16.483, 'text': 'SQL Server Management Studio is a tool that comes with SQL Server.', 'start': 12.822, 'duration': 3.661}, {'end': 19.004, 'text': 'It used to actually come with it.', 'start': 16.503, 'duration': 2.501}, {'end': 21.585, 'text': "Now you have to download it separately, but it's a free tool.", 'start': 19.184, 'duration': 2.401}, {'end': 23.246, 'text': "And I'm on the screen here.", 'start': 22.265, 'duration': 0.981}, {'end': 26.987, 'text': 'And you simply have to download it and install it.', 'start': 24.126, 'duration': 2.861}, {'end': 32.028, 'text': "And if you need any help with that, I do have a video and I'll link it up below this video here.", 'start': 27.027, 'duration': 5.001}], 'summary': 'Learn to use sql server management studio, a free tool for sql server.', 'duration': 30.864, 'max_score': 1.164, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1164.jpg'}, {'end': 132.965, 'src': 'embed', 'start': 111.92, 'weight': 1, 'content': [{'end': 121.542, 'text': "But if you're connecting out to another SQL server, like for work or something like that, you'll have to type in the server address,", 'start': 111.92, 'duration': 9.622}, {'end': 125.083, 'text': 'the server name or the server IP address or something.', 'start': 121.542, 'duration': 3.541}, {'end': 128.984, 'text': "If you click on this network servers and you're at work,", 'start': 125.963, 'duration': 3.021}, {'end': 132.965, 'text': 'it may take a little while to start searching throughout the whole network to try to find servers.', 'start': 128.984, 'duration': 3.981}], 'summary': 'Connecting to another sql server may take time to search throughout the whole network.', 'duration': 21.045, 'max_score': 111.92, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw111920.jpg'}, {'end': 189.529, 'src': 'embed', 'start': 157.65, 'weight': 2, 'content': [{'end': 159.892, 'text': "but right now that's enough.", 'start': 157.65, 'duration': 2.242}, {'end': 165.076, 'text': 'you should be able to just go in and hit connect, And as soon as you do that,', 'start': 159.892, 'duration': 5.184}, {'end': 168.483, 'text': "this little area on the left-hand side comes up and it's called the object explorer.", 'start': 165.076, 'duration': 3.407}, {'end': 174.775, 'text': 'The object explorer is where you actually look at your server and look at all the objects in the server.', 'start': 169.565, 'duration': 5.21}, {'end': 184.916, 'text': "And so in this case, we're looking at SQL, or we're looking at Joey Desktop and SQL Server version 15.0.", 'start': 175.922, 'duration': 8.994}, {'end': 189.529, 'text': '412102.2 The next thing to note is that you can drill down into some of these other areas.', 'start': 184.916, 'duration': 4.613}], 'summary': 'Access server and objects via object explorer in sql server version 15.0.', 'duration': 31.879, 'max_score': 157.65, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw157650.jpg'}, {'end': 223.913, 'src': 'embed', 'start': 199.358, 'weight': 3, 'content': [{'end': 207.743, 'text': "so when you're connecting, once you're connected, you can also connect to more sql servers.", 'start': 199.358, 'duration': 8.385}, {'end': 213.587, 'text': "so i'm going to connect to one called localhost, and now i've got multiple sql servers, so you can have multiple open.", 'start': 207.743, 'duration': 5.844}, {'end': 221.091, 'text': 'at the same time, you can also disconnect them, and you can disconnect by clicking this disconnect button here,', 'start': 213.587, 'duration': 7.504}, {'end': 223.913, 'text': 'or you can right click on the server itself and hit disconnect.', 'start': 221.091, 'duration': 2.822}], 'summary': 'Connect to multiple sql servers simultaneously and disconnect using the provided options.', 'duration': 24.555, 'max_score': 199.358, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw199358.jpg'}, {'end': 300.276, 'src': 'embed', 'start': 272.471, 'weight': 4, 'content': [{'end': 281.533, 'text': "And so at a glance, you can tell what type of server you're connected to this little black icon that looks more like a cylinder.", 'start': 272.471, 'duration': 9.062}, {'end': 284.354, 'text': "That's your database, your relational database.", 'start': 282.433, 'duration': 1.921}, {'end': 289.155, 'text': "If it looks like a cube, it's your multidimensional analysis services.", 'start': 285.194, 'duration': 3.961}, {'end': 293.096, 'text': 'I can connect to another analysis services.', 'start': 290.775, 'duration': 2.321}, {'end': 297.835, 'text': "because I've got two different types on my machine.", 'start': 294.633, 'duration': 3.202}, {'end': 300.276, 'text': 'And this one has a different icon also.', 'start': 298.615, 'duration': 1.661}], 'summary': 'Identify server types by icons: cylinder for relational database, cube for multidimensional analysis services.', 'duration': 27.805, 'max_score': 272.471, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw272471.jpg'}, {'end': 450.767, 'src': 'embed', 'start': 424.768, 'weight': 5, 'content': [{'end': 430.151, 'text': 'some different security settings, connections, database settings, advanced and permissions.', 'start': 424.768, 'duration': 5.383}, {'end': 436.069, 'text': 'So underneath the server level of the Object Explorer, you can get to the server properties.', 'start': 431.323, 'duration': 4.746}, {'end': 445.42, 'text': "Now many times if you're working with a server, a SQL server for work, you won't have permissions to make these changes unless you're a DBA.", 'start': 436.57, 'duration': 8.85}, {'end': 450.767, 'text': "They'll keep you locked down to just being able to work with your database.", 'start': 446.922, 'duration': 3.845}], 'summary': 'Server properties and permissions, restricted access for non-dba users.', 'duration': 25.999, 'max_score': 424.768, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw424768.jpg'}], 'start': 1.164, 'title': 'Using sql server management studio and connecting to multiple sql servers', 'summary': 'Covers using sql server management studio, including installation, connection process, and navigating object explorer. it also discusses connecting to multiple sql servers, identifying server types by icons, and accessing server properties in object explorer.', 'chapters': [{'end': 195.252, 'start': 1.164, 'title': 'Using sql server management studio', 'summary': 'Explains how to use sql server management studio, including the process of downloading and installing it, connecting it to a server, and navigating the object explorer to view server objects.', 'duration': 194.088, 'highlights': ['SQL Server Management Studio is a free tool that needs to be downloaded and installed separately.', 'To use the Management Studio, a user needs to connect it to a server, which can be a local one or a server installed separately.', 'The Object Explorer in SQL Server Management Studio allows users to view and navigate server objects, such as databases and tables.', 'Connecting to a server in SQL Server Management Studio involves specifying the server name or IP address, and then navigating through the Object Explorer to view server objects.']}, {'end': 493.58, 'start': 199.358, 'title': 'Connecting to multiple sql servers', 'summary': 'Discusses how to connect to multiple sql servers, identifying different server types by their icons, and accessing server properties in object explorer, providing insights into different server properties and their significance.', 'duration': 294.222, 'highlights': ['You can connect to multiple SQL servers simultaneously and disconnect from them using the disconnect button or by right-clicking on the server.', 'Different types of servers like relational database, multidimensional analysis services, tabular instance of Analysis Services, Integration Services, and Reporting Services can be identified by their respective icons.', 'Server properties such as server collation, memory usage, processors, security settings, connections, database settings, advanced settings, and permissions can be accessed under the server level of the Object Explorer.']}], 'duration': 492.416, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1164.jpg', 'highlights': ['SQL Server Management Studio is a free tool that needs to be downloaded and installed separately.', 'Connecting to a server in SQL Server Management Studio involves specifying the server name or IP address, and then navigating through the Object Explorer to view server objects.', 'The Object Explorer in SQL Server Management Studio allows users to view and navigate server objects, such as databases and tables.', 'You can connect to multiple SQL servers simultaneously and disconnect from them using the disconnect button or by right-clicking on the server.', 'Different types of servers like relational database, multidimensional analysis services, tabular instance of Analysis Services, Integration Services, and Reporting Services can be identified by their respective icons.', 'Server properties such as server collation, memory usage, processors, security settings, connections, database settings, advanced settings, and permissions can be accessed under the server level of the Object Explorer.']}, {'end': 964.226, 'segs': [{'end': 521.541, 'src': 'embed', 'start': 494.761, 'weight': 0, 'content': [{'end': 501.846, 'text': "And then integration services catalogs, I'm actually in those quite a bit because I do a lot of ETL work, a lot of integration work.", 'start': 494.761, 'duration': 7.085}, {'end': 504.807, 'text': 'And then you have the SQL Server agent.', 'start': 502.886, 'duration': 1.921}, {'end': 507.209, 'text': 'This is where scheduled jobs happen within SQL Server.', 'start': 504.847, 'duration': 2.362}, {'end': 518.238, 'text': "you can see there's job stuff there and then let's go back up now and let's look at databases.", 'start': 509.091, 'duration': 9.147}, {'end': 521.541, 'text': "so databases is where you'll be at most of time.", 'start': 518.238, 'duration': 3.303}], 'summary': 'Etl and integration work in sql server, with databases as primary focus.', 'duration': 26.78, 'max_score': 494.761, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw494761.jpg'}, {'end': 659.538, 'src': 'embed', 'start': 629.233, 'weight': 1, 'content': [{'end': 635.015, 'text': 'If I change back to SQL training online simple DB, then it changes down here.', 'start': 629.233, 'duration': 5.782}, {'end': 636.796, 'text': 'Now two more things.', 'start': 635.976, 'duration': 0.82}, {'end': 641.378, 'text': "when we actually execute a query, we're going to have the time it took to run the query,", 'start': 636.796, 'duration': 4.582}, {'end': 643.719, 'text': "and then we're going to have the count of how many rows come back.", 'start': 641.378, 'duration': 2.341}, {'end': 652.613, 'text': "So the bottom of this gives you some indicator about what's going on on this query window.", 'start': 645.908, 'duration': 6.705}, {'end': 659.538, 'text': "So let's go ahead and write a query.", 'start': 658.337, 'duration': 1.201}], 'summary': 'Sql training includes query execution time and row count.', 'duration': 30.305, 'max_score': 629.233, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw629233.jpg'}, {'end': 742.05, 'src': 'embed', 'start': 714.452, 'weight': 2, 'content': [{'end': 718.393, 'text': 'And so whenever you write the SQL statement, you execute it and you get the results at the bottom.', 'start': 714.452, 'duration': 3.941}, {'end': 720.484, 'text': "Now you don't just get results though.", 'start': 719.244, 'duration': 1.24}, {'end': 722.485, 'text': "There's two tabs down here.", 'start': 721.145, 'duration': 1.34}, {'end': 724.385, 'text': 'We also get messages.', 'start': 723.265, 'duration': 1.12}, {'end': 728.487, 'text': 'And so the message says 14 rows affected.', 'start': 726.306, 'duration': 2.181}, {'end': 730.267, 'text': 'It gives me a completion time.', 'start': 729.007, 'duration': 1.26}, {'end': 736.549, 'text': 'But if something went wrong and it gave us an error message, it would come back in the messages tab.', 'start': 732.088, 'duration': 4.461}, {'end': 742.05, 'text': "Most of the time you're gonna look at results, but as soon as you write something bad.", 'start': 738.589, 'duration': 3.461}], 'summary': 'Executing sql statement yields 14 rows affected; errors show in messages tab', 'duration': 27.598, 'max_score': 714.452, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw714452.jpg'}, {'end': 796.512, 'src': 'embed', 'start': 767.347, 'weight': 3, 'content': [{'end': 774.435, 'text': "Now, as you start to work within Management Studio, you're going to not want to move your mouse back and forth all the time.", 'start': 767.347, 'duration': 7.088}, {'end': 776.477, 'text': "You're going to be typing and you're going to want to execute.", 'start': 774.455, 'duration': 2.022}, {'end': 782.902, 'text': "So if I hover over this execute, you're going to see that there is F5 in parentheses.", 'start': 777.538, 'duration': 5.364}, {'end': 789.627, 'text': "And that means that if you hit F5, you'll get an execution on the results.", 'start': 783.622, 'duration': 6.005}, {'end': 796.512, 'text': 'And so if I come in here and hit F5, it will execute those results.', 'start': 790.768, 'duration': 5.744}], 'summary': 'Management studio offers f5 shortcut for quick execution of results.', 'duration': 29.165, 'max_score': 767.347, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw767347.jpg'}, {'end': 903.768, 'src': 'embed', 'start': 874.335, 'weight': 5, 'content': [{'end': 881.838, 'text': 'Now what happens if I have two queries on the same query window? Well, management studio will run both of them.', 'start': 874.335, 'duration': 7.503}, {'end': 892.443, 'text': 'And so if I hit execute, you get two results sets at the bottom, one for the first query, one for the second query.', 'start': 882.879, 'duration': 9.564}, {'end': 897.325, 'text': 'Now, what if I had something in here where I was trying to say update?', 'start': 893.603, 'duration': 3.722}, {'end': 903.768, 'text': 'I was trying to say update employee and I wanted to you know, set a value or something.', 'start': 897.325, 'duration': 6.443}], 'summary': 'Management studio runs two queries on the same window, producing two result sets at the bottom.', 'duration': 29.433, 'max_score': 874.335, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw874335.jpg'}, {'end': 972.888, 'src': 'embed', 'start': 941.911, 'weight': 4, 'content': [{'end': 946.254, 'text': 'Um, so like if I highlight it, I hit F5 and I execute it again.', 'start': 941.911, 'duration': 4.343}, {'end': 951.562, 'text': 'So you can have multiple statements and you can highlight them.', 'start': 948.641, 'duration': 2.921}, {'end': 956.103, 'text': 'You can also highlight multiple statements and run them and execute them.', 'start': 951.842, 'duration': 4.261}, {'end': 957.404, 'text': 'I did that with F5.', 'start': 956.463, 'duration': 0.941}, {'end': 960.685, 'text': 'And I can highlight just one and execute them and I get one.', 'start': 958.504, 'duration': 2.181}, {'end': 964.226, 'text': "So that's how you execute things within the query editor.", 'start': 961.305, 'duration': 2.921}, {'end': 972.888, 'text': 'There are some interesting things that you should also note.', 'start': 969.147, 'duration': 3.741}], 'summary': 'Executing multiple highlighted statements using f5 in query editor.', 'duration': 30.977, 'max_score': 941.911, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw941911.jpg'}], 'start': 494.761, 'title': 'Sql server management studio and executing sql statements', 'summary': 'Provides an overview of sql server management studio covering integration services catalogs, sql server agent for scheduled jobs, and executing sql queries with insights on database context, query execution time, and result count. it also explains executing sql statements in management studio, including getting results, error messages, and using shortcut keys like f5.', 'chapters': [{'end': 712.432, 'start': 494.761, 'title': 'Sql server management studio basics', 'summary': 'Provides an overview of sql server management studio, covering integration services catalogs, sql server agent for scheduled jobs, browsing databases, creating query windows, and executing sql queries with insights on database context, query execution time, and result count.', 'duration': 217.671, 'highlights': ['SQL Server Management Studio provides integration services catalogs, SQL Server agent for scheduled jobs, and browsing databases. Mentions the key features of SQL Server Management Studio.', 'Creating and executing SQL queries in the query window, including insights on database context, query execution time, and result count. Explains the process of creating and executing SQL queries, highlighting important details about database context, query execution time, and result count.', 'Demonstrates the process of executing a simple SQL query and viewing the results in the grid at the bottom. Provides a practical example of executing a SQL query and viewing the results.']}, {'end': 964.226, 'start': 714.452, 'title': 'Executing sql statements in management studio', 'summary': 'Explains how to execute sql statements in management studio, including getting results, error messages, using shortcut keys like f5, and executing specific lines or multiple queries.', 'duration': 249.774, 'highlights': ['You can execute SQL statements in Management Studio and view the results or error messages at the bottom of the tab, with 14 rows affected as an example.', 'Management Studio provides a shortcut key, F5, to execute SQL statements without needing to use the mouse, enhancing efficiency.', 'You can execute specific lines or multiple queries within the query window by highlighting them and then executing using the shortcut key.', 'Management Studio can run multiple queries in the same query window and display separate result sets for each query.', 'The process of highlighting specific lines and executing them differs from other editors, where you might use control enter or semi-colons.']}], 'duration': 469.465, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw494761.jpg', 'highlights': ['SQL Server Management Studio provides integration services catalogs, SQL Server agent for scheduled jobs, and browsing databases. Mentions the key features of SQL Server Management Studio.', 'Creating and executing SQL queries in the query window, including insights on database context, query execution time, and result count. Explains the process of creating and executing SQL queries, highlighting important details about database context, query execution time, and result count.', 'You can execute SQL statements in Management Studio and view the results or error messages at the bottom of the tab, with 14 rows affected as an example.', 'Management Studio provides a shortcut key, F5, to execute SQL statements without needing to use the mouse, enhancing efficiency.', 'You can execute specific lines or multiple queries within the query window by highlighting them and then executing using the shortcut key.', 'Management Studio can run multiple queries in the same query window and display separate result sets for each query.']}, {'end': 1484.813, 'segs': [{'end': 1045.429, 'src': 'embed', 'start': 986.751, 'weight': 0, 'content': [{'end': 995.299, 'text': 'Now, right now, we can visually inspect, but when you get to like 10, 000 rows, it will just keep going on here.', 'start': 986.751, 'duration': 8.548}, {'end': 998.382, 'text': "You won't be able to see how many rows, but at the bottom, it will tell you.", 'start': 995.819, 'duration': 2.563}, {'end': 1001.965, 'text': "And it also is executing so fast, you don't get a time limit.", 'start': 999.342, 'duration': 2.623}, {'end': 1008.798, 'text': 'So let me navigate to a different database and see if we can find some more rows to make that make more sense.', 'start': 1003.57, 'duration': 5.228}, {'end': 1014.948, 'text': 'I have this query window.', 'start': 1013.846, 'duration': 1.102}, {'end': 1017.192, 'text': 'I can open a second query window.', 'start': 1015.709, 'duration': 1.483}, {'end': 1031.077, 'text': 'If I go to this Object Explorer again, I can click on a different database like AdventureWorks, DW 2017, and I can go up to the top and hit New Query,', 'start': 1018.567, 'duration': 12.51}, {'end': 1032.558, 'text': "and now I've got another window open.", 'start': 1031.077, 'duration': 1.481}, {'end': 1036.882, 'text': 'So you can have multiple tabs open at the same time, and you can click back and forth between them.', 'start': 1032.578, 'duration': 4.304}, {'end': 1045.429, 'text': "So AdventureWorks DW 2017, let's see what tables we can select from here.", 'start': 1041.165, 'duration': 4.264}], 'summary': 'Database tool allows fast execution, multiple tabs for queries.', 'duration': 58.678, 'max_score': 986.751, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw986751.jpg'}, {'end': 1108.782, 'src': 'embed', 'start': 1075.816, 'weight': 3, 'content': [{'end': 1076.857, 'text': 'We can look at all the views.', 'start': 1075.816, 'duration': 1.041}, {'end': 1085.723, 'text': "We could go into programmability and look at all the stored procedures, which I guess they don't have any in this database.", 'start': 1078.758, 'duration': 6.965}, {'end': 1088.825, 'text': 'And if there were functions, we could look at all the functions.', 'start': 1086.824, 'duration': 2.001}, {'end': 1100.798, 'text': "In this case, I just want to look at tables because I want to get a big table here and let's just see how big this internet sales is.", 'start': 1095.134, 'duration': 5.664}, {'end': 1108.782, 'text': "So now I can take it and I can just drag it on to the right side here and it'll pull everything over for me.", 'start': 1102.238, 'duration': 6.544}], 'summary': 'Analyzing database objects and querying internet sales data.', 'duration': 32.966, 'max_score': 1075.816, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1075816.jpg'}, {'end': 1172.398, 'src': 'embed', 'start': 1141.316, 'weight': 2, 'content': [{'end': 1143.237, 'text': "And so that's at the bottom there.", 'start': 1141.316, 'duration': 1.921}, {'end': 1149.16, 'text': "So, now that we've written some queries and we've looked at the query editor portion of this,", 'start': 1144.538, 'duration': 4.622}, {'end': 1153.222, 'text': "let's move back over to the object explorer and go deeper.", 'start': 1149.16, 'duration': 4.062}, {'end': 1161.449, 'text': "There's a lot more you can do in this Object Explorer.", 'start': 1159.107, 'duration': 2.342}, {'end': 1163.19, 'text': "It's actually pretty powerful.", 'start': 1161.889, 'duration': 1.301}, {'end': 1170.036, 'text': 'And the first thing I want to do is show you how you can script things out.', 'start': 1164.371, 'duration': 5.665}, {'end': 1172.398, 'text': 'So this is used all of the time.', 'start': 1170.676, 'duration': 1.722}], 'summary': 'Introduction to using sql object explorer for scripting queries and its powerful capabilities.', 'duration': 31.082, 'max_score': 1141.316, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1141316.jpg'}, {'end': 1234.081, 'src': 'embed', 'start': 1206.263, 'weight': 4, 'content': [{'end': 1209.485, 'text': "This first time here, let's go to a new query window cause that's what I usually do.", 'start': 1206.263, 'duration': 3.222}, {'end': 1213.508, 'text': "So I'm scripting the table as a create to a new query window.", 'start': 1210.466, 'duration': 3.042}, {'end': 1214.769, 'text': 'I click on that.', 'start': 1214.128, 'duration': 0.641}, {'end': 1220.877, 'text': 'It takes a minute, but it actually generated the create table statement.', 'start': 1216.075, 'duration': 4.802}, {'end': 1223.958, 'text': 'So let me scroll out a little bit, make this smaller.', 'start': 1221.217, 'duration': 2.741}, {'end': 1228.059, 'text': "And I don't need certain parts of it.", 'start': 1226.139, 'duration': 1.92}, {'end': 1231.861, 'text': "And there's a bunch of stuff in here.", 'start': 1230.46, 'duration': 1.401}, {'end': 1234.081, 'text': "I actually don't want any of this extra stuff.", 'start': 1231.881, 'duration': 2.2}], 'summary': 'Scripting a table to create a new query window and removing unnecessary parts.', 'duration': 27.818, 'max_score': 1206.263, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1206263.jpg'}, {'end': 1298.079, 'src': 'embed', 'start': 1267.355, 'weight': 5, 'content': [{'end': 1270.278, 'text': 'And so you may want to modify this employee department view.', 'start': 1267.355, 'duration': 2.923}, {'end': 1275.743, 'text': "So if you're tasked with modifying this view, well, the first thing you need to do is actually know what's in the view.", 'start': 1270.858, 'duration': 4.885}, {'end': 1278.726, 'text': 'So you script the view, and now we have different options.', 'start': 1275.823, 'duration': 2.903}, {'end': 1284.432, 'text': 'We can script it as a create, or we can go ahead and script it as an alter.', 'start': 1278.766, 'duration': 5.666}, {'end': 1290.578, 'text': 'or we can do a create or alter, or you can drop it and actually recreate it.', 'start': 1284.432, 'duration': 6.146}, {'end': 1298.079, 'text': "And so what I want to do is an alter and I'll say this time, I'm going to say to the clipboard instead of to a new query window.", 'start': 1291.696, 'duration': 6.383}], 'summary': 'Modify employee department view using alter option.', 'duration': 30.724, 'max_score': 1267.355, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1267355.jpg'}, {'end': 1454.477, 'src': 'embed', 'start': 1406.996, 'weight': 6, 'content': [{'end': 1416.801, 'text': "And so this is one of the tricks that we have to do is there's a caching component of all the objects that Management Studio has.", 'start': 1406.996, 'duration': 9.805}, {'end': 1427.162, 'text': 'Now up here in this Edit Toolbar menu, If you go down to the thing called IntelliSense, there is a refresh local cache.', 'start': 1417.822, 'duration': 9.34}, {'end': 1431.944, 'text': 'And this refresh local cache will actually update that cache of things.', 'start': 1428.203, 'duration': 3.741}, {'end': 1435.405, 'text': 'So let me click that and see if it gets any better.', 'start': 1433.004, 'duration': 2.401}, {'end': 1437.926, 'text': 'So now we still have a squiggly line in here.', 'start': 1436.005, 'duration': 1.921}, {'end': 1441.227, 'text': 'And the reason we have a squiggly line is because I typed in a comma.', 'start': 1438.626, 'duration': 2.601}, {'end': 1444.228, 'text': 'Let me get rid of that and see if that clears it up.', 'start': 1442.047, 'duration': 2.181}, {'end': 1446.753, 'text': 'Now the squiggly lines are gone.', 'start': 1445.652, 'duration': 1.101}, {'end': 1449.034, 'text': 'So pay attention to those squiggly lines.', 'start': 1447.233, 'duration': 1.801}, {'end': 1450.335, 'text': "They usually mean something's wrong.", 'start': 1449.074, 'duration': 1.261}, {'end': 1454.477, 'text': "And so that's another ways that management studio proactively helps you out.", 'start': 1450.935, 'duration': 3.542}], 'summary': 'Management studio has a caching component and intellisense feature to update cache, helping to identify and fix errors.', 'duration': 47.481, 'max_score': 1406.996, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1406996.jpg'}], 'start': 969.147, 'title': 'Sql database management', 'summary': 'Covers navigating and executing sql queries, displaying the number of rows fetched, opening multiple query windows, querying the database, scripting tables and views, troubleshooting squiggly lines, updating and altering views, and effectively managing a sql database.', 'chapters': [{'end': 1074.916, 'start': 969.147, 'title': 'Sql query navigation and execution', 'summary': 'Discusses navigating and executing sql queries, highlighting the feature where the bottom bar displays the number of rows fetched, aiding in the visualization of large datasets, and also demonstrates the ability to open multiple query windows and navigate through different databases for querying.', 'duration': 105.769, 'highlights': ['The bottom bar displays the number of rows fetched, aiding in visualization of large datasets, which becomes essential when dealing with a high volume of data, such as 10,000 rows or more.', 'Multiple query windows can be opened simultaneously, allowing users to navigate through different databases and execute queries across various tabs for enhanced flexibility and efficiency.', 'Expanding the object explorer provides a comprehensive view of the database, enabling users to easily access and select tables and other objects for querying, improving the querying process.']}, {'end': 1484.813, 'start': 1075.816, 'title': 'Sql database management tutorial', 'summary': 'Covers querying the database, scripting tables and views, troubleshooting squiggly lines, updating and altering views, with a demonstration of altering a view to add a column and resolving context issues, demonstrating how to effectively manage a sql database.', 'duration': 408.997, 'highlights': ['The internet sales table contains 60,398 rows, demonstrating the large size of the dataset.', 'The process of scripting a table as a create to a new query window is explained, providing a practical demonstration of how to script tables effectively.', 'Demonstrating the process of altering a view to add a column and resolving context issues, showcasing practical troubleshooting and problem-solving skills in SQL database management.', 'The importance of paying attention to squiggly lines in Management Studio as an indicator of potential issues, illustrating the proactive assistance provided by Management Studio.', 'A demonstration of refreshing the local cache in Management Studio to update the cache of objects, showcasing practical troubleshooting steps in SQL database management.']}], 'duration': 515.666, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw969147.jpg', 'highlights': ['The bottom bar displays the number of rows fetched, aiding in visualization of large datasets, essential for dealing with high data volume.', 'Multiple query windows can be opened simultaneously, enhancing flexibility and efficiency.', 'Expanding the object explorer provides a comprehensive view of the database, improving the querying process.', 'The internet sales table contains 60,398 rows, demonstrating the large dataset size.', 'Scripting a table as a create to a new query window is explained, providing a practical demonstration.', 'Demonstrating the process of altering a view to add a column and resolving context issues, showcasing practical troubleshooting skills.', 'Paying attention to squiggly lines in Management Studio as an indicator of potential issues, illustrating proactive assistance.', 'Demonstration of refreshing the local cache in Management Studio to update the cache of objects, showcasing practical troubleshooting steps.']}, {'end': 2533.584, 'segs': [{'end': 1667.059, 'src': 'embed', 'start': 1635.693, 'weight': 2, 'content': [{'end': 1638.954, 'text': 'The next thing I want to show you is over here in the object explorer.', 'start': 1635.693, 'duration': 3.261}, {'end': 1644.036, 'text': "If you're on a table, you can actually right click and you can select the top 1000 rows.", 'start': 1639.694, 'duration': 4.342}, {'end': 1646.256, 'text': "So you don't even have to write SQL.", 'start': 1644.056, 'duration': 2.2}, {'end': 1649.797, 'text': 'You select the top 1000 rows and it shows that to you.', 'start': 1646.356, 'duration': 3.441}, {'end': 1656.719, 'text': "Now there's also more help over here.", 'start': 1653.398, 'duration': 3.321}, {'end': 1659.44, 'text': 'If you right click, you can actually edit the top 200 rows.', 'start': 1656.759, 'duration': 2.681}, {'end': 1667.059, 'text': "And this allows you to just interactively edit most of the time in a production environment, you won't be doing this.", 'start': 1662.034, 'duration': 5.025}], 'summary': 'In object explorer, right-click on table to select top 1000 rows without writing sql; edit top 200 rows interactively.', 'duration': 31.366, 'max_score': 1635.693, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1635693.jpg'}, {'end': 1696.352, 'src': 'heatmap', 'start': 1635.693, 'weight': 0.762, 'content': [{'end': 1638.954, 'text': 'The next thing I want to show you is over here in the object explorer.', 'start': 1635.693, 'duration': 3.261}, {'end': 1644.036, 'text': "If you're on a table, you can actually right click and you can select the top 1000 rows.", 'start': 1639.694, 'duration': 4.342}, {'end': 1646.256, 'text': "So you don't even have to write SQL.", 'start': 1644.056, 'duration': 2.2}, {'end': 1649.797, 'text': 'You select the top 1000 rows and it shows that to you.', 'start': 1646.356, 'duration': 3.441}, {'end': 1656.719, 'text': "Now there's also more help over here.", 'start': 1653.398, 'duration': 3.321}, {'end': 1659.44, 'text': 'If you right click, you can actually edit the top 200 rows.', 'start': 1656.759, 'duration': 2.681}, {'end': 1667.059, 'text': "And this allows you to just interactively edit most of the time in a production environment, you won't be doing this.", 'start': 1662.034, 'duration': 5.025}, {'end': 1672.324, 'text': "Um, but when you're doing development, there may be things where you want to actually go in and change something.", 'start': 1667.94, 'duration': 4.384}, {'end': 1676.828, 'text': 'Like if I took this research and development group name, I put a one on it.', 'start': 1673.105, 'duration': 3.723}, {'end': 1679.31, 'text': 'I hit enter.', 'start': 1678.329, 'duration': 0.981}, {'end': 1682.974, 'text': 'I actually updated that record and I can come back here.', 'start': 1679.531, 'duration': 3.443}, {'end': 1687.503, 'text': "take it off, and now it's gone.", 'start': 1685, 'duration': 2.503}, {'end': 1696.352, 'text': "You can also come up here on the toolbar, and there's this SQL pane, and it says show SQL pane.", 'start': 1688.344, 'duration': 8.008}], 'summary': 'In sql server, you can interactively edit and view top rows without writing sql, making development easier.', 'duration': 60.659, 'max_score': 1635.693, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1635693.jpg'}, {'end': 1974.934, 'src': 'embed', 'start': 1945.05, 'weight': 4, 'content': [{'end': 1948.893, 'text': 'Another very useful piece of this is scripting the table as a select or an insert.', 'start': 1945.05, 'duration': 3.843}, {'end': 1953.297, 'text': "If you're creating an insert, you do that to a new window.", 'start': 1949.634, 'duration': 3.663}, {'end': 1955.058, 'text': 'Now you have your insert statement.', 'start': 1953.817, 'duration': 1.241}, {'end': 1958.141, 'text': "Now with this insert statement, it's already crafted up for you.", 'start': 1955.599, 'duration': 2.542}, {'end': 1968.109, 'text': 'You have all the columns listed, but you have to come in here and actually put in the different parameters of what you want here.', 'start': 1958.181, 'duration': 9.928}, {'end': 1974.934, 'text': "So you'd have to actually put in the time, the error time, the username, error number.", 'start': 1968.729, 'duration': 6.205}], 'summary': 'Scripting tables as select or insert, inserting new data with predefined format.', 'duration': 29.884, 'max_score': 1945.05, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1945050.jpg'}, {'end': 2069.33, 'src': 'embed', 'start': 2036.906, 'weight': 3, 'content': [{'end': 2038.747, 'text': 'So those are more of the navigational pieces.', 'start': 2036.906, 'duration': 1.841}, {'end': 2042.11, 'text': "Let's go ahead and right click some more and see what else we've got.", 'start': 2040.028, 'duration': 2.082}, {'end': 2044.252, 'text': "So let's see what the view dependencies does.", 'start': 2042.55, 'duration': 1.702}, {'end': 2047.252, 'text': 'So objects that depend on department.', 'start': 2045.41, 'duration': 1.842}, {'end': 2054.398, 'text': "So now we don't want to drop department because if we drop like a department table, we know that we have a couple views here.", 'start': 2047.752, 'duration': 6.646}, {'end': 2060.603, 'text': 'So this is very nice and let you understand what things depend on this table.', 'start': 2054.438, 'duration': 6.165}, {'end': 2062.385, 'text': "And so that's a nice thing to do.", 'start': 2061.143, 'duration': 1.242}, {'end': 2063.846, 'text': "So let's cancel out of this.", 'start': 2062.885, 'duration': 0.961}, {'end': 2069.33, 'text': "Let's right click and keep going down the list.", 'start': 2067.649, 'duration': 1.681}], 'summary': 'Reviewing navigational features and exploring view dependencies for department table.', 'duration': 32.424, 'max_score': 2036.906, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2036906.jpg'}, {'end': 2333.168, 'src': 'embed', 'start': 2305.601, 'weight': 0, 'content': [{'end': 2310.525, 'text': 'You can create new inline table functions and multi-statement table functions.', 'start': 2305.601, 'duration': 4.924}, {'end': 2312.706, 'text': 'But you can modify and script them.', 'start': 2311.105, 'duration': 1.601}, {'end': 2314.908, 'text': 'So everywhere you go, you can script things out.', 'start': 2312.866, 'duration': 2.042}, {'end': 2318.311, 'text': "And that's really important and really helpful when you're using Management Studio.", 'start': 2314.928, 'duration': 3.383}, {'end': 2320.892, 'text': "Let's go ahead and modify.", 'start': 2320.052, 'duration': 0.84}, {'end': 2333.168, 'text': "a lot of times i'll hit that modifier or hit that script just to see what's in the thing and so you can interrogate what is going on in this procedure.", 'start': 2321.713, 'duration': 11.455}], 'summary': 'Create new inline and multi-statement table functions, modify and script them for interrogation, and management studio usage.', 'duration': 27.567, 'max_score': 2305.601, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2305601.jpg'}, {'end': 2506.423, 'src': 'embed', 'start': 2480.198, 'weight': 1, 'content': [{'end': 2485.381, 'text': "And so this is telling you exactly what's going on inside the database.", 'start': 2480.198, 'duration': 5.183}, {'end': 2489.043, 'text': "There's a lot more to security that you can get into.", 'start': 2486.882, 'duration': 2.161}, {'end': 2493.185, 'text': 'But this is how you see it on the SQL Server Management Studio.', 'start': 2489.663, 'duration': 3.522}, {'end': 2495.727, 'text': "OK, let's get out of that.", 'start': 2494.886, 'duration': 0.841}, {'end': 2498.929, 'text': 'This is server roles.', 'start': 2497.948, 'duration': 0.981}, {'end': 2500.329, 'text': "And again, I'm sysadmin.", 'start': 2498.989, 'duration': 1.34}, {'end': 2501.67, 'text': 'And you already saw that one.', 'start': 2500.389, 'duration': 1.281}, {'end': 2503.031, 'text': "But there's a few other roles in there.", 'start': 2501.71, 'duration': 1.321}, {'end': 2506.423, 'text': "There's other things like credentials.", 'start': 2505.019, 'duration': 1.404}], 'summary': 'The sql server management studio shows server roles, including sysadmin, and other security features like credentials.', 'duration': 26.225, 'max_score': 2480.198, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2480198.jpg'}], 'start': 1488.686, 'title': 'Database management studio overview', 'summary': 'Covers the overview of database management studio, including the manipulation of views, stored procedures, functions, and security settings, emphasizing the use of scripting and querying throughout. it also delves into database and server level security, emphasizing the importance of authentication and user permissions.', 'chapters': [{'end': 1631.812, 'start': 1488.686, 'title': 'Database script management', 'summary': 'Discusses the process of saving and managing sql scripts, including altering, saving, reopening, and docking files, in order to effectively work in a big database, with emphasis on saving and reopening sql queries, switching database context, and docking files for simultaneous work.', 'duration': 143.126, 'highlights': ["You can save your SQL scripts by going to File and saving the query with a specified name, such as 'alter human resources department view', ensuring that the script is saved and can be reopened from the location.", "After reopening a saved query, it is essential to check and switch the database context back to the correct database, such as 'VentureWorks 2017', to ensure the absence of errors and squiggly lines indicating database context discrepancies.", 'It is possible to work on two files simultaneously by dragging and docking them to one of the sides, allowing for efficient referencing and simultaneous work on multiple scripts.']}, {'end': 2085.308, 'start': 1635.693, 'title': 'Interactive editing and table manipulation in object explorer', 'summary': 'Describes how to interactively edit and manipulate database tables in object explorer, including capabilities like selecting top rows, editing records, inserting and deleting records, and navigating through the object explorer interface.', 'duration': 449.615, 'highlights': ['You can interactively edit most of the time in a production environment. Mentions that in a production environment, interactive editing is not typically done.', 'You can select the top 1000 rows and edit the top 200 rows directly without writing SQL. Highlights the capability to select and edit rows without writing SQL, providing a user-friendly approach to data manipulation.', 'You can insert, update, and delete records directly from the Object Explorer interface. Describes the ability to perform CRUD (Create, Read, Update, Delete) operations directly from the Object Explorer interface.', 'The View Dependencies option allows understanding the objects that depend on a specific table. Explains the usefulness of the View Dependencies option in understanding the dependencies of a table.', 'Scripting options enable generating SQL statements for inserts and selecting columns from a table. Describes the functionality of scripting options for generating SQL statements and selecting columns from a table.']}, {'end': 2533.584, 'start': 2086.149, 'title': 'Database management studio overview', 'summary': 'Covers the overview of database management studio, including the manipulation of views, stored procedures, functions, and security settings, emphasizing the use of scripting and querying throughout. it also delves into database and server level security, emphasizing the importance of authentication and user permissions.', 'duration': 447.435, 'highlights': ['Database Management Studio Overview The chapter covers the overview of Database Management Studio, including the manipulation of views, stored procedures, functions, and security settings, emphasizing the use of scripting and querying throughout.', 'The use of scripting and querying in Database Management Studio The chapter emphasizes the importance of scripting and querying throughout the processes of manipulating views, stored procedures, functions, and security settings.', 'Emphasis on database and server level security The transcript delves into the importance of database and server level security, highlighting the authentication and user permissions.', 'Manipulation of views, stored procedures, and functions The transcript details the manipulation of views, stored procedures, and functions within Database Management Studio, emphasizing the ability to create, modify, and script these database objects.', 'Detailed exploration of security settings The transcript provides a detailed exploration of security settings, including the management of users, roles, logins, and permissions at both the database and server level.']}], 'duration': 1044.898, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw1488686.jpg', 'highlights': ['The chapter emphasizes the importance of scripting and querying throughout the processes of manipulating views, stored procedures, functions, and security settings.', 'The transcript provides a detailed exploration of security settings, including the management of users, roles, logins, and permissions at both the database and server level.', 'Describes the ability to perform CRUD (Create, Read, Update, Delete) operations directly from the Object Explorer interface.', 'Explains the usefulness of the View Dependencies option in understanding the dependencies of a table.', 'Describes the functionality of scripting options for generating SQL statements and selecting columns from a table.']}, {'end': 3105.71, 'segs': [{'end': 2589.443, 'src': 'embed', 'start': 2561.012, 'weight': 1, 'content': [{'end': 2568.634, 'text': "I can actually double click this activity monitor and it will show me what's going on with all those jobs when they're scheduled to run next.", 'start': 2561.012, 'duration': 7.622}, {'end': 2570.874, 'text': 'Um, the last time they ran.', 'start': 2569.674, 'duration': 1.2}, {'end': 2581.276, 'text': 'So this CIS policy purge history, um, succeeded at 2 26 PM on the 3rd of October.', 'start': 2571.074, 'duration': 10.202}, {'end': 2583.037, 'text': "So it hasn't run since then.", 'start': 2581.836, 'duration': 1.201}, {'end': 2587.522, 'text': 'The next run, Looks like it wants to happen.', 'start': 2583.717, 'duration': 3.805}, {'end': 2589.443, 'text': "And that's probably because I had the agent turned off.", 'start': 2587.542, 'duration': 1.901}], 'summary': 'The cis policy purge history last succeeded on 3rd october at 2:26 pm, and has not run since, likely due to the agent being turned off.', 'duration': 28.431, 'max_score': 2561.012, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2561012.jpg'}, {'end': 2790.422, 'src': 'embed', 'start': 2765.016, 'weight': 0, 'content': [{'end': 2770.6, 'text': 'And the live statistics is similar, but if it was a long query, you would see this thing running in real time.', 'start': 2765.016, 'duration': 5.584}, {'end': 2774.062, 'text': 'With the execution plan, this happens after the query is done.', 'start': 2771.4, 'duration': 2.662}, {'end': 2782.988, 'text': "Now let's look at another button, include client statistics.", 'start': 2779.606, 'duration': 3.382}, {'end': 2784.909, 'text': "Let's click that one and let's execute again.", 'start': 2783.428, 'duration': 1.481}, {'end': 2788.141, 'text': 'And we have another tab.', 'start': 2786.781, 'duration': 1.36}, {'end': 2790.422, 'text': 'And so this is your client statistics.', 'start': 2788.862, 'duration': 1.56}], 'summary': 'Real-time statistics and client statistics can be accessed during query execution.', 'duration': 25.406, 'max_score': 2765.016, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2765016.jpg'}, {'end': 2911.782, 'src': 'embed', 'start': 2885.163, 'weight': 2, 'content': [{'end': 2892.088, 'text': "So if you have a query that's running 30 minutes, you don't want to run it and then get the plan, because it's taking so long.", 'start': 2885.163, 'duration': 6.925}, {'end': 2894.249, 'text': 'You want to find out the plan beforehand.', 'start': 2892.128, 'duration': 2.121}, {'end': 2898.972, 'text': 'And then you can change an index and see if it changes its estimated execution plan.', 'start': 2895.09, 'duration': 3.882}, {'end': 2907.479, 'text': "Now the estimated execution plan might not be the exact same as the actual execution plan, but it's usually pretty similar.", 'start': 2899.873, 'duration': 7.606}, {'end': 2911.782, 'text': 'And so you can use that as an indicator, especially when you have a really long running query.', 'start': 2908.119, 'duration': 3.663}], 'summary': "To optimize query performance, check the estimated execution plan before running a long query. it's usually similar to the actual execution plan.", 'duration': 26.619, 'max_score': 2885.163, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2885163.jpg'}, {'end': 2994.253, 'src': 'embed', 'start': 2967.513, 'weight': 3, 'content': [{'end': 2972.177, 'text': 'And so those are those buttons, but those same buttons about your results are right here.', 'start': 2967.513, 'duration': 4.664}, {'end': 2976.44, 'text': 'And so what I want to do now is do the results to text.', 'start': 2973.598, 'duration': 2.842}, {'end': 2977.721, 'text': "We've been doing results to grid.", 'start': 2976.46, 'duration': 1.261}, {'end': 2978.822, 'text': 'Let me rerun this.', 'start': 2978.001, 'duration': 0.821}, {'end': 2985.985, 'text': 'And we have a grid down here, right? Well, you also have results to text.', 'start': 2980.56, 'duration': 5.425}, {'end': 2990.93, 'text': 'If I click that and rerun this query, now you have a text results.', 'start': 2986.065, 'duration': 4.865}, {'end': 2994.253, 'text': 'And so we can change how the results come out.', 'start': 2992.551, 'duration': 1.702}], 'summary': 'The speaker demonstrates how to change query results from grid to text.', 'duration': 26.74, 'max_score': 2967.513, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2967513.jpg'}], 'start': 2534.344, 'title': 'Sql server management and query tools', 'summary': 'Covers sql server management studio components, including integration services catalog and agent jobs, as well as sql query tools and result options for optimizing performance and manipulating output formats.', 'chapters': [{'end': 2811.328, 'start': 2534.344, 'title': 'Sql server management studio overview', 'summary': 'Discusses the main components of sql server management studio, including integration services catalog, agent jobs, monitoring job activities, viewing job history, refreshing job view, and analyzing query performance using execution plans and statistics.', 'duration': 276.984, 'highlights': ['You can monitor the activity of agent jobs, view their history, and refresh the view settings to monitor job progress. The activity monitor allows users to monitor the status and history of agent jobs, such as the last run time and the next scheduled run, providing insights into job performance and scheduling.', 'SQL Server Management Studio provides the ability to analyze query performance using actual execution plans and live statistics. The tool enables users to analyze query performance by displaying the execution plan, highlighting query bottlenecks, and identifying opportunities for query optimization.', 'The tool also offers client statistics to provide insights into query performance and potential network issues. SQL Server Management Studio includes client statistics to help users analyze query performance and identify network-related problems, aiding in query tuning and optimization.']}, {'end': 3105.71, 'start': 2812.168, 'title': 'Sql query tools and result options', 'summary': 'Discusses various sql query tools and result options, including parse query, estimated execution plan, query options, and result output formats, enabling users to verify syntax, optimize query performance, and manipulate result formats.', 'duration': 293.542, 'highlights': ['The chapter discusses the parse query tool, which checks the syntax of a query and alerts users about incorrect syntax, aiding in identifying and rectifying syntax errors. The tool alerts users about incorrect syntax and guides them in rectifying syntax errors.', 'It also covers the estimated execution plan tool, allowing users to preview the execution plan of a query before running it, aiding in optimizing query performance and potentially reducing execution time. The tool enables users to preview the execution plan of a query before running it, potentially reducing execution time.', 'Additionally, the chapter explores various result output formats such as text, file, and Excel, providing users with the flexibility to manipulate and export query results for further analysis and processing. Users can manipulate and export query results in formats such as text, file, and Excel for further analysis and processing.']}], 'duration': 571.366, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw2534344.jpg', 'highlights': ['SQL Server Management Studio provides the ability to analyze query performance using actual execution plans and live statistics.', 'The activity monitor allows users to monitor the status and history of agent jobs, such as the last run time and the next scheduled run, providing insights into job performance and scheduling.', 'The tool enables users to preview the execution plan of a query before running it, potentially reducing execution time.', 'Users can manipulate and export query results in formats such as text, file, and Excel for further analysis and processing.', 'The tool also offers client statistics to provide insights into query performance and potential network issues.']}, {'end': 3465.214, 'segs': [{'end': 3133.254, 'src': 'embed', 'start': 3105.95, 'weight': 0, 'content': [{'end': 3109.851, 'text': 'But inside the query editor, we can actually right click and do some different things.', 'start': 3105.95, 'duration': 3.901}, {'end': 3112.432, 'text': 'So we have copy, cut, and paste.', 'start': 3110.832, 'duration': 1.6}, {'end': 3116.533, 'text': 'We have this thing called insert snippet.', 'start': 3113.812, 'duration': 2.721}, {'end': 3118.034, 'text': 'Now this is kind of cool.', 'start': 3116.993, 'duration': 1.041}, {'end': 3121.135, 'text': "And so let's create a new query.", 'start': 3118.814, 'duration': 2.321}, {'end': 3125.036, 'text': 'And I can right click, and I can say insert snippet.', 'start': 3122.255, 'duration': 2.781}, {'end': 3133.254, 'text': 'When I do that, you get this list of things that can help you start creating different objects.', 'start': 3126.291, 'duration': 6.963}], 'summary': 'In the query editor, various options like copy, cut, paste, and insert snippet are available, aiding in creating different objects.', 'duration': 27.304, 'max_score': 3105.95, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3105950.jpg'}, {'end': 3286.621, 'src': 'embed', 'start': 3237.11, 'weight': 3, 'content': [{'end': 3247.694, 'text': 'If I highlight this select from the department, then I right click on my highlight and say surround width, now we get a couple of things.', 'start': 3237.11, 'duration': 10.584}, {'end': 3248.655, 'text': 'We can do a begin and end.', 'start': 3247.734, 'duration': 0.921}, {'end': 3251.893, 'text': 'or we can do like a while loop.', 'start': 3249.571, 'duration': 2.322}, {'end': 3259.7, 'text': "I'm just double clicking on that and it's showing up and now it surrounded my select statement with a while and begin and end.", 'start': 3252.113, 'duration': 7.587}, {'end': 3262.342, 'text': "So that's cool too.", 'start': 3261.541, 'duration': 0.801}, {'end': 3270.494, 'text': 'We can also right click and we can change our connection.', 'start': 3267.853, 'duration': 2.641}, {'end': 3274.416, 'text': 'So we can change the connection on our query sheet.', 'start': 3271.114, 'duration': 3.302}, {'end': 3281.499, 'text': "So if we want to go to a different server, maybe we're going from dev and we want to query against prod or something like that.", 'start': 3275.676, 'duration': 5.823}, {'end': 3286.621, 'text': "There's this open server in object explorer.", 'start': 3284.14, 'duration': 2.481}], 'summary': 'Using sql server management studio, you can wrap queries with loops and change connections for querying different servers.', 'duration': 49.511, 'max_score': 3237.11, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3237110.jpg'}, {'end': 3346.176, 'src': 'embed', 'start': 3311.016, 'weight': 6, 'content': [{'end': 3314.379, 'text': "We haven't talked about SQL Profiler yet, but we'll come back to that.", 'start': 3311.016, 'duration': 3.363}, {'end': 3319.644, 'text': 'Um, we got the database engine tuning advisor.', 'start': 3316.281, 'duration': 3.363}, {'end': 3323.748, 'text': 'Uh, you can design the query in an editor.', 'start': 3319.664, 'duration': 4.084}, {'end': 3325.229, 'text': "Let's hit that one.", 'start': 3323.768, 'duration': 1.461}, {'end': 3331.815, 'text': 'So now this is our department query actually designed in an editor.', 'start': 3326.35, 'duration': 5.465}, {'end': 3333.697, 'text': 'So it looks like Microsoft access.', 'start': 3331.835, 'duration': 1.862}, {'end': 3336.66, 'text': 'We saw that when we were editing the view that a little bit earlier.', 'start': 3333.717, 'duration': 2.943}, {'end': 3346.176, 'text': "And then here's your execution plans, query statistics, client statistics, same as the buttons that we had up top.", 'start': 3340.41, 'duration': 5.766}], 'summary': 'Introduction to database tuning tools and query design using sql profiler and database engine tuning advisor.', 'duration': 35.16, 'max_score': 3311.016, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3311016.jpg'}, {'end': 3415.315, 'src': 'embed', 'start': 3366.694, 'weight': 4, 'content': [{'end': 3372.638, 'text': 'When you hit them, it hides things over to the side and then you come hover back over or click back on them and then they come back.', 'start': 3366.694, 'duration': 5.944}, {'end': 3377.481, 'text': "And then if you click the little pin button, then they'll persist.", 'start': 3372.778, 'duration': 4.703}, {'end': 3380.603, 'text': 'Unclick it and it goes away.', 'start': 3379.463, 'duration': 1.14}, {'end': 3387.008, 'text': "Now there's also, we talked about snippets.", 'start': 3384.746, 'duration': 2.262}, {'end': 3390.38, 'text': "but there's also this thing called a template browser.", 'start': 3387.998, 'duration': 2.382}, {'end': 3392.001, 'text': "And let's see what that thing is.", 'start': 3390.74, 'duration': 1.261}, {'end': 3397.965, 'text': "So I'm just going to come over to view and I'm going to hit the template explorer here.", 'start': 3392.782, 'duration': 5.183}, {'end': 3401.148, 'text': 'And I get this thing on the right hand side.', 'start': 3397.985, 'duration': 3.163}, {'end': 3404.79, 'text': 'Now this is very similar to that snippets that we looked at.', 'start': 3402.008, 'duration': 2.782}, {'end': 3411.856, 'text': 'And so over here, we actually have things like create table and different things like that.', 'start': 3405.731, 'duration': 6.125}, {'end': 3415.315, 'text': 'So if I go into table, I have a whole bunch of things.', 'start': 3411.936, 'duration': 3.379}], 'summary': 'The transcript discusses using a template browser and snippets for creating tables and other elements in the application.', 'duration': 48.621, 'max_score': 3366.694, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3366694.jpg'}], 'start': 3105.95, 'title': 'Query editor snippets and using sql server management studio', 'summary': 'Introduces the functionality of query editor snippets in sql server, facilitating the process of creating new stored procedures, tables, and other database objects. it also discusses various features in sql server management studio, such as snippet insertion, changing connections, executing queries, and utilizing the template browser and pin buttons.', 'chapters': [{'end': 3210.667, 'start': 3105.95, 'title': 'Query editor snippets', 'summary': 'Introduces the functionality of query editor snippets in sql server, where users can right-click to access a list of predefined code snippets for creating different database objects, facilitating the process of creating new stored procedures, tables, and other database objects.', 'duration': 104.717, 'highlights': ['The query editor allows users to right-click and access a list of predefined code snippets for creating different database objects, such as stored procedures and tables, facilitating the process of creating new database objects.', "The functionality of 'insert snippet' allows users to easily access pre-defined code snippets for creating various database objects, improving efficiency and reducing manual coding efforts.", "The use of 'insert snippet' feature in the query editor provides predefined code snippets for creating specific database objects, such as stored procedures with output parameters, enhancing the development process by providing ready-to-use code templates."]}, {'end': 3465.214, 'start': 3211.307, 'title': 'Using sql server management studio', 'summary': 'Discusses various features in sql server management studio, including snippet insertion, changing connections, executing queries, and utilizing the template browser and pin buttons.', 'duration': 253.907, 'highlights': ['Snippet insertion The tool allows for snippet insertion, such as surrounding a select statement with a while loop or begin and end, providing quick and efficient code structuring.', 'Changing connections Users can easily change the connection on the query sheet, enabling seamless querying between different servers, like transitioning from dev to prod.', 'Template browser The template browser offers a wide range of functionalities, such as creating tables, adding columns with verbose templates, and utilizing a special combination of Control Shift M to fill out parameters efficiently.', 'Pin buttons The pin buttons allow users to hide and persist certain elements on the interface, providing a customizable and clutter-free working environment.', 'Executing queries and other functionalities Additional functionalities include executing queries, accessing estimated execution plans, disabling IntelliSense, tracing queries in SQL Profiler, and utilizing the database engine tuning advisor.']}], 'duration': 359.264, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3105950.jpg', 'highlights': ['The query editor allows users to right-click and access a list of predefined code snippets for creating different database objects, such as stored procedures and tables, facilitating the process of creating new database objects.', "The functionality of 'insert snippet' allows users to easily access pre-defined code snippets for creating various database objects, improving efficiency and reducing manual coding efforts.", "The use of 'insert snippet' feature in the query editor provides predefined code snippets for creating specific database objects, such as stored procedures with output parameters, enhancing the development process by providing ready-to-use code templates.", 'Changing connections Users can easily change the connection on the query sheet, enabling seamless querying between different servers, like transitioning from dev to prod.', 'Template browser The template browser offers a wide range of functionalities, such as creating tables, adding columns with verbose templates, and utilizing a special combination of Control Shift M to fill out parameters efficiently.', 'Pin buttons The pin buttons allow users to hide and persist certain elements on the interface, providing a customizable and clutter-free working environment.', 'Executing queries and other functionalities Additional functionalities include executing queries, accessing estimated execution plans, disabling IntelliSense, tracing queries in SQL Profiler, and utilizing the database engine tuning advisor.', 'Snippet insertion The tool allows for snippet insertion, such as surrounding a select statement with a while loop or begin and end, providing quick and efficient code structuring.']}, {'end': 3867.351, 'segs': [{'end': 3529.487, 'src': 'embed', 'start': 3466.337, 'weight': 0, 'content': [{'end': 3478.343, 'text': "So in the database here, I'm actually working with SQL training online simple DB, and schema, and then we have the table.", 'start': 3466.337, 'duration': 12.006}, {'end': 3486.007, 'text': 'The table is employee, and the new column I want is email.', 'start': 3479.584, 'duration': 6.423}, {'end': 3497.156, 'text': "And the type is not date time, I actually want a varchar, let's say 255.", 'start': 3488.388, 'duration': 8.768}, {'end': 3498.378, 'text': 'Okay, and it can be null.', 'start': 3497.156, 'duration': 1.222}, {'end': 3501.862, 'text': 'If I hit okay, now it went and inserted all this stuff for me.', 'start': 3498.738, 'duration': 3.124}, {'end': 3505.447, 'text': "And I don't need all these little pieces.", 'start': 3503.825, 'duration': 1.622}, {'end': 3512.436, 'text': "It does, if I look at the bottom again, we haven't done this for a while, I'm in SQL training online simple DB.", 'start': 3506.869, 'duration': 5.567}, {'end': 3516.737, 'text': 'it tries to drop the table and recreate it.', 'start': 3514.275, 'duration': 2.462}, {'end': 3517.938, 'text': "We definitely don't want that.", 'start': 3516.797, 'duration': 1.141}, {'end': 3525.264, 'text': "So I'm just going to take all of that stuff, delete it and just leave the add new column part alter table.", 'start': 3518.398, 'duration': 6.866}, {'end': 3529.487, 'text': 'employee. add email bar chart to 55, execute that.', 'start': 3525.264, 'duration': 4.223}], 'summary': 'Adding a new email column to the employee table in a sql training database.', 'duration': 63.15, 'max_score': 3466.337, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3466337.jpg'}, {'end': 3617.921, 'src': 'embed', 'start': 3584.722, 'weight': 2, 'content': [{'end': 3586.122, 'text': 'You want to do that, click that.', 'start': 3584.722, 'duration': 1.4}, {'end': 3587.283, 'text': 'And now you have a create table.', 'start': 3586.162, 'duration': 1.121}, {'end': 3591.583, 'text': 'Um, remember control shift M helps you to fill out.', 'start': 3587.943, 'duration': 3.64}, {'end': 3594.924, 'text': 'You only have to fill them out, just hit control shift M and then hit.', 'start': 3591.723, 'duration': 3.201}, {'end': 3599.325, 'text': "Okay And it'll simplify this to make it look more normal.", 'start': 3594.984, 'duration': 4.341}, {'end': 3605.653, 'text': "But there's triggers, there's views, users.", 'start': 3601.65, 'duration': 4.003}, {'end': 3611.877, 'text': "There's really a pretty robust group of things in here to help you with your SQL.", 'start': 3606.834, 'duration': 5.043}, {'end': 3617.921, 'text': 'You can even add your own templates.', 'start': 3615.92, 'duration': 2.001}], 'summary': 'Instruction on using control shift m to simplify sql and a range of features available for sql management.', 'duration': 33.199, 'max_score': 3584.722, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3584722.jpg'}], 'start': 3466.337, 'title': 'Modifying table in sql training', 'summary': "Demonstrates modifying a table in sql training by adding a new column 'email' of type varchar(255) and ensuring it can be null, while avoiding unnecessary recreation of the table.", 'chapters': [{'end': 3529.487, 'start': 3466.337, 'title': 'Modifying table in sql training', 'summary': "Demonstrates modifying a table in sql training by adding a new column 'email' of type varchar(255) and ensuring it can be null, while avoiding unnecessary recreation of the table.", 'duration': 63.15, 'highlights': ["By altering the table 'employee' and adding the new column 'email' of type varchar(255), it demonstrates practical modification of a database table in SQL training.", 'Avoiding unnecessary recreation of the table by removing the superfluous code ensures efficient database management and prevents data loss.', 'The demonstration emphasizes the importance of understanding and controlling the table modification process to avoid unintended consequences.']}, {'end': 3867.351, 'start': 3530.568, 'title': 'Sql server management studio tools', 'summary': 'Covers various tools in sql server management studio, including the template browser, sql server profiler, and their functionalities, such as creating templates, capturing sql queries, and troubleshooting database performance.', 'duration': 336.783, 'highlights': ['SQL Server Profiler The chapter provides an overview of SQL Server Profiler, a tool built in SQL Server Management Studio, allowing users to capture and analyze SQL queries, troubleshoot performance issues, and track events and databases.', 'Template Browser and Custom Templates It demonstrates the use of the template browser in SQL Server Management Studio to create custom templates for queries, providing a convenient way to reuse saved queries and open new query windows with predefined statements.', 'Object Explorer and Query Windows It explains the functionality of Object Explorer and Query Windows in SQL Server Management Studio, allowing users to manage connections, databases, and query execution, providing a comprehensive view and control over SQL Server management.']}], 'duration': 401.014, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3466337.jpg', 'highlights': ["Demonstrates modifying a table in SQL training by adding a new column 'email' of type varchar(255).", 'Avoiding unnecessary recreation of the table ensures efficient database management and prevents data loss.', 'The demonstration emphasizes the importance of understanding and controlling the table modification process to avoid unintended consequences.']}, {'end': 4156.314, 'segs': [{'end': 3909.58, 'src': 'embed', 'start': 3868.032, 'weight': 0, 'content': [{'end': 3872.216, 'text': 'So this is a really good tool to know about if you ever need to troubleshoot some stuff.', 'start': 3868.032, 'duration': 4.184}, {'end': 3874.498, 'text': 'This is SQL Profiler.', 'start': 3873.237, 'duration': 1.261}, {'end': 3880.429, 'text': "Now, as we're in here, there's a couple other things too.", 'start': 3878.362, 'duration': 2.067}, {'end': 3881.814, 'text': "There's the tuning advisor.", 'start': 3880.81, 'duration': 1.004}, {'end': 3887.253, 'text': "I'm not going to get into that today, but this Azure Data Studio, I want to open that.", 'start': 3881.854, 'duration': 5.399}, {'end': 3893.995, 'text': "And so as your data studio, I don't want to start a tour is another place that you can write queries.", 'start': 3888.033, 'duration': 5.962}, {'end': 3900.817, 'text': "And if you're working outside of windows, this is really a good option because this is built on visual studio code.", 'start': 3894.615, 'duration': 6.202}, {'end': 3907.259, 'text': "I'll probably start doing some videos here soon on, um, on this tool, but this allows you to run queries kind of like management studio.", 'start': 3901.117, 'duration': 6.142}, {'end': 3909.58, 'text': "It's just doesn't have as many features as management studio.", 'start': 3907.319, 'duration': 2.261}], 'summary': 'Sql profiler and azure data studio are useful for troubleshooting and running queries, with the latter being a good option outside of windows.', 'duration': 41.548, 'max_score': 3868.032, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3868032.jpg'}, {'end': 3969.547, 'src': 'embed', 'start': 3942.291, 'weight': 3, 'content': [{'end': 3945.613, 'text': "Let me shrink them down, they're a little bit too big for my window here.", 'start': 3942.291, 'duration': 3.322}, {'end': 3949.293, 'text': "So there's lots of different settings.", 'start': 3947.392, 'duration': 1.901}, {'end': 3952.676, 'text': 'You can customize all kinds of things inside of Management Studio.', 'start': 3949.313, 'duration': 3.363}, {'end': 3957.979, 'text': "But there's specific ones that I think are probably good to point out.", 'start': 3953.296, 'duration': 4.683}, {'end': 3960.541, 'text': 'And the first one is Fonts and Colors.', 'start': 3958.94, 'duration': 1.601}, {'end': 3965.184, 'text': "And when I click in here, there's different things that I have to set.", 'start': 3961.441, 'duration': 3.743}, {'end': 3969.547, 'text': 'For instance, let me see if I can move this out of the way from it.', 'start': 3966.405, 'duration': 3.142}], 'summary': 'Customize settings such as fonts and colors in management studio.', 'duration': 27.256, 'max_score': 3942.291, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3942291.jpg'}, {'end': 4086.931, 'src': 'embed', 'start': 4058.169, 'weight': 2, 'content': [{'end': 4062.292, 'text': "So if I expand languages, there's all languages, but there's also different ones.", 'start': 4058.169, 'duration': 4.123}, {'end': 4071.999, 'text': 'If we click on the general in here, what I wanna do, is I want to enable the line numbers.', 'start': 4063.172, 'duration': 8.827}, {'end': 4073.801, 'text': "That's super important.", 'start': 4072.8, 'duration': 1.001}, {'end': 4082.408, 'text': "Whenever you're working online, whenever you're working with other people and you have to work remote, like we do a lot right now,", 'start': 4075.842, 'duration': 6.566}, {'end': 4086.931, 'text': 'you have to point out different lines that people are on and talk about that line.', 'start': 4082.408, 'duration': 4.523}], 'summary': 'Enabling line numbers is crucial for working remotely and collaborating on code.', 'duration': 28.762, 'max_score': 4058.169, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4058169.jpg'}, {'end': 4163.176, 'src': 'embed', 'start': 4137.93, 'weight': 4, 'content': [{'end': 4144.131, 'text': "But then it's wrapping and then there's this little bitty thing on the right hand side that shows that it's wrapping.", 'start': 4137.93, 'duration': 6.201}, {'end': 4145.493, 'text': "That's that visual glyph.", 'start': 4144.452, 'duration': 1.041}, {'end': 4148.233, 'text': "I like it because it helps me understand what's wrapping and not.", 'start': 4145.832, 'duration': 2.401}, {'end': 4151.374, 'text': "But the line numbers also help me understand if it's wrapping or not.", 'start': 4148.573, 'duration': 2.801}, {'end': 4154.033, 'text': 'You can see line 35 is also wrapping.', 'start': 4152.134, 'duration': 1.899}, {'end': 4156.314, 'text': "So that's something that's good to turn on.", 'start': 4154.474, 'duration': 1.84}, {'end': 4163.176, 'text': "Now there's one more thing in the options I want to show you.", 'start': 4160.975, 'duration': 2.201}], 'summary': 'Visual glyph and line numbers help understand wrapping, with line 35 also wrapping.', 'duration': 25.246, 'max_score': 4137.93, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4137930.jpg'}], 'start': 3868.032, 'title': 'Sql profiler, azure data studio, and management studio settings', 'summary': 'Introduces sql profiler and azure data studio, emphasizing their benefits. it also discusses the importance of customizing management studio settings, with specific focus on font sizes, line numbers, word wrap, and visual glyphs to enhance readability and collaboration, aiming to provide a better user experience.', 'chapters': [{'end': 3909.58, 'start': 3868.032, 'title': 'Introduction to sql profiler and azure data studio', 'summary': 'Introduces sql profiler as a troubleshooting tool and azure data studio as an alternative for writing queries, particularly beneficial for non-windows environments, as it is built on visual studio code.', 'duration': 41.548, 'highlights': ['SQL Profiler is a useful tool for troubleshooting various issues. It provides insights into SQL Server activities and can help optimize query performance.', 'Azure Data Studio is a versatile platform for writing queries, especially suitable for non-Windows environments as it is built on Visual Studio Code.']}, {'end': 4156.314, 'start': 3911.2, 'title': 'Management studio settings', 'summary': 'Discusses the importance of customizing management studio settings, specifically focusing on adjusting font sizes, enabling line numbers, word wrap, and visual glyphs to enhance readability and collaboration, with a recommendation to enable these settings for ease of use and better user experience.', 'duration': 245.114, 'highlights': ["Enabling line numbers is important for working with others and remote collaboration, as it allows easier referencing of specific lines and issues (e.g., 'line 130 is where I see an issue').", 'Adjusting font sizes in Management Studio, such as increasing the size of grid results, is crucial for better readability, especially during trainings and presentations.', 'Enabling word wrap and visual glyphs in text editor settings enhances the understanding of long, wrapped lines and improves the overall readability of queries.']}], 'duration': 288.282, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw3868032.jpg', 'highlights': ['SQL Profiler provides insights into SQL Server activities and optimizes query performance.', 'Azure Data Studio is suitable for non-Windows environments and is built on Visual Studio Code.', 'Enabling line numbers facilitates remote collaboration and referencing specific lines and issues.', 'Adjusting font sizes in Management Studio improves readability, especially during trainings and presentations.', 'Enabling word wrap and visual glyphs enhances the understanding of long, wrapped lines and improves query readability.']}, {'end': 4947.39, 'segs': [{'end': 4251.537, 'src': 'embed', 'start': 4221.095, 'weight': 0, 'content': [{'end': 4223.376, 'text': 'Okay So I have this open, I have it open again.', 'start': 4221.095, 'duration': 2.281}, {'end': 4229.76, 'text': 'And now if I do alt F1, oops, highlight the element.', 'start': 4223.496, 'duration': 6.264}, {'end': 4237.484, 'text': "If you've never done SP help, I have a video on it, but here's SP help and then employee.", 'start': 4230.88, 'duration': 6.604}, {'end': 4246.769, 'text': "And you've got the actual help information about that table.", 'start': 4242.427, 'duration': 4.342}, {'end': 4251.537, 'text': 'But if you go over it, you can do the Alt F1, and you get the same thing.', 'start': 4248.476, 'duration': 3.061}], 'summary': 'Demonstrating how to access sp help and highlighting elements using alt f1.', 'duration': 30.442, 'max_score': 4221.095, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4221095.jpg'}, {'end': 4365.457, 'src': 'embed', 'start': 4333.517, 'weight': 1, 'content': [{'end': 4342.843, 'text': "And when I'm ready to work on it again, I can just come open project solution, SQL scripts two, not one.", 'start': 4333.517, 'duration': 9.326}, {'end': 4346.725, 'text': 'And there they are.', 'start': 4346.225, 'duration': 0.5}, {'end': 4351.247, 'text': 'And so now we have all those queries that we could work on.', 'start': 4347.955, 'duration': 3.292}, {'end': 4353.434, 'text': "So that's the concept of solutions.", 'start': 4351.909, 'duration': 1.525}, {'end': 4365.457, 'text': "Now I want to show you a couple of tips that can help you as you're working through and developing inside of Management Studio.", 'start': 4357.97, 'duration': 7.487}], 'summary': 'Using project solution sql scripts 2, access queries and tips in management studio.', 'duration': 31.94, 'max_score': 4333.517, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4333517.jpg'}, {'end': 4425.858, 'src': 'embed', 'start': 4392.393, 'weight': 3, 'content': [{'end': 4404.466, 'text': "And that is, if I changed, let's say I changed person from P to PER as my alias, that's going to mess up some things.", 'start': 4392.393, 'duration': 12.073}, {'end': 4414.968, 'text': "But if I want to edit all these at once, all these P's right here, All you have to do is hold down your Alt button.", 'start': 4404.967, 'duration': 10.001}, {'end': 4420.012, 'text': 'So I start there, I hold down my Alt button, and I can drag vertically.', 'start': 4416.029, 'duration': 3.983}, {'end': 4425.858, 'text': 'Now I can type in PR, and I just changed all of those at once.', 'start': 4420.893, 'duration': 4.965}], 'summary': 'Changing alias from p to per using alt button to edit all occurrences at once.', 'duration': 33.465, 'max_score': 4392.393, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4392393.jpg'}, {'end': 4515.028, 'src': 'embed', 'start': 4486.484, 'weight': 4, 'content': [{'end': 4491.967, 'text': "So if you just use F1 on whatever function you're working on, it goes directly to help.", 'start': 4486.484, 'duration': 5.483}, {'end': 4501.852, 'text': "So this tip here that I'm going to show you is, when you're working on a big query, a big long query.", 'start': 4495.839, 'duration': 6.013}, {'end': 4505.239, 'text': "let's see if we can find a view or something, maybe a.", 'start': 4501.852, 'duration': 3.387}, {'end': 4506.803, 'text': "let's go after a store procedure.", 'start': 4505.239, 'duration': 1.564}, {'end': 4515.028, 'text': "So if we're working on a long store procedure and we need to divide it in half so we can see a certain part and keep a certain part of it steady.", 'start': 4508.325, 'duration': 6.703}], 'summary': 'Use f1 for direct help on functions and tips for working on long queries and store procedures.', 'duration': 28.544, 'max_score': 4486.484, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4486484.jpg'}, {'end': 4570.575, 'src': 'heatmap', 'start': 4515.048, 'weight': 1, 'content': [{'end': 4517.849, 'text': "Let's go here, maybe this is big.", 'start': 4515.048, 'duration': 2.801}, {'end': 4519.009, 'text': 'Yeah, this is big enough.', 'start': 4518.269, 'duration': 0.74}, {'end': 4529.054, 'text': 'So if we need to keep the procedure, we want to keep looking at these declared variables, I can come in here and I can split the screen.', 'start': 4519.61, 'duration': 9.444}, {'end': 4537.822, 'text': 'so i can keep my variables up there so i know what they are and then i can scroll down here and i can change the code, but i can still see everything.', 'start': 4530.094, 'duration': 7.728}, {'end': 4540.465, 'text': "so there's a lot of times where i have huge, you know,", 'start': 4537.822, 'duration': 2.643}, {'end': 4551.717, 'text': "500 line views or something and i need to keep part of it steady and i'll do the split screen there so i can keep copying and pasting from one section down to the other section.", 'start': 4540.465, 'duration': 11.252}, {'end': 4556.945, 'text': 'For the next tip.', 'start': 4555.464, 'duration': 1.481}, {'end': 4559.727, 'text': "we don't need these query windows anymore.", 'start': 4556.945, 'duration': 2.782}, {'end': 4560.488, 'text': "We'll get rid of those.", 'start': 4559.747, 'duration': 0.741}, {'end': 4565.471, 'text': 'What we need is just to look over here inside the Object Explorer.', 'start': 4561.689, 'duration': 3.782}, {'end': 4570.575, 'text': "And there's a feature that I've, quite frankly, not used in a while.", 'start': 4566.032, 'duration': 4.543}], 'summary': 'Using split screen to manage large code views and utilizing object explorer feature for better efficiency.', 'duration': 55.527, 'max_score': 4515.048, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4515048.jpg'}, {'end': 4556.945, 'src': 'embed', 'start': 4530.094, 'weight': 5, 'content': [{'end': 4537.822, 'text': 'so i can keep my variables up there so i know what they are and then i can scroll down here and i can change the code, but i can still see everything.', 'start': 4530.094, 'duration': 7.728}, {'end': 4540.465, 'text': "so there's a lot of times where i have huge, you know,", 'start': 4537.822, 'duration': 2.643}, {'end': 4551.717, 'text': "500 line views or something and i need to keep part of it steady and i'll do the split screen there so i can keep copying and pasting from one section down to the other section.", 'start': 4540.465, 'duration': 11.252}, {'end': 4556.945, 'text': 'For the next tip.', 'start': 4555.464, 'duration': 1.481}], 'summary': 'Using split screen to work with large 500 line views, enabling easy copying and pasting.', 'duration': 26.851, 'max_score': 4530.094, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4530094.jpg'}, {'end': 4609.778, 'src': 'embed', 'start': 4582.577, 'weight': 6, 'content': [{'end': 4587.286, 'text': 'If I click on that, we get extra information over here in another screen.', 'start': 4582.577, 'duration': 4.709}, {'end': 4588.488, 'text': 'So this is not the query window.', 'start': 4587.306, 'duration': 1.182}, {'end': 4590.392, 'text': 'This is, um, details.', 'start': 4588.508, 'duration': 1.884}, {'end': 4596.729, 'text': 'And so let me click into one of these and click on tables.', 'start': 4591.846, 'duration': 4.883}, {'end': 4604.795, 'text': 'And this is where I find it really nice is we have all these different tables here and it tells you a lot of stuff about them the table,', 'start': 4597.23, 'duration': 7.565}, {'end': 4609.778, 'text': 'the schema but you can right click on the column and you can grab row count.', 'start': 4604.795, 'duration': 4.983}], 'summary': 'The system provides detailed information about tables, including row count, schema, and other details.', 'duration': 27.201, 'max_score': 4582.577, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4582577.jpg'}, {'end': 4705.76, 'src': 'embed', 'start': 4676.36, 'weight': 7, 'content': [{'end': 4680.783, 'text': 'And in here, you can actually register the different connections that you have.', 'start': 4676.36, 'duration': 4.423}, {'end': 4685.426, 'text': 'You can right-click on them and say you want a new server group.', 'start': 4681.443, 'duration': 3.983}, {'end': 4694.052, 'text': 'So you could get a group of dev servers, and you could have a group of production servers.', 'start': 4686.067, 'duration': 7.985}, {'end': 4695.613, 'text': 'Let me say prod.', 'start': 4694.852, 'duration': 0.761}, {'end': 4700.776, 'text': 'And then we could have a group of staging servers, STG.', 'start': 4696.373, 'duration': 4.403}, {'end': 4705.76, 'text': 'And then inside of them, you can have different server registrations.', 'start': 4701.577, 'duration': 4.183}], 'summary': 'The software allows registering various server connections, such as dev, production, and staging servers, and managing them within different server groups.', 'duration': 29.4, 'max_score': 4676.36, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4676360.jpg'}, {'end': 4804.967, 'src': 'embed', 'start': 4777.178, 'weight': 8, 'content': [{'end': 4780.36, 'text': 'They can be helpful to keep track of all the different connections that you have.', 'start': 4777.178, 'duration': 3.182}, {'end': 4791.177, 'text': "Now I'm going to close down the registered servers and I want to show you, if you're on a database, there's a pretty cool feature.", 'start': 4784.332, 'duration': 6.845}, {'end': 4797.202, 'text': 'You can right click on the database and you can go to reports and go to standard reports,', 'start': 4791.738, 'duration': 5.464}, {'end': 4800.724, 'text': "and there's a bunch of different reports that just come with the database.", 'start': 4797.202, 'duration': 3.522}, {'end': 4804.967, 'text': 'The one I want to look at is disk usage by table.', 'start': 4801.305, 'duration': 3.662}], 'summary': 'Database allows tracking various connections and provides standard reports like disk usage by table.', 'duration': 27.789, 'max_score': 4777.178, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4777178.jpg'}, {'end': 4910.446, 'src': 'embed', 'start': 4882.048, 'weight': 9, 'content': [{'end': 4885.171, 'text': "And this helps you to know, well, I shouldn't delete out of here.", 'start': 4882.048, 'duration': 3.123}, {'end': 4886.031, 'text': "I'm in prod.", 'start': 4885.351, 'duration': 0.68}, {'end': 4890.773, 'text': 'And then maybe your dev is green or your stage is yellow,', 'start': 4887.048, 'duration': 3.725}, {'end': 4897.641, 'text': "but some kind of indicator that lets you know the different color or different state or different server that you're in,", 'start': 4890.773, 'duration': 6.868}, {'end': 4899.404, 'text': "so that you don't do something silly and prod.", 'start': 4897.641, 'duration': 1.763}, {'end': 4904.881, 'text': "So that's management studio.", 'start': 4903.72, 'duration': 1.161}, {'end': 4907.363, 'text': 'We just learned about connecting.', 'start': 4905.121, 'duration': 2.242}, {'end': 4910.446, 'text': 'We learned about different server types disconnecting object,', 'start': 4907.403, 'duration': 3.043}], 'summary': 'Using different colors for different server states in management studio to avoid mistakes in production.', 'duration': 28.398, 'max_score': 4882.048, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4882048.jpg'}], 'start': 4160.975, 'title': 'Sql server management studio tips and efficient data editing', 'summary': 'Covers keyboard shortcuts and project organization, efficient data editing and navigation using alt key, f1, split screen, and object explorer details in sql. it also discusses managing sql server connections, including registering, organizing connections, accessing reports, and using custom colors.', 'chapters': [{'end': 4391.572, 'start': 4160.975, 'title': 'Management studio tips', 'summary': 'Highlights keyboard shortcuts like alt f1 for sp help, demonstrating the use of projects to organize queries in sql server management studio.', 'duration': 230.597, 'highlights': ['The chapter emphasizes the use of keyboard shortcuts like Alt F1 for SP help, which provides additional information about tables, aiding in development (quantifiable data: Alt F1 shortcut provided, SP help usage demonstrated).', 'It introduces the concept of projects in Management Studio, allowing the organization of queries within a project, providing a solution explorer similar to Visual Studio (quantifiable data: demonstration of creating a new project, adding and saving queries within a project).', 'The chapter also mentions tips for scripting and developing inside Management Studio, providing a comprehensive guide for efficient usage (quantifiable data: scripting views and demonstrating cool tricks).']}, {'end': 4650.599, 'start': 4392.393, 'title': 'Tips for efficient data editing and navigation in sql', 'summary': 'Provides tips for efficient data editing and navigation in sql, including using the alt key to edit multiple items at once, accessing help statements with f1, splitting the screen to work with long queries, and utilizing object explorer details to view table information and metrics.', 'duration': 258.206, 'highlights': ["Using Alt key to edit multiple items at once By holding down the Alt key and dragging vertically, one can edit multiple items at once, such as changing 'P' to 'PR' throughout a column.", 'Accessing help statements with F1 By pressing F1 on a function, one can directly access help statements, including syntax examples for functions like case statements.', 'Splitting the screen to work with long queries When working with lengthy stored procedures or queries, one can split the screen to keep a certain part steady while navigating and editing another section, allowing for better visibility and management of large code segments.', 'Utilizing Object Explorer Details for table information Object Explorer Details feature provides additional information about tables, allowing users to access metrics such as row count and data space used, enabling efficient data analysis without directly browsing the tables.']}, {'end': 4947.39, 'start': 4654.708, 'title': 'Managing sql server connections', 'summary': 'Introduces registering different server connections, organizing them into groups, accessing standard reports for database analysis, and using custom colors to differentiate between server environments in management studio.', 'duration': 292.682, 'highlights': ['You can register different server connections and organize them into groups such as dev, prod, and staging servers. This allows for easy access and management of multiple server connections, improving efficiency and organization.', 'Accessing standard reports for database analysis, such as disk usage by table, provides essential information like record count and data reserve. This feature aids in understanding database performance and usage, facilitating informed decision-making.', 'Using custom colors to differentiate between server environments in Management Studio can prevent accidental actions in the wrong environment. This visual indicator helps to avoid potential errors by clearly distinguishing between different server environments.']}], 'duration': 786.415, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Q8gBvsUjTLw/pics/Q8gBvsUjTLw4160975.jpg', 'highlights': ['The Alt F1 shortcut provides additional information about tables, aiding in development.', 'Projects in Management Studio allow the organization of queries within a project.', 'Tips for scripting and developing inside Management Studio are provided.', 'Using Alt key to edit multiple items at once by holding down the Alt key and dragging vertically.', 'Accessing help statements with F1 provides direct access to help statements for functions.', 'Splitting the screen allows for better visibility and management of large code segments.', 'Object Explorer Details feature provides additional information about tables.', 'Registering different server connections and organizing them into groups improves efficiency and organization.', 'Accessing standard reports for database analysis provides essential information for decision-making.', 'Using custom colors to differentiate between server environments in Management Studio can prevent accidental actions.']}], 'highlights': ['SQL Server Management Studio is a free tool that needs to be downloaded and installed separately.', 'Connecting to a server in SQL Server Management Studio involves specifying the server name or IP address, and then navigating through the Object Explorer to view server objects.', 'The Object Explorer in SQL Server Management Studio allows users to view and navigate server objects, such as databases and tables.', 'You can connect to multiple SQL servers simultaneously and disconnect from them using the disconnect button or by right-clicking on the server.', 'Different types of servers like relational database, multidimensional analysis services, tabular instance of Analysis Services, Integration Services, and Reporting Services can be identified by their respective icons.', 'Server properties such as server collation, memory usage, processors, security settings, connections, database settings, advanced settings, and permissions can be accessed under the server level of the Object Explorer.', 'SQL Server Management Studio provides integration services catalogs, SQL Server agent for scheduled jobs, and browsing databases. Mentions the key features of SQL Server Management Studio.', 'Creating and executing SQL queries in the query window, including insights on database context, query execution time, and result count. Explains the process of creating and executing SQL queries, highlighting important details about database context, query execution time, and result count.', 'You can execute SQL statements in Management Studio and view the results or error messages at the bottom of the tab, with 14 rows affected as an example.', 'Management Studio provides a shortcut key, F5, to execute SQL statements without needing to use the mouse, enhancing efficiency.', 'You can execute specific lines or multiple queries within the query window by highlighting them and then executing using the shortcut key.', 'Management Studio can run multiple queries in the same query window and display separate result sets for each query.', 'The bottom bar displays the number of rows fetched, aiding in visualization of large datasets, essential for dealing with high data volume.', 'Multiple query windows can be opened simultaneously, enhancing flexibility and efficiency.', 'Expanding the object explorer provides a comprehensive view of the database, improving the querying process.', 'The internet sales table contains 60,398 rows, demonstrating the large dataset size.', 'Scripting a table as a create to a new query window is explained, providing a practical demonstration.', 'Demonstrating the process of altering a view to add a column and resolving context issues, showcasing practical troubleshooting skills.', 'Paying attention to squiggly lines in Management Studio as an indicator of potential issues, illustrating proactive assistance.', 'Demonstration of refreshing the local cache in Management Studio to update the cache of objects, showcasing practical troubleshooting steps.', 'The chapter emphasizes the importance of scripting and querying throughout the processes of manipulating views, stored procedures, functions, and security settings.', 'The transcript provides a detailed exploration of security settings, including the management of users, roles, logins, and permissions at both the database and server level.', 'Describes the ability to perform CRUD (Create, Read, Update, Delete) operations directly from the Object Explorer interface.', 'Explains the usefulness of the View Dependencies option in understanding the dependencies of a table.', 'Describes the functionality of scripting options for generating SQL statements and selecting columns from a table.', 'SQL Server Management Studio provides the ability to analyze query performance using actual execution plans and live statistics.', 'The activity monitor allows users to monitor the status and history of agent jobs, such as the last run time and the next scheduled run, providing insights into job performance and scheduling.', 'The tool enables users to preview the execution plan of a query before running it, potentially reducing execution time.', 'Users can manipulate and export query results in formats such as text, file, and Excel for further analysis and processing.', 'The tool also offers client statistics to provide insights into query performance and potential network issues.', 'The query editor allows users to right-click and access a list of predefined code snippets for creating different database objects, such as stored procedures and tables, facilitating the process of creating new database objects.', "The functionality of 'insert snippet' allows users to easily access pre-defined code snippets for creating various database objects, improving efficiency and reducing manual coding efforts.", "The use of 'insert snippet' feature in the query editor provides predefined code snippets for creating specific database objects, such as stored procedures with output parameters, enhancing the development process by providing ready-to-use code templates.", 'Changing connections Users can easily change the connection on the query sheet, enabling seamless querying between different servers, like transitioning from dev to prod.', 'Template browser The template browser offers a wide range of functionalities, such as creating tables, adding columns with verbose templates, and utilizing a special combination of Control Shift M to fill out parameters efficiently.', 'Pin buttons The pin buttons allow users to hide and persist certain elements on the interface, providing a customizable and clutter-free working environment.', 'Executing queries and other functionalities Additional functionalities include executing queries, accessing estimated execution plans, disabling IntelliSense, tracing queries in SQL Profiler, and utilizing the database engine tuning advisor.', 'Snippet insertion The tool allows for snippet insertion, such as surrounding a select statement with a while loop or begin and end, providing quick and efficient code structuring.', "Demonstrates modifying a table in SQL training by adding a new column 'email' of type varchar(255).", 'Avoiding unnecessary recreation of the table ensures efficient database management and prevents data loss.', 'The demonstration emphasizes the importance of understanding and controlling the table modification process to avoid unintended consequences.', 'SQL Profiler provides insights into SQL Server activities and optimizes query performance.', 'Azure Data Studio is suitable for non-Windows environments and is built on Visual Studio Code.', 'Enabling line numbers facilitates remote collaboration and referencing specific lines and issues.', 'Adjusting font sizes in Management Studio improves readability, especially during trainings and presentations.', 'Enabling word wrap and visual glyphs enhances the understanding of long, wrapped lines and improves query readability.', 'The Alt F1 shortcut provides additional information about tables, aiding in development.', 'Projects in Management Studio allow the organization of queries within a project.', 'Tips for scripting and developing inside Management Studio are provided.', 'Using Alt key to edit multiple items at once by holding down the Alt key and dragging vertically.', 'Accessing help statements with F1 provides direct access to help statements for functions.', 'Splitting the screen allows for better visibility and management of large code segments.', 'Object Explorer Details feature provides additional information about tables.', 'Registering different server connections and organizing them into groups improves efficiency and organization.', 'Accessing standard reports for database analysis provides essential information for decision-making.', 'Using custom colors to differentiate between server environments in Management Studio can prevent accidental actions.']}