SQL Development

In this Skill Sprint, Scott Walz covers how to manage projects in Rapid SQL. This functionality is also available in DBArtisan. Learn how to create a new project and intialization options (from a database, existing file or version control). Then learn about the wizard options and how to complete the project setup. Then learn how to work with the project including Build Order, creating new Subfolders, adding files and objects, working with version control, updating project properties and more. ...

Finding the top offending statements for a specific workload can be hard if you are not using the best tool in your toolbox. On SQL Server 2012 and going forward you are able to leverage extended events which are included inside of SQL Server Manager Studio (SSMS) to build your first extended event to capture your workload.  The secret sauce to the Extended Event tools build into SQL Server Management Studio (SSMS) are the features you can use once your workload is captured. You can group ...

If you are using Microsoft SQL Server, here's a webinar that you won't want to miss. Make SQL Server Queries Run Faster Wednesday, May 20, 201511:00am Pacific / 1:00pm Central / 2:00pm Eastern Have you ever developed slowly running queries and wondered how to tune your own SQL Server queries? In this session, you will learn some T-SQL performance tuning tips from a DBA who has a developer background. We will go over how to identify bottleneck queries and how to measure them. We will go o...

Below I will list the steps to use any ODBC database with our Laravel installed. Sometimes our clients ask us to do a project with a database already established and unusual as might be Firebird or Interbase and the best way to access it is to use ODBC. First of all we have to download the driver that we will use. In our case we will use Firebird (or InterBase, use it) so we went to the website of FireBird we downloaded and installed. Now we have to uncomment (to uncomment we remove the, prece...

DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are responsible for; it can be very difficult, frustrating, and expensive. Given the complex interactions of applications, users and databases, new performance issues can arise almost as fast as old ones can be addressed. This session will simulate common performance problems on an Oracle server and then both identify those problems and provide effective solution...