Tag: SQL

May 10, 2017

MySQL is a bit of an attention hog. With relational databases supposedly put on deathwatch by NoSQL, MySQL should have been edging gracefully to the exit by now (or not so gracefully, like IBM’s DB2). Instead, MySQL remains neck-and-neck with […]

May 5, 2017

VMware, a global leader in cloud infrastructure and business mobility and Gold level member of Oracle PartnerNetwork, and Oracle have formed a new relationship to simplify management and enable advanced security features for Oracle’s suite of mobile business applications and […]

April 28, 2017

Apache Cassandra is a popular database for several reasons. The open source, distributed, NoSQL database has no single point of failure, so it’s well suited for high-availability applications. It supports multi-datacenter replication, allowing organizations to achieve greater resiliency by, for […]

April 27, 2017

Don’t bring the data to your computation if you can help it. Bring your computation to your data. Microsoft has heeded this cardinal rule of information science with the latest Community Technology Preview release of SQL Server 2017. Python can […]

April 26, 2017

Choosing the right database for the job can be a daunting task, particularly if you’re entertaining the full space of SQL and NoSQL options. If you’re looking for a flexible, general-purpose option that allows for fluid schemas and complex nested […]

April 6, 2017

In the past we’ve discussed the automated backup capabilities of SQL Server instances deployed to Azure virtual machines. These capabilities rely on either a dedicated Azure VM Agent extension or on system stored procedures introduced in SQL Server 2014, in […]

April 3, 2017

Every time you backup or restore a database SQL Server keeps history information about the backup or restore operation. The backup and restore information is captured and stored in the msdb database. This backup and restore information if left unchecked […]

March 30, 2017

Apache Spark, the extremely popular data analytics execution engine, was initially released in 2012. It wasn’t until 2015 that Spark really saw an uptick in support, but by November 2015, Spark saw 50 percent more activity than the core Apache […]

March 23, 2017

Progress now provides day one support for Hadoop Hive, Spark SQL, MongoDB and more with latest update to its DataDirect suite of connectivity tools. With this new upgrade, Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions […]

March 21, 2017

In a blog last year we discussed database archaeology, which is another name for database reverse engineering. Database reverse engineering is the inverse to normal development. We start with an application and work backwards to understand the software and infer […]

February 27, 2017

For years we’ve seen the database market split between the traditional relational database and new-school NoSQL databases. According to Gartner, however, these two worlds are heading toward further consolidation. As Gartner analyst Nick Huedecker opines, “Each week brings more SQL […]

December 8, 2016

Database backups and restores are key to developing a secure environment for users’ information. A  trusted backup plan is a requirement for on-premise and cloud instances. SQL Server database backups in Azure, in either an IaaS or PaaS implementation, introduces […]

December 5, 2016

A data warehouse is a database that is dedicated to data analysis and reporting. It combines data from multiple operational applications and provides one location for decision-support data. A warehouse should have one staging table for each source table or […]

November 28, 2016

One source of information you should absolutely make a part of your regular reading is the blog “SQL Server According to Bob”. It’s written by not one, but two guys named Bob—Bob Dorr and Bob Ward. These individuals are perhaps […]

November 17, 2016

Those who wondered what it would be like to run Microsoft SQL Server on Linux now have an answer. Microsoft has released the first public preview of the long-promised product. Microsoft also wants to make clear this isn’t a “SQL […]

November 14, 2016

When it comes to assigning value to different components in today’s IT environment, it would be a serious mistake to underestimate the value of data and databases. Whether you are looking to reduce downtime and speed up your database-centric application […]

November 9, 2016

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. Traditionally, your only option was to use SQL Server authentication. With the advent of Azure […]

July 21, 2016

IDERA has released SQL Query Store Optimizer, a new tool in its portfolio of database monitoring tools to help database administrators (DBAs) manage and troubleshoot SQL Query Stores. The free tool aggregates the Query Stores of all databases per instance […]

July 8, 2016

As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for […]

June 6, 2016

SQL Server 2016 became generally available on June 1, as scheduled previously by Microsoft. Described as the “biggest leap forward in Microsoft data platform history” in a Microsoft Developer Network blog, the new release provides improvements in real-time operational analytics, […]