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

Pass

Idera – Free Tool – PowerShell Scripts for SQL Server

Idera

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
  • Work with policies and SQL Server logs
  • Manage security and backups
  • Create and manage SQL Server jobs
  • Get extended event information

Analysis Services

  • Connect to an Analysis Services instance
  • Get connection information
  • Get a list of databases
  • Backup databases and remove old backups
  • Restore a database

Integration Services

  • Start and stop services
  • Get package information
  • Provision a catalog
  • Publish a project
  • Modify catalog settings

Reporting Services

  • Start or stop services
  • Get instance information
  • Backup and restore encryption keys
  • Get configuration information
  • Get event log information

***NEW Scripts***
In-Memory Databases (SQL2014 and SQL2016)

  • Get overall utilization
  • Get size on disk
  • Get detailed utilization by table
  • Get checkpoint size

Query Plan (SQL2016)

  • Set Query Plan desired state
  • Set Query Plan data retention maximum size
  • Get Query Plan information
  • Get Query Store status

 

IDERA, Inc. Acquires Sencha to Strengthen Developer Tools Business

Idera

IDERA, Inc., the leading provider of database, development, and test management tools, today announced an agreement to acquire Sencha, a leading web application development platform. Sencha will be integrated with Embarcadero, IDERA, Inc.’s developer tools division.

The press release can be view at BusinessWire about this purchase in detail.  Now the question is what will happen with moving this product into the Embarcadero Developer product line ?   How does this affect the Rad Studio products that deal with the enterprise ?

Sencha provides software tools to build web applications across desktops, tablets and smartphones.  How will this work with FireMonkey is the real question.  The pricing structure for Sencha is extremely high for up to 5 developers.

Atanas Popov has been quoted “Sencha matches our mission to deliver agile development tools to our growing global community of developers,” said Atanas Popov, General Manager of Embarcadero. “It broadens the languages we support by adding JavaScript, and delivers broad synergies with our existing product portfolio. For example, Sencha Ext JS will provide a powerful Web Framework for Embarcadero’s RAD Studio to complement our native frameworks, including VCL for Windows and FMX for Mobile.”

Embarcadero has recently added CData support tools to allow access for VCL and FMX applications to use. So the idea of allowing Ext JS to have a IDE plug-in is not far off since it does have Visual Studio support.  What does this mean for other software products such as Elevate Software Web Development, no one knows.  This is a pretty major step so now let’s see what happens in the near future.  Based on Idera’s track record this will be a long term project to get all members on the same page.

 

Creating a Disaster Recovery Plan for your database (SQL)

Idera

 

Idera recently had a fantastic webinar that went over the creation of a disaster recovery plan concerning your databases.  This should be a high critical piece of work usually done by DBAs within a company.  Let’s go over a simple set of plans that depending on the type of company you are dealing with, can be done either large or small.

  1. Backups.  All backups should be done with incremental or full backups of your database.  There should be a protected network folder that contains the incremental in one and the full backups (usually done once a week) in a separate folder.  An incremental is a backup that contains only a snapshot of transactions that are done during a day while a full backup contains the entire database.
  2. Data model.  A data model provides a visual as well as a detailed layout of each database / table that provides a method for someone to read and understand how the data is stored.  It can be noted as a roadmap that contains the relationships between the tables within the database as well as the keys / indexes that work with the tables.
  3. User security profiles.  Each DBA should have a listing of the usernames / passwords in a safe area.  In the event a fellow member leaves but they had the password on a specific database you now possibly have the way in.  There are numerous companies that tend to not have that and during the exit interviews it becomes lost.
  4. Contact listing of people.  The contact list contains the individuals that have to be notified if a database is corrupted and has to be repaired or restored from the backups.  You can set the priority of each person as well.
  5. Checklist. By having a checklist of what to do in the event of a DRP it will keep you focus on getting everything back up and running.  One missed step could push you back thus delaying the recovery.
  6. Backup life cycles.  Each company is different and whether the backups are taken off site for now long and when are they removed / erased.  You have to plan this out and the usually lifecycle is between 3 months to a year.

These are only minor steps but at least they do enforce a DRP that any DBA needs to have in place prior to the disaster happening.

Baron Software

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 businesses in Singapore. In October 2016, local Telco StarHub was hit by a DDoS attack which led to an outage in broadband services of the customers.  Those are only the few that the news actually was released.  As with the United States, secure servers must be on everyone’s mind.   The Democratic party was hacked over the election cycle releasing countless emails.

Companies must formulate a response plan

 

Though the attacks are increasing, 40% of businesses do not have an incident response plan in place. While all attacks cannot be prevented, it is important to implement systems to notify internal and external stakeholders immediately to minimize disruption in case of unplanned system downtime. Failure to respond quickly can result in the loss of costly investments, opportunities as well as the reputation and customer loss.

Baron Software has provided the implementation plan for all companies to invest a strategic plan to educate the staff as well as securing the equipment from outside threats.  This is reality for anyone who has access to internal systems whether they are email or data servers, defense must be the plan of attack.  You can always request information on how Baron Software can assist in devising that response plan.

