Home
Videos uploaded by user “Redgate Videos”
3. Generational garbage collection
 
04:01
3. Generational garbage collection
Views: 14461 Redgate Videos
Redgate SQL Source Control - an intro with Steve Jones
 
07:06
Steve Jones, SQL Server MVP and founder of SQL Server Central, explains how to share simple database changes between developers, using Team Foundation Server, SQL Server Management Studio, and Redgate SQL Source Control. Find out more and download a free trial at http://www.red-gate.com/sql-source-control
Views: 58702 Redgate Videos
How to push database changes to a Git remote repository in SQL Server Management Studio
 
01:54
SQL Server MVP Steve Jones shows you how to push changes to a Git remote repository straight from SQL Server Management Studio using Redgate's SQL Source Control. SQL Source Control is an add-in for Management Studio that lets you version control your database with your existing version control system. You can try SQL Source Control free for 28 days: http://www.red-gate.com/sql-source-control
Views: 15628 Redgate Videos
Compare and synchronize SQL Server schemas with SQL Compare
 
02:42
Introducing SQL Compare from Redgate, the industry's most trusted SQL Server comparison and synchronization tool. Used by 71% of the Fortune 100, you can Compare SQL Server schemas and deploy differences fast. Find out more and try it for free at www.red-gate.com/sqlcompare.
Views: 13267 Redgate Videos
6. Finalization
 
03:34
6. Finalization
Views: 5898 Redgate Videos
Six Scary SQL Surprises -- Brent Ozar
 
52:47
Six Scary SQL Surprises -- Brent Ozar
Views: 33337 Redgate Videos
2. .NET memory and garbage collection
 
04:01
2. .NET memory and garbage collection
Views: 7823 Redgate Videos
Code completion, formatting, and refactoring with SQL Prompt
 
04:15
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt Transcript: Introduction: SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You can rely on SQL Prompt for speed and accuracy, and save yourself time writing and exploring SQL, so you can focus on the important stuff. We’ve found it can speed up SQL coding by 52%. SQL Prompt has a host of features you’ll find useful everyday – from customizable snippets for the code you use most, which you can share with your team, to tab coloring, so you don’t execute code in the wrong environment. You can work super-fast with data from the Results grid – exporting them straight to Excel, or even scripting them out as an INSERT statement. Let’s jump into SQL Prompt and see these features in action. Code completion: By simply typing J, SQL Prompt autocompletes JOIN, gives you table suggestions, and JOIN conditions, so you don’t have to memorize column names or aliases. We’ve got a SELECT * here: SQL Prompt expands the wildcard so you can keep just the columns you need. Or, use the Column Picker, and hit Tab. These tooltips give you hints about keyboard shortcuts too. We’re using an alias here. SQL Prompt lets you easily rename an alias or variable – it’ll rename every alias in the script, which is great if you’re doing a bit of refactoring. Just right click, or hit F2. Hit Shift+F5 and SQL Prompt will execute just the statement under your cursor. And that tip about working with data in the Results grid? Just right click here, and choose to Export to Excel, copy as an IN clause, or script as an INSERT statement. Code formatting: Here’s how to format your code to your preferred style. Say you’ve got an organizational standard, but you want to code in your own style first. Go to Options, and under Format you’ll find a variety of settings including casing and commas. See the changes in the sample window, and save or export your settings to share with your colleagues. In the query window, just hit CTRL+K+Y to format your code. We’ve got new formatting options coming soon, too, so keep an eye out! Code snippets: Another handy feature in SQL Prompt is snippets, which save you time with repeat blocks of code. Type SSF then hit Tab and you’ll see SQL Prompt inserts SELECT * FROM. This is just one of many built-in snippets. You can easily customize these or create your own. Open the Snippet Manager and click New. Give your snippet a name, insert your code, and save. Now it’s ready for you to use. Or, you can access snippets from the Actions List, as well as comment out code, or surround it with a function like BEGIN/END. Code refactoring: If you’re refactoring code, SmartRename will help you out – it’ll catch every reference for you, so nothing breaks. This is built on Redgate SQL Compare, the industry’s most trusted comparison tool, so you’re in safe hands. From here, you can view actions, warnings, and dependencies. Other time savers: Here’s a little life saver for you – say you write a DELETE statement without a WHERE clause, SQL Prompt will ask you if you really want to execute it. Not only that, but you can specify colours for each environment, so it’s easy to see if you’re connected to development or production. Notice the green tab? That’s the color we’ve picked for development. This bright red one tells us we’re in production. You can set the colours at the database or server level. While we’re looking at tabs, check out Tab History. If SQL Server Management Studio crashes, SQL Prompt will reopen all your tabs the next time you launch SSMS. Or say you get distracted and close a tab without thinking, you can explore and reopen closed tabs. Summary: Alongside all this, we’re regularly adding new features and improvements based on the top suggestions from our users. To see how SQL Prompt can make you more productive and save you from some nasty errors, try it free at www.red-gate.com/sqlprompt
Views: 14566 Redgate Videos
How to set up DLM Dashboard in 2 minutes
 
