10Feb 2017 by richard@baronsoftware.com

Cybersecurity risks expected to increase in 2017

Computer PC Tips - bits and bytes, Software Events
Cybersecurity risks expected to increase in 2017 The year 2016 saw a rise in cyber-attacks, both ransomware and distributed denial-of-service (DDoS) on small and large corporations globally.  Close to 50 percent of companies were subjected to some form of cyber-ransom attack in 2016.  Whether the ransom was medical records or street lamps, the threat is real.  Major DDoS attacks compromised many websites including prominent ones such as Twitter, Netflix, PayPal, and Pinterest. Yahoo was hit with the biggest data breach in history with information being stolen from 500 million user accounts. Company concerns should focus on these items Data loss. Service Outage. Damaged Reputation. Customers or partners loss. According to a recent report by Forbes on cybersecurity risks in Asia-pacific in 2017, DDoS attacks will be an increasing threat to…
Read More
10Feb 2017 by richard@baronsoftware.com

Ubuntu Heads List of Top Linux Servers in the Enterprise

Software development Concepts, Software Events
Ubuntu Heads List of Top Linux Servers in the Enterprise   ServerWatch has published a list of the top 10 Linux server distributions for 2017, with Ubuntu at the top. As the site said, that's no new distinction for Ubuntu. "At the top of almost every Linux-related list, the Debian-based Ubuntu is in a class by itself." ServerWatch said in its ranking report, published earlier this month. "Canonical's Ubuntu surpasses all other Linux server distributions -- from its simple installation to its excellent hardware discovery to its world-class commercial support, Ubuntu sets a strong standard that is hard to match." The complete top 10 list is: Ubuntu Red Hat Enterprise Linux SUSE Linux Enterprise Server CentOS Debian Oracle Linux Mageia/Mandriva ClearOS Arch Linux Slackware At the top of almost every…
Read More
28Oct 2016 by richard@baronsoftware.com

Baron Software Supports IDERA DB PowerStudio

Software Releases, SQL Tips
Baron Software Supports IDERA's DB PowerStudio Baron Software is a longtime user of IDERA's DB PowerStudio which assists us in dealing with our clients in maintaining thousands of mission-critical multi-platform databases that are used for data warehouses along with highly robust data driven applications,” said Richard Baroniunas, software developer and DBA at Baron Software. “It is an utmost priority to use the absolutely best monitoring and troubleshooting software for our clients. All of Baron Software’s clients deserve the best software tools on the market and that is the reason IDERA’s DB PowerStudio suite is always used. The newest release of DB PowerStudio will create the client satisfaction that is our main objective. Read the Businesswire article Read the full article at BusinessWire.  Idera DB Powerstudio for various SQL servers give you the utmost ability to…
Read More
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