SQL Development

See Embarcadero at SQL Saturday Austin - January 31, 2015 Celebrate SQL Saturday with Embarcadero Embarcadero is proud to sponsor SQL Saturday in Austin, TX this Saturday. Whether you’re a long time user of our popular DBA and SQL development tools or just getting to know us, we look forward to seeing you there. Stop by the Embarcadero table to win a Surface Tablet Meet members of our Austin team at the Embarcadero table. Get answers to your questions and enter for a chance to win a Microsoft Surface tablet. Learn why SQL Server professionals choos...
Webinar: Find it. Fix it. Real-World SQL Tuning Cases Don't miss out on this great webinar coming up next week. Find it. Fix it. Real-World SQL Tuning Cases Webinar presentation featuring Karen Morton and Scott Walz There are many ways to find SQL that is performing poorly. The hard part is what to do with a bad SQL statement once you have it. In this webinar, several real-world examples will be reviewed to help you learn how to evaluate poorly performing SQL. Each example will demonstrate a commonly occurring SQL performance problem and prov...
Integrated cross-platform SQL IDE for increased database development efficiency Have you ever wanted a SQL IDE that would help you code SQL for multiple platforms using a Single IDE? Now you can! with Embarcadero's RapidSQL XE6, it gives you the ability to code and debug SQL for some of the most demanding platforms like Microsoft SQL Server Oracle IBM DB2 SAP Sybase ASE MySQL JDBC ODBC and many more! We also have a Technical Preview of Teradata as well. Some of the key features! On-the-fly SQL syntax alerts, semantic validation, and SQL parsing Visual quer...
Tips Database Developers Must Know Reading Query Plans If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help you in understanding those “problems” which DBA might be talking about. We would talk about tips which can help a developer in finding some of these “problems” themselves without getting deeper into the topic. There are two types of plans SQL Server engine can generate in general. They are known as “Estimated” plan and “Actual” plan. When we ask for estimated plan from SQL...
Tags: Pinal Dave
Performance Improvements with SQL Server 2014 Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make it superior from previous model. If the features are appealing, generally customers are positive and forthcoming to pay little more than previous model. Above theory holds good for SQL Server product as well. It is expected that SQL Server 2014 should have some new enhancements as compared to the predecessor SQL Server 2012 version. In SQL Server 20...

Check out more tips and tricks in this development video: