27Oct 2016 by richard@baronsoftware.com

Saving SQL Column Headers Results

SQL Tips
Saving SQL Column Headers Results Sometimes you can run into problems that tend to take up time and could have been solved in a minute.  One of these strange problems is when you attempt to save a Microsoft SQL query result grid to a CSV file. Using Microsoft SQL Server Management Studio (SSMS) Now most of DBA or Developers tend to use the Microsoft SQL Server Management Studio (SSMS) to do the necessary general SQL work.  As you expected when you execute a query the results grid appears displaying the results.  I as countless others tend to copy the information and save it in an excel spreadsheet to do further analysis.  But there are times you may need to save the information into a CSV file for the purpose of…
Read More
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
17Oct 2016 by richard@baronsoftware.com

Halt and catch fire season 3

Book Reviews, TV Show
Season 3 of Halt and Catch Fire The season finale of Halt and catch fire was shown last week for a solid 2 hours.  The entire show has gone from the personal computer start to about the 1990s with the advent of Windows 3. The series has had it's moments with characters that tend to be flaky but came up with inventive ideas that brought social up with ease on social interactions (Mutiny), personal computers that were built to take on the business world (Giant) and finally what IPOs can do to a person. Flawed Characters that know how to party! The characters have grown but in reality some of them would have been in prison for the shady dealings such as "Joe", a person who destroyed the personal computer that…
Read More
08Mar 2016 by richard@baronsoftware.com

Idera and Embarcadero separate target businesses

Rad Studio Delphi Development, Software development Concepts, Software Releases
  Idera and Embarcadero separate target businesses   Idera and Embarcadero have officially separated their businesses for software development Rad Studio that contains Delphi / C++ Builder and the Idera database tools.  This is a fantastic step in going forward and bringing both web sites with a fresh look on the future. Embarcadero will continue to enhance the Rad Studio product that comprises of Delphi / C++ Builder plus the various tool kits that would enhance the product line. Seattle is the latest version that provides the software developer to build applications for Windows, databases, mobile devices and much more. The Ultimate Application Development Platform for Windows 10, Mac, Mobile and IoT. Rapid Development Rich UI/UX Measure User Activity Build for Enterprise Internet of Things Embed Data Everywhere Idera will…
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