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: 54875 Redgate Videos
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: 13180 Redgate Videos
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: 12663 Redgate Videos
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: 8745 Redgate Videos
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: 13301 Redgate Videos
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: 1806 Redgate Videos
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: 3324 Redgate Videos
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: 7354 Redgate Videos
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: 1539 Redgate Videos
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: 4593 Redgate Videos
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: 11041 Redgate Videos
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: 4485 Redgate Videos
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: 1709 Redgate Videos
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: 1486 Redgate Videos
Redgate’s Jake Sigrist talks you through the new reporting module in SQL Monitor V7. The module allows you to view reports on your entire SQL Server estate as well as creating custom reports for individual servers/instances. Find out more by visiting http://www.red-gate.com/products/dba/sql-monitor/ Or Download the free 14 day trial http://www.red-gate.com/dynamic/products/dba/sql-monitor/download
Views: 2312 Redgate Videos
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: 112219 Redgate Videos
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: 417 Redgate Videos
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: 6412 Redgate Videos
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: 18867 Redgate Videos
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: 829 Redgate Videos
SQL Monitor Technical Author Anne Edwards explains how to check baselines for SQL Server performance metrics in Redgate SQL Monitor. To find out more about SQL Monitor, and to try it for yourself, visit http://www.red-gate.com/monitor
Views: 859 Redgate Videos
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: 1873 Redgate Videos
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: 3317 Redgate Videos
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: 14783 Redgate Videos
SQL Clone provisions database copies in seconds using MB of storage. Once you've prepared your database image, you can start creating multiple clone. Watch Steve Jones create, edit and delete full database clones in seconds. Find out more and download a 14 day free trial at www.red-gate.com/sqlclone
Views: 665 Redgate Videos
So many database problems are due to the natural tendency of programmers to confuse the three basic ways that data is recorded: a human-readable 'presentation' form, the ‘storage’ form, or the ‘data-interchange’ form. If you get it wrong the problems start to mount up. Dates are a classic example. Phil Factor argues that Big Data becomes overwhelming only because you’re storing it wrong. By the very act of storing data in its interchange or presentation form in NoSQL document databases, you’re going to need all the space and processing power you can get. There will never be enough space
Views: 472 Redgate Videos
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: 7740 Redgate Videos
Using ANTS Memory Profiler to debug an unmanaged memory problem.
Views: 3967 Redgate Videos
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: 601 Redgate Videos
In this quick how-to video Data Platform MVP Grant Fritchey shows you how easy it is to map and unmap tables and columns 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: 1771 Redgate Videos
Colin Millerchip, Product Manager at Redgate, talks you through the major new features in SQL Monitor 5, including: Active Directory integration (00:39) AlwaysOn Availability Group support (03:12) To find out more about SQL Monitor, visit http://www.red-gate.com/sql-monitor Hi, my name is Colin Millerchip, and I work at Redgate Software as part of the team developing SQL Monitor. In this short video, I’m going to introduce you to SQL Monitor version 5, which we released in October 2015. If you’re not already familiar with SQL Monitor, it’s a performance monitoring tool that helps you manage your SQL Servers, keeping an eye on them 24-7, alerting you to problems or potential problems, helping you diagnose the root cause and keep your system up and running. Version 5 has two new key features: Active Directory integration, and improved support for AlwaysOn Availability groups. First let’s look at active directory integration. You can now use your Windows credentials to log into SQL Monitor, and SQL Monitor administrators have granular control over which monitored servers you’re allowed to see. This improves collaboration, for example, giving developers performance insights into production servers without having to grant them direct access, or allowing your BI team to only see the servers relevant to them. It also allows you to share administration duties across the team of people who are looking after your servers. • To enable Active Directory integration, go to the configuration tab, and select Authentication settings • By default, SQL Monitor uses built-in credentials. To switch to using Active Directory, select this as your authentication type • Now configure the domain information, and select a service account used to query Active Directory. • Save the settings… • … and SQL Monitor will ask you to set up a user as administrator. • Now, log on as this admin user • … and you’ll be taken to the configuration screen where you can add in any users who you want to give access to SQL Monitor. You can add individual users, as well as groups of users. • For standard users... • … not only do you restrict their access to some of the more administrative features of SQL Monitor (such as license management), but you can restrict the set of servers that they can manage. All the authorization data is stored internally within SQL Monitor, so this feature requires no modification of your Active Directory domain. Now let’s look at Availability Group support. Prior to version 5, SQL Monitor would monitor the host machines running an AlwaysOn Availability Group, but had no Availability Group-specific features. With the introduction of version 5, SQL Monitor now has Availability Group overviews, alerts, metrics, and wait types. The overview gives you an at-a-glance view of the status of an Availability Group. You can see information about Availability Group specific alerts, … the state and failover information for availability replicas and databases, … and key availability database metrics Further details on the meaning of these fields and their values can be found in the product documentation. As for any other overview in SQL Monitor, you can drill through to see details of alerts or metrics. SQL Monitor version 5 ships with 7 pre-configured Availability Group alerts, covering areas including the health of Availability Group databases and replicas, whether replication is falling behind, and whether replication is slowing down query execution on your primary replica. Of course, these metrics can be extended using SQL Monitor’s custom metrics and alerting features. Time series data collected from Availability Groups is available within the Analysis tab. Again, you can drill through from the overviews to get this. If you are already monitoring host machines running Availability Groups, then upgrading to version 5 will automatically provide you with these Availability Group features. As to other changes in version 5: If you’re already familiar with SQL Monitor version 4, you’ll have noticed that we’ve refreshed the user interface, both to make it easier to use, and to make the UI faster and more responsive. Other changes include improving the stability of the monitoring service; and SQL Monitor version 5 has been fully tested against community technology previews of SQL Server 2016, If you want to find out more about SQL Monitor, visit the product homepage, and better still give us a call to arrange a demo or get help with your evaluation.
Views: 1456 Redgate Videos
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: 9650 Redgate Videos