Idera Powerstudio

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 Develop SQL Code More Efficiently, Automate SQL Tuning and Profiling, Automate and Manage Complex Database Schema Changes and Perform Multi-platform Database Administration.

What does DB Powerstudio do for me ?

DB PowerStudio combines four innovative solutions to help build and maintain mission-critical database applications, streamline the database change management process, and quickly pinpoint and fix performance bottlenecks.

Get the following packages:

  • DBArtisan
  • DB Change Manager
  • DB Optimizer
  • Rapid SQL

DB PowerStudio is available in two editions: The DBA edition includes all four of the products listed above. The Developer edition includes Rapid SQL, DB Optimizer and DB Change Manager.

Supported Database Platforms:

  • Oracle 9i, 10g*, 11*, 12c*
  • SAP Sybase ASE 12.x – 15.x
  • IBM DB2 LUW 9-10.x and 11.x*
  • Microsoft SQL Server 2008, 2012*, 2014*, 2016*
  • InterBase 2007, 2009, XE, XE3, and XE7
  • Firebird 1.5, 2.0

Get the full support package that gives you the overall protection for any database you provide support for.

Baron Software has used the package for some time, we learn new ways of using the package and all of this works off of our notebooks when allowed to connect to the server.  Idera purchased the product from Embarcadero and is fully supportive for the future.

Baron Software

Idera rapid sql 2016

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 major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single common interface. Reduce training requirements and streamline collaboration among teams across the organization.

Easily Build Complex Statements

Save time and start developing SQL code immediately with Visual Query Building tools. Rapid SQL gives you the ability to construct complex SQL statements with point-and-click ease using the Visual Query Builder.

Quickly Construct and Execute SQL Code

The SQL IDE is a 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 au­tomatically. The IDE is also equipped with SQL code assist, real-time SQL syntax validation, and project level SQL file cataloging and search features.

Simplify Debugging

SQL Debugger simplifies the task of finding coding errors and lets you debug SQL Server, Oracle, Sybase or DB2 stored procedures as well as Oracle functions. The SQL Debugger features basic execution, line-by-line execution, breakpoint support, and other common debugging features.

Effectively Collaborate

Collaborate with your team with version control, reverse-engineering, and source code repository capabilities. Rapid SQL incorporates version control functions and build management facilities to help you manage and build projects. It provides seamless integration with most commercial version control packages and support for all operations including get, check-out, check-in, history, and differences.

 

After using Rapid SQL, productivity time has improved while design / development time has been reduced. The option to use various databases and allows a developer to quickly get the database designed, tested and released much faster.

 

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.

embarcadero-idera-separate

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-embarcadero

Idera will be selling the various database tools on their own web site along with ER Studio making the company and product line stronger then before.  Listed below are the features for each product in the Powerstudio.

DBArtisan

Perform Multi-platform Database Administration

  • Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) from one UI
  • Proactively manage space, data and performance with built-in analytics
  • Easily find and fix performance issues using intelligent diagnostics
  • Move schema and table data across different platforms with ease
  • Protect data security with view, grant and revoke of permissions

DB Change Manager

Automate and Manage Complex Database Schema Changes

  • Quickly roll out and reconcile database changes
  • Reveal, track, and report on database changes
  • Comply with database audit and reporting requirements
  • Protect data privacy within the database environment
  • Track changes from multiple major database platforms

DB Optimizer

Automate SQL Tuning and Profiling

  • Streamline tuning of SQL code on major DBMSs from one interface
  • Tune SQL like a pro with automated performance optimization suggestions
  • Tackle complex SQL queries with visual SQL tuning diagrams
  • Pinpoint problem SQL with database profiling of wait-time analysis
  • Load test alternative SQL queries in simulated production environment

Rapid SQL

Develop SQL Code More Efficiently

  • Create high-performing SQL code on major DBMSs from one interface
  • Easily build complex SQL statements with visual query builder
  • Quickly construct, analyze and execute SQL code with code analyst
  • Simplify debugging SQL code, functions, and stored procedures
  • Collaborate effectively across development teams with version control

Microsoft SQL Server 2016 is coming to Linux will provide the ability for users to have the features and additional security.

Microsoft SQL Server 2016Click 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 means for a small company using a web server, they now have an option to use the Linux OS but with a robust SQL Server that also contains high end security and has better performance with tasks while MySQL is a low end database manager.

One of the most important things to secure a database is to use a mature data abstraction layer that exists as close to the data as possible.  MySQL is disqualified because it runs best when you minimize your abstraction layers to all but the most simple tasks.  SQL Server abstraction layers are just fine to write.  It is by far more mature than MySQL, but remember that MySQL is cheaper for web hosting firms and always include it with their packages.

If Microsoft does increase their market share within a web hosting firm that will provide additional revenue as well as allowing mobile devices designed with Visual Studio to gain access almost anywhere.  The design and development of database software will be better off due to the fact that a complete database can be migrated from a Windows Platform to a Linux Platform, now that would be pretty awesome.

Percentage

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.

 

Embarcadero Logo
Case Study