05Mar 2018 by richard@baronsoftware.com

Idera offers free webinar on data modeling in the cloud

Idera, SQL Tips
Idera offers free webinar on data modeling in the cloud Data modeling is the process of documenting a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow. The diagram can be used as a blueprint for the construction of new software or for re-engineering a legacy application. Traditionally, data models have been built during the analysis and design phases of a project to ensure that the requirements for a new application are fully understood. A data model can be thought of as a flowchart that illustrates the relationships between data. Although capturing all the possible relationships in a data model can be very time-intensive, it's an important step that shouldn't be rushed. Well-documented conceptual, logical and physical data models allow stake-holders to identify errors and…
Read More
03Oct 2017 by richard@baronsoftware.com

Fortune’s List of the 10 Most Powerful Women in Information Technology

Software Events
Fortune's List of the 10 Most Powerful Women in Information Technology Each year for the past two decades, Fortune Magazine has released its list of the Most Powerful Women in the world. The list, which includes 51 women, is based in part on the success of their businesses. Facebook COO Sheryl Sandberg has been credited with provided the operational leadership that has helped drive the social network’s growth since founder Mark Zuckerberg hired her in 2008. Facebook’s 57 percent ad revenue growth in 2016, coupled with Sandberg’s support for women’s health and immigration reform made her one of the most powerful women in the world. IBM CEO Ginni Rometty has been facing some challenges with slumping revenue, but she is still regarded as one of the most successful chief executives…
Read More
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