Featured Database Articles
There are several high availability solutions which can be used with SQL Server and while these high availability solutions ensure maximum up-time for your databases, you need to set up backup and restore strategies to recover the data or minimize the risk of data loss in case a failure happens.
Continuing his discussion of a somewhat unorthodox method of managing Azure SQL Database that involves directly invoking REST APIs, Marcin Policht shows some of the unique benefits of REST APIs by demonstrating their unique capabilities that are not available via PowerShell.
Before you can read data from your database you need to understand how to insert data into the tables in your database. There are a number of different ways to accomplish this. Greg Larsen explores the methods you can use when inserting data into a database table using the INSERT statement.
Oracle can exhibit 'strange' behavior with the sql_id values in V$SESSION, but just because the sql_id is NULL that doesn't mean Oracle isn't processing a long-running statement.
In Oracle releases 10.2.0.x and later join processing can be made more efficient by the use of Bloom filters, primarily to reduce traffic between parallel query slaves. Read on to learn more.
You're running processes in parallel; is it really faster? Sometimes it may not be; read on to see why parallel processing may be creating more work than you'd expect.
Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse. It is therefore only natural that your big data application must be integrated with the existing warehouse.
Big data applications do not need the same infrastructure support teams as do more common applications. As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.
Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?