03:00
Owen Priestly from the Redgate DLM Dashboard team gives you a step-by-step guide to setting up DLM Dashboard in just 2 minutes.
Views: 17902 Redgate Videos
Steve and Grant take the SQL Prompt Challenge
 
04:36
Which is faster - hand-coding, native IntelliSense, or Red Gate's SQL Prompt? SQL Server MVPs Steve Jones and Grant Fritchey put it to the test. You can try SQL Prompt yourself for free: http://www.red-gate.com/sqlprompt
Views: 8230 Redgate Videos
ANTS Memory Profiler 8
 
03:31
A quick demo of how ANTS Memory Profiler can help you find and fix memory problems in your .NET application.
Views: 8673 Redgate Videos
.NET Reflector overview
 
01:59
NET Reflector is an assembly browser for the Microsoft .NET platform that can be used to explore, analyze, decompile, and debug the contents of any .NET assembly. Find out more at http://www.reflector.net
Views: 9265 Redgate Videos
DBA in Space Winner: Meet the winner
 
04:18
Find out who has won Red Gate's DBA in Space competition and catch up with the highlights of the video quiz.
Views: 4699 Redgate Videos
Verify your backups - now! A warning from Grant
 
03:21
Grant Fritchey explains why you need to be verifying and restoring your SQL backups regularly, to avoid being hit by data when corruption you need your backups in a disaster recovery scenario. To make verification easier try SQL Backup Pro, which compresses, verifies, and encrypts SQL Server backups. Find out more or download a free trial at www.red-gate.com/products/dba/sql-backup/
Views: 1973 Redgate Videos
5. Large object heap and fragmentation
 
01:12
Description
Views: 4285 Redgate Videos
Oracle 12c RAC Upgrade - Syed Jaffar Hussain
 
01:24:49
Originally broadcast by Red Gate on August 29, 2013 In this webinar you will learn how to upgrade a 2 node Oracle 11gR2 clusterware and database to Oracle 12c, and the advantages of doing so. The session will also cover downgrading an upgraded cluster to a previous Oracle release. A live Q&A session with Syed Jaffar Hussain follows the presentation. More Oracle webinars at: http://www.red-gate.com/oracle-webinars
Views: 11468 Redgate Videos
DBA in Space Question 2 - Secret SQL Task
 
02:00
Investigate Miss Friday's remarkable discovery in Red Gate's sci-fi quiz and help her track an alien. Win a trip to space at www.dbainspace.com
Views: 1684 Redgate Videos
Setup CI for Oracle with Jenkins and Red Gate
 
07:18
This video explains how easy it is to setup continuous integration (CI) for your Oracle database with Jenkins the Deployment Suite for Oracle and Jenkins. Please visit http://www.red-gate.com/oracle-ci for further help and to view and copy the command line hooks.
Views: 8266 Redgate Videos
How to split a column without data loss with migration scripts in SQL Server Management Studio
 
