18Oct 2016 by richard@baronsoftware.com

Getting performance statistics for cached stored procedures

SQL Tips
Getting performance statistics for cached stored procedures It is always extremely important to maintain your SQL server to the utmost efficiency.    DBAs review the database structure and whether certain pieces such as stored procedures, triggers, etc. can be tuned even further.  One of the areas that will be discussed are the stored procedure which can be used during any time as well as day.  Dynamic Management Views and Function (DMVs and DMFs) to identify resources used by stored procedures DMVs and DMFs were introduced in SQL Server 2005 and are able to obtain figures only for those stored procedures that have execution plans in the procedure cache.  The SQL Server engine starts gathering information about the performance of a stored procedure the first time that  the plan is placed in the…
Read More
09Jun 2016 by richard@baronsoftware.com

Expedite SQL with Idera Rapid SQL 2016

SQL Tips
Expedite SQL Development with Rapid SQL 2016 • Write code across different database platforms - Produce high-performing SQL code across DBMS platforms (Oracle, SQL Server, DB2, Sybase and PostgreSQL) from one user interface. • Develop SQL code quickly and efficiently - The SQL IDE is a clean, slick development environment, ideal for creating and modifying SQL code geared to the needs of application developers. Real-time quick fixes flag and correct inefficient SQL automatically, saving you time. • Simplify debugging SQL code - Simplify the task of hunting down and eliminating coding errors. SQL Debugger lets you debug SQL Server, Oracle, Sybase or DB2 stored procedures as well as Oracle functions, improving productivity. Click to view the data sheet Develop High Performing Code Across DBMSs Create high-performing SQL code on all…
Read More
08Mar 2016 by richard@baronsoftware.com

Microsoft SQL Server 2016 is coming to Linux

Software development Concepts, Software Events, Software Releases, SQL Tips
Microsoft SQL Server 2016 is coming to Linux will provide the ability for users to have the features and additional security. Click the image for more information about SQL Server Microsoft will be releasing a version of their SQL Server 2016 for Linux which is a major step in the world domination plan.  With about 35 percent of the web servers in the world using Linux as their operating system this will open new revenue streams for Microsoft. As you can see from the grid below the percentages of SQL Servers within companies.  The area where MySQL rules is on the web server which puts both at about 35 percent each on market share.  If Microsoft begins the move towards Linux the development tools will be released shortly.  What this…
Read More
07Jan 2016 by richard@baronsoftware.com

Embarcadero and Baron Software Powerstudio case study which monitors SQL Performance

Rad Studio Delphi Development, Software development Concepts, Software Events, Software Releases, SQL Tips
Embarcadero and Baron Software has issued a case study that demonstrates the benefits of using Microsoft SQL Powerstudio product line.  Powerstudio is a robust package that monitors SQL performance and can provide assistance for clients to update or create tables, stored procedures, etc. for various SQL servers some being Oracle, Microsoft SQL and many more.  The detailed report can be view by clicking here.  
Read More
13Oct 2015 by richard@baronsoftware.com

IDERA Announces Intent to Acquire Embarcadero, Expands Position in Database Management and Developer Tools Markets

SQL Tips
Officially Idera is about to acquire Embarcadero this week after final agreements are made.   Idera press release provides you with some additional information concerning the purchase.  At this moment no one really knows what this means for the Rad Studio product as well the other database packages that Embarcadero sells nor what will happen with the company name. At this point the Embarcadero staff members are pretty happy and developers will have to wait until something is provided by Idera.  Usually in purchases older products that have no relevance are stopped and particular development sites are dropped to condense the groups. and finally Idera managers take over after the internal review of what is happening. Some things that can changed in the next year or so: EDN (Embarcadero Developers Network) which…
Read More