03Oct 2017 by richard@baronsoftware.com

Register for the PASS summit 2017

Idera, Software Events
PASS summit 2017 The PASS summit brings you three days of inspiring, jam-packed educational opportunities focused on the Microsoft Platform, professional connections, and new skills and know-how you can put to use immediately. Don’t forget to stop by the IDERA booth for your chance to win one of 3 apple watches! What to expect this year at the summit: More than 5,000 registrants from more than 2,000 companies Representatives from 52 different countries Over 200 technical sessions presented by industry experts from around the world including more advanced sessions than years before 70+ hours networking with MVPs, experts and peers Inspiring keynote speakers that include Rohan Kumar, Rimma Nehma, and Heather Ritchie, An opportunity to connect, share and learn
Read More
02Oct 2017 by richard@baronsoftware.com

How to purge Microsoft SQL email Items

Computer PC Tips - bits and bytes, SQL Tips
How to purge Microsoft SQL email Items There are times that housecleaning older mail in your database needs to be done.  A simple scheduled task can be done every month to purge what is no longer necessary.  SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove these mail history unless it is required for auditing or other purposes. As always make sure you have your backups done prior to running any sort of removal in the event you did something incorrectly.  By purging you are reducing the amount of wasted space in the msdb database that could be used for other things activities. Simply running the following statement using T-SQL you can check the amount of database mails that have been processed from…
Read More
30Sep 2017 by richard@baronsoftware.com

Idera – Free Tool – PowerShell Scripts for SQL Server

Software development Concepts, Software Events, Software Releases
Idera - Free Tool - PowerShell Scripts for SQL Server Idera is offering a free tool of Powershell scripts for Microsoft SQL server.  You can simply your SQL Server Administration with 89 free Powershell scripts by simply providing some information and it is an amazing assortment of scripts.  The scripts will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis. 89 example scripts for managing SQL Server objects Initialize PowerShell SQLPS module and work with databases Scripts for Analysis, Integration, and Reporting services Experimental support for SQL Server 2016 New scripts for exploring In-Memory databases and query store features Powershell script break down Database Engine Connect to a server instance, manage databases and publish scripts…
Read More
13Sep 2017 by richard@baronsoftware.com

New Build 4 Now Available for Version 2.26 of ElevateDB from Elevate Software

Software Events, Software Releases
New Build 4 Now Available for Version 2.26 of ElevateDB from Elevate Software Elevate Software is  pleased to announce that build 4 for version 2.26 of ElevateDB is now available. The software release provides the following: Altering a Table in a Database with Dependent Views Can Result in a Table Checksum Mismatch COMPARE DATABASE Generating Incorrect Statement Terminators for ALTER Statements If you own the subscription model or are looking for a database manager that works with Delphi this is the package to go with. ElevateDB is licensed per-developer, and includes royalty-free distribution. License management isn't required at all, and the money that you used to pay to the database engine vendor is now your profit to keep. What does ElevateDB do ? You don't need to use a feature-crippled…
Read More
05Sep 2017 by richard@baronsoftware.com

Coding Boot Camps should they go or be used ?

Software development Concepts, Software Events
Coding Boot Camps should they go or be used ? Within the past week, two well-known and well-established coding bootcamps have announced they’ll be closing their doors: Dev Bootcamp, owned by Kaplan Inc., and The Iron Yard, owned by the Apollo Education Group (parent company of the University of Phoenix).  Not the most strongest places to learn how to code but some industry observers have suggested that the market may be merging in the coming months. It appears that there are simply more coding bootcamps – almost 100 across the US and Canada – than there are students looking to learn to code.   Remember these courses are geared for a quick turnaround in studying and learning how to program.  I never mentioned that these were gifted academic schools since on average…
Read More