05:51
Redgate's Owen Priestley explains how to deploy schema changes that involve data changes safely using SQL Source Control. He covers how to use migration scripts to override changes suggested by the SQL Compare engine, and goes through a column split step-by-step to show how it's done. SQL Source Control is an add-on for SSMS that lets you version control your database changes using your existing version control system. Find out more or try SQL Source Control for free: www.red-gate.com/sql-source-control To take part in the latest SQL Source Control beta, which covers improvements to migration scripts, visit http://www.red-gate.com/sql-source-control-5-beta
Views: 3687 Redgate Videos
DBA in Space Question 1 - Identify a Country from Space
 
01:53
Check out the UFO crash in the first episode of DBA in Space! Join Brad McGehee and Miss Friday for Red Gate's sci-fi quiz.
Win a trip to space at www.dbainspace.com
Views: 1715 Redgate Videos
SQL Prompt - find invalid objects
 
01:47
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt In this tip Data Platform MVP Ike Ellis explains how to use SQL Prompt to find invalid objects, so you can catch problems earlier in development and resolve issues quickly. For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi I'm Ike Ellis and I’m going to show you a cool feature of SQL Prompt. One of the issues with T-SQL is that doesn't really tell you when you have dependencies with your objects by default. So if I create a table right here like the customers table and then I create a stored procedure that's dependent on the customers table and then later on at some point I delete the customers table like I drop table customers, there's no warning here telling me that I've got a procedure using that table. Software development teams have struggled with this for a very long time. Often what they'll do is at one step in the release pipeline they'll drop and recreate all the stored procedures, or all their views or all their functions and then it will warn them to tell them that they have a dependency in the drop and recreation. But the problem with that is you have to remember to do it - you have to do it manually or automatically - and you actually have to do it at the last step of your release pipeline, well after you've made any schema changes or else you really didn't do anything useful. But one thing you can do with Redgate SQL Prompt is you can right-click on your database and you can say ‘find invalid objects’ and it will warn you, it will say “hey this store procedure is dependent on a table that's no longer here”. And if you get used to doing this you can do it way earlier in the development process. You can do it every day or at the end of every day or before you check in a source control, and then you can catch your problem before any other developer on your team finds the problem. We know that when a developer finds his own problem or her own problem that it's far cheaper, way easier to resolve, all good things. So thanks, hope you enjoyed this tip and you find out for yourself by downloading the latest SQL Prompt. Thanks have a great day.
Views: 1675 Redgate Videos
How to Install Redgate’s SQL Monitor
 
04:37
Get up and running with Redgate’s SQL Monitor in 5 minutes and start monitoring your SQL Servers. A step-by-step guide that shows in real-time how simple and quick the installation process is. Find out more about SQL Monitor at http://www.red-gate.com/monitor Or, try it free at http://www.red-gate.com/dynamic/products/dba/sql-monitor/download
Views: 5070 Redgate Videos
Obfuscating your .NET code with SmartAssembly
 
17:11
SmartAssembly® is a .NET obfuscator, error reporting, and feature usage reporting tool designed to help .NET developers produce better quality applications. This video explains how you can obfuscate and protect your .NET code. Find out more and get your free trial here: http://www.red-gate.com/products/dotnet-development/smartassembly/
Views: 15061 Redgate Videos
sql data generator overview
 
05:06
sql data generator overview
Views: 9823 Redgate Videos
Profiling an ASP.NET Application
 
04:00
Profiling an ASP.NET Application
Views: 6461 Redgate Videos
SQL Doc overview
 
02:37
How to document a SQL Server database with SQL Doc. Learn more or try SQL Doc free: http://www.red-gate.com/products/sql-development/sql-doc/
Views: 2375 Redgate Videos
Red Gate SQL Backup Pro 7: an introduction
 
18:17
Grant Fritchey goes through the new integrated backup verification and scheduled restores with automatic DBCC CHECKDB in SQL Backup Pro 7. Check out what's new in SQL Backup Pro 7 and download a free 14-day trial here: http://www.red-gate.com/products/dba/sql-backup/version-7/version-7
Views: 4725 Redgate Videos
Source Control for Oracle overview
 
01:42
Connect your team, Oracle database and source control system. Source Control for Oracle enables easy database source control with SVN & TFS. It lets you avoid human errors and remove manual processes. http://www.red-gate.com/source-control-for-oracle
Views: 9176 Redgate Videos
ReadyRoll overview
 
02:02
Develop and deploy databases in Visual Studio with migration scripts - a 2-minute intro. ReadyRoll is a capability of the SQL Toolbelt. Try it free: http://www.red-gate.com/readyroll/
Views: 9035 Redgate Videos
How to create a Snapshot with SQL Compare
 
02:37
In this quick how-to video Data Platform MVP Grant Fritchey shows you how easy it is to create and use a snapshot with SQL Compare. SQL Compare is the fastest way to compare & deploy SQL Server schemas. With our industry-standard tool you will save ime comparing and deploying SQL Server database schemas. Find and fix errors, and create deployment scripts in minutes. Try it now for free: https://www.red-gate.com/sqlcompare
Views: 522 Redgate Videos
SQL Prompt Results grid actions (copy as IN clause, Script as INSERT, Open in Excel)
 
01:52
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt In this tip Data Platform MVP Cathrine Wilhelmsen explains how to use SQL Prompt to quickly work with data from the Results grid in SQL Server Management Studio or Visual Studio. For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi I'm Catherine Wilhelmsen and I've got a SQL Prompt tip for you - actually I’ll give you three tips. Today let's take a look at the results grid features. If you execute a query and right-click in the results grid you will see three new options: copy as IN clause, script is INSERT, and open in Excel. Now if you ever select results like this and you want to copy and use them in an IN clause like this you probably know how time consuming it can be to add all those quotation marks and commas, escaping special characters, and so on - but not anymore. All you have to do is select the values or the entire column, right click and choose ‘copy as IN clause’. Paste this and you'll see that everything has been sorted for you, including the escaping of special characters. Now maybe you want to save these results. SQL Prompt makes it easy for you as well. Select the results, right click and choose ‘script as INSERT. This will open up this new query window for you with the create table insert into and drop table statements. Now just imagine the time saved from having all of this automated instead of having to write this by hand. Other times you might want to share the results with business users or business analysts and we all know how much they love Excel right? All you have to do is right-click and choose ‘open in Excel’ and there you go now you have spreadsheet that you can save share and send to other users. Now if you're a lazy, also known as an efficient developer like me I hope you'll find these tips as useful as I do. Get the latest SQL Prompt update and try it for yourself.
Views: 1898 Redgate Videos
How we build products at Redgate
 
03:31
Interested in joining the Product Team? Check out our current vacancies here: https://www.red-gate.com/our-company/careers/overview
Views: 371 Redgate Videos
Why we love working at Red Gate
 
04:18
Why we love working at Red Gate. For current job vacancies at Red Gate take a look at http://www.red-gate.com/our-company/careers/current-opportunities/
Views: 3162 Redgate Videos
How to copy the structure of a database using SQL Compare
 
02:27
In this quick how-to video Data Platform MVP Grant Fritchey shows you how easy it is to copy the structure of an existing database to create a brand new one using SQL Compare. SQL Compare is the fastest way to compare & deploy SQL Server schemas. With our industry-standard tool you will save ime comparing and deploying SQL Server database schemas. Find and fix errors, and create deployment scripts in minutes. Try it now for free: https://www.red-gate.com/sqlcompare
Views: 961 Redgate Videos
SQL Prompt Tips - #9 Add remove square brackets
 
01:54
In this short video, SQL Server MVP Grant Fritchey shows us some tips and tricks for SQL Prompt that you may not know. Video #5 is about adding and removing square brackets. Visit http://www.red-gate.com/products/sql-development/sql-prompt/ for more info about SQL Prompt.
Views: 6834 Redgate Videos
Performance Tuning with ASH and AWR Data
 
01:03:05
Presented by Kellyn Pot'Vin 30 August 2012 Summary: Since their introduction with Oracle 10g, AWR and ASH data has offered the Database professional enhanced performance reporting capabilities that previously were only gleamed via statspack and reporting queries. In this webinar, Kellyn Pot'Vin, Senior Technical Consultant at Enkitec, will take you through the requirements, reporting basics and differences of AWR and ASH. You will learn: - Reasons to use both reports. - A firm understanding of each report and its format. - Knowledge of the differing versions of the AWR report and when best utilized. - The power of ASH Reporting in real-time trouble-shooting. - Ability to utilize the reports at the command line and from Enterprise Manager. A live Q&A session with Kellyn Pot'Vin follows the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 113994 Redgate Videos
Using SQL Compare with Dynamic Data Masking  (DDM)
 
02:50
Dynamic Data Masking (DDM) is an exciting new feature in SQL Server 2016 that means you can centrally set a mask that's returned for a table column, instead of the actual data. This limits the information that's returned to certain users in a consistent and reliable way. What’s more, Redgate SQL Compare now safely and reliably handles your DDM changes. Data Platform MVP Steve Jones shows you how in this short video. To find out more, read Steve’s blog post at http://www.red-gate.com/blog/redgate-products/dynamic-data-masking Try SQL Compare free for 14 days: http://www.red-gate.com/sqlcompare
Views: 959 Redgate Videos
SQL Provision Demo
 
06:06
SQL Provision supports a database DevOps approach while keeping compliance central to the process. With the virtual cloning technology in SQL Clone, databases can be created in seconds using just MB of storage, allowing for isolated development and testing. Sensitive data can be anonymized or replaced with realistic data using Data Masker, to ensure data is protected as it moves between environments. Find out more or download your 14 day free trial at http://www.red-gate.com/sql-provision
Views: 2132 Redgate Videos
Best Practices for Database Deployment - Grant Fritchey
 
01:04:52
The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between a successful deployment and a failed or problematic deployment is all the preparation work you've done to ensure that you're deploying the right script, the right way to your production environment. In this session, Grant Fritchey, Product Evangelist at Red Gate, will explore best practices that you can implement to ensure that your deployments are as successful as they can be. This talk is from the SQL in the City Deployment Stairway Seminar, held at Red Gate in Cambridge, 10th January 2014.
Views: 9835 Redgate Videos
How to control code completion suggestions in SQL Prompt
 
01:57
In this Super SQL Tip Redgater Jamie Wallis explains how you can easily customize your code completion suggestions to pop-up less frequently or on demand. SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at https://www.red-gate.com/sqlprompt For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hi, I’m Jamie Wallis from Redgate Software and I’ve got another Super SQL Tip for you. Today I want to show you how you can customize the way SQL Prompt suggestions appear when you are coding. By default, SQL Prompt shows you the auto-completion box whilst you type, whenever it thinks it can make a useful suggestions for your code. So let me just open a new query in SSMS and when start typing you can see these helpful suggestions appear. This helps complete my code quickly and without errors. Whilst this is very useful, there may be times you don’t want these suggestions appearing continuously, particularly if you are working through something quite intricate. Rather than turning off suggestions completely, the best way to manage suggestions is to limit when they appear or to make them appear on demand. To edit how suggestions appear go to the SQL Prompt menu and open Options. You’ll see the Suggestions section here has settings for Behaviour, so go here and where it says “Automatically show suggestions after” simply change this number to something that will allow you to type without interruption. I’m going to go for 5000 milliseconds, and click OK. So this means that I can type continuously without interruption, but if I want SQL Prompt to give me suggestions then all I need to do is pause typing for 5 seconds and I’ll get the box pop up as normal. Alternatively you can change the settings to only show suggestions on demand. Go back into the Options menu. Keep “Show code completion suggestions” ticked, but untick “Automatically show suggestions”. Then when you write your code you can do so without interruptions, BUT if you do want a suggestion all you need to do is press Ctrl and SPACE to show the SQL Prompt box. It’s that easy! I hope you find this quick tip helpful. I’m Jamie Wallis from Redgate Software, thanks for watching.
Views: 795 Redgate Videos
SQL in the City Keynote - Simon Galbraith, CEO at Redgate
 
10:00
Why 2017 is the year of Database DevOps and why database professionals should lead the charge
Views: 764 Redgate Videos
Microsoft's DevOps Transformation Story
 
01:00:15
Microsoft embarked on their own DevOps journey reducing a three-year release cycle down to three weeks. Hear how their Developer Division made an Agile Transformation that scaled to support business needs. Microsoft used to release products on two to three-year cycles. It wasn’t unheard of to spend six months to a year planning, a year or more coding, and then months packaging everything up for delivery. It worked in the software generation in which it was born, but today’s environment requires a different approach. Market opportunities come and go more quickly, and customers demand increasingly faster turnaround to meet their needs. The Developer Division at Microsoft needed to adjust their business to respond to these changes. The old way was no longer working. Agile methods and practices offered some hope, but how could they bring Agile to an entire division, with hundreds of teams and thousands of engineers. For many years, they had been implementing Agile practices across their teams. What they discovered later is that their developers and testers had become very efficient at producing, but they had not yet changed their operations processes to be able to ship more quickly as well. They had created a bottleneck into the operations team. They needed to apply the lessons learned with becoming Agile and move into the world of DevOps. Donovan Brown is a Principal DevOps Manager on Microsoft's Cloud Developer Advocacy team. Before joining Microsoft, Donovan spent seven years as a Process Consultant and a Certified Scrum Master. Donovan has traveled the globe helping companies in the U.S., Canada, India, Germany, and the UK develop solutions using agile practices, Visual Studio, and Team Foundation Server in industries including Communications, Health Care, Energy, and Finance. Donovan was joined on the webinar by Stephanie Herr, Product Manager for Redgate's Database DevOps Solution.
Views: 3699 Redgate Videos
How Skyscanner release 95 times a day with Redgate in their DevOps toolchain
 
03:47
Ryan Crawford is Technical Manager in the Enablement tribe at Skyscanner, the world's fastest growing flight search and comparison web service. Ryan explains how Redgate's Database DevOps solution contributes to the efficiency of Skyscanner's development toolchains, which in turn help their development squads achieve astonishing release rates into production, fast and safely. Find out more at http://www.red-gate.com/solutions
Views: 1932 Redgate Videos
Create your style using the new formatting options in SQL Prompt
 
03:04
In this Super SQL Tip Software Engineer Andrei Rusitoru explains the fantastic new formatting options available in SQL Prompt 8 from Redgate. SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X Transcript: Hello, I’m Andrei Rusitoru and I work for Redgate software. Today I’m going to show you how to create your own style using the brand new formatting options in SQL Prompt 8. In SQL Prompt 8 we’ve added our completely re-designed formatting engine, giving you the best possible control over your formatting styles. Today we are going to go through the new SQL Prompt formatting options in SQL Server Management Studio, but exactly the same functionality is also available in Visual Studio. In SSMS I’m going to open the SQL Prompt menu at the top here and choose Edit Formatting Styles from the drop-down. This opens the Formatting styles window where you can see we have already included a couple of example styles to get you started. Keep an eye out for more of these in upcoming releases. Under “Your Styles” I’m going to click on Create a style to get started. It’s much easier to build your style on an existing one rather than starting completely from scratch. If you have created styles in previous versions of SQL Prompt then you will find them added here, and you can continue to work on them. I’m going to use Redgate’s Default Style as a base to build my new style on. So here are all the options. As you can see we’ve added a lot of functionality to allow you to tweak your style settings. Each of the main areas of SQL code has a section down the left hand side here, with sub-sections to help you easily find and manage these settings. To start with, let’s take a look at the GLOBAL settings and set the Whitespace options. For my tab behaviour, I want to use only tabs and I want 2 spaces in a tab. As you can see, there is some sample code at the bottom here that updates live as you change your settings so you can see exactly what impact your changes are having. If you want, you can change this to your own code if you have a query open. I don’t want to wrap my lines so I’m going to uncheck that. And finally I want to add a space before my commas. Let’s check how it looks… that looks good so I’m going to press Save. My new style has now been added to the menu on the left, and I can see a preview of what it does right here. This is going to be really helpful when I’ve created a few of these. I can also set the new style as my default active formatting by clicking Set As Active. I’m now going to go back in and change some other settings, so I click edit at the bottom here. I like to have my JOIN clauses right aligned to FROM, so I’m going to change that. I also like to have an extra line between them so I can see them easily. And I want my AND/OR operators to be aligned to the first list item, so I am going to go down here to the EXPRESSIONS section and change that under Operators. As you can see, there are lots of options to help you get your SQL looking exactly the way you want it and you can keep tweaking it until it looks perfect. You can create as many styles as you want too, so if you want a few different versions you can create them and then easily switch between them by simply right-clicking in your code, we are going to cover this in another video soon. So there you have it, it really is that easy to create your own style using the new formatting options in SQL Prompt 8.
Views: 1139 Redgate Videos
DBA in Space Question 4 - Computers in Space
 
01:25
Check out this question - it's a real headscratcher! Test your NASA knowledge in this round of Red Gate Software's sci-fi quiz.Win a trip to space at www.dbainspace.com
Views: 707 Redgate Videos
Redgate Data Platform Studio - a quick introduction
 
03:36
Product Manager David Bick guides you through a short introduction to Redgate's new Data Platform Studio, an ingeniously simple tool for migrating your data to Microsoft Azure, and managing it across the Microsoft Data Platform
Views: 499 Redgate Videos
The Deployment Suite for Oracle
 
02:28
The Deployment Suite for Oracle has been designed to speed up and increase visibility throughout your deployment process. Free 14 day trial at http://www.red-gate.com/oracle. From updating database changes to trouble-shooting errors, the tools are engineered to adapt to your infrastructure. So it doesn't matter where your dev, test, and production environments are -- they could be on premises, hosted in a data center, in the cloud, or a combination -- the Deployment Suite for Oracle will make your work easier. Deploy Oracle database changes Generate error-free scripts in seconds to update schema and table data changes. Automate deployment using the Wizard or command line tool, or export scripts for review and run them through your IDE. Diff Oracle schemas and tables Compare your environments and see highlighted differences in schema objects and table data side-by-side. Troubleshoot and fix errors caused by differences and ensure everything is in sync after deployment. Record Oracle schema structure and table data Create snapshots to save the structure of your schema at a point in time. Generate interactive HTML reports containing all of your schema differences and .csv files of your table data.
Views: 1545 Redgate Videos
[Old] Redgate SQL Compare v11 - a short introduction
 
03:38
WATCH THE NEW INTRODUCTORY VIDEO TO SQL COMPARE 12 AT https://youtu.be/jfvpr3fSTgI Redgate's Tom Austin shows you how to use SQL Compare, the industry standard tool for SQL Server comparison and synchronization. Try it free at http://www.red-gate.com/sqlcompare
Views: 4106 Redgate Videos
Oracle Enterprise Manager - Highlighted Questions and Extended Answers
 
58:24
Presented by Doug Burns 15 August 2012 Summary Doug Burns will take a number of questions asked during his recent webinars on OEM and answer them in more detail. This session presents a unique opportunity to build your knowledge on performance analysis using OEM, based on areas the audience requested more information on. In his recent webinars, Doug Burns looked at how the Oracle 10g Diagnostics Pack instrumentation and related OEM Performance Pages offered a new, more visual, performance analysis approach (How I Learned to Love Pictures: OEM Performance Page Fundamentals), and demonstrated the new features in OEM 12c that make OEM more compelling and useful in more situations (Falling in Love All Over Again: OEM 12c Performance Page Enhancements). For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 19116 Redgate Videos
Building APEX Plugins 101
 
01:04:15
Presented by Martin Giffy D'Souza 7th Sept 2011 Summary One of the hottest new features introduced in Oracle APEX 4 is the plug-in architecture. Plug-ins allow developers to create their own APEX objects in a declarative and supported manner. By creating your own plug-ins you can vastly expand APEX's current functionality to create anything you want in your application. You're only limited by your creativity, so the possibilities are virtually limitless! Martin Giffy D'Souza has created some of the most popular plug-ins available on the APEX plug-in community page. He has learned a lot about the architecture and what it takes to make a robust plug-in. In this session Martin will help get you started with creating your first APEX plug-in. He will also provide you with some tips and useful tools to successfully build plug-ins. This presentation will help you take your out-of-the-box APEX experience to a whole new level. A Q+A session with Martin follows the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 8022 Redgate Videos