Author: Database Journal

Feed: Databasejournal.com - Feature Database Articles. Author: . In recent years, Microsoft has fully embraced the open source paradigm. One of the more prominent examples of this trend was providing the ability to host SQL Server 2017 instances on Linux, including running Docker-based SQL Server images (available directly from Microsoft Container Registry) on Kubernetes clusters. The release of SQL Server 2019 further extends the multi-platform capabilities by allowing for Kubernetes-based deployments of SQL Server Always On Availability Groups, delivering increased level of resiliency. In this article, the basic characteristics of these deployments are introduced. In order to better understand the ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . As recently as a decade ago, database administrators had to execute many complex and interesting tasks such as capacity planning, SQL performance tuning and most recently supporting business analytics in the big data environment. Today, however, most of these tasks are performed by artificial intelligence systems or the database itself. With so few important tasks left to perform, are DBAs really needed anymore? The Classic DBA As databases and their supporting software matured in the 1980s, IT departments had to grow or hire support staff to handle a large variety of technical ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . The advent of JSON (JavaScript Object Notation) has changed application programming, and, because of this, database vendors are adapting their products to make JSON easier to use within the database. Oracle is no exception, and with releases from 12.2 onwards Oracle has made JSON easily accessible from the PL/SQL engine. Even though JSON functionality is available in version 12.1, the enhancements implemented from 12.2 onward make JSON even easier to use. And, sometimes, making things easier can also break existing implementations. In this article, you’ll learn about what changed and how those ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen In my last tip Displaying the Object Explorer Details Pane in SQL Server Management Studio, you learned how to bring up the Object Explorer Details pane. In this tip, you’ll see how to use the “Filter” item in the Object Explorer Details window, to show a specific list of tables that contain a specific string of characters. In order to use the filter item, first bring up the Object Explorer Details pane for the tables in the WideWorldImportersDW database. I do this by selecting the “Tables” item under ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . By Gregory A. Larsen You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on. The Object Explorer Detail pane shows detailed information about an object that you have selected in Object Explorer. The information displayed depends on the object you have selected in the Object Explorer. You can open the Object Explorer Details pane two different ways.  The first way to ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . A programming language is only as clever as the person using it. Nearly all programming languages have a vast number of keywords, but it is still up to the developer to utilize these keywords correctly and efficiently. The more a developer utilizes a programming language, the more experience they gain, and the more their knowledge of the language and its keywords grows. Transact Standard Query Language (T-SQL) is a perfect example of a language that fits this model. Most developers, regardless of their skill level would know the commands for the basic ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Data development in a pure open source environment is possible. In larger enterprises and consulting firms, expect to interface with internal and external systems based on a mix of open source, homegrown code, and commercial technologies. Thousands of words could be devoted to pontificating on the ideal of pure environments. That is not this article. Open source database tools are found in many categories, including engine, modeling, script management, metadata, interactive query, semantic layer development, governance and more. TEAM ENVIRONMENT Open source database management tools are proper for professional developers. Is it ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Big data as an application (or as a service) is being supplanted by artificial intelligence (AI) and machine learning. Few new requirements for a big data solution have arisen in the past few years. All the low-hanging fruit (fraud detection, customer preferences, just-in-time re-stocking and delivery, etc.) have already been big data-ized. Is this the end of big data?  Big Data Evolution The first big data applications were for forecasting based on historical data. IT extracted operational data on a regular basis (usually nightly) to store within a stand-alone big data solution ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you ever heard of the identity cache? If not, it is just a cache that stores the next 1000 available identity cached values for a table. The identity cache was introduced in SQL Server 2012 and is used to improve the performance of generating new identify values. The problem with this cache is, if SQL Server should abort or be shutdown unexpectedly, SQL Server loses track of the values in the identity cache. When this occurs, SQL Server gets another set of 1000 identity values, and you end up with gaps ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you deleted a bunch of rows from a table that has an identity column value? Do you now find that when you insert a new row, you find that the identity column value was set to one higher than the highest identity column value that your table original had? This can happen if you make a mistake and inserted a bunch of rows by accident, and then you delete those accidentally insert rows without reseeding your identity value. If you have made this insert mistake or just delete a bunch of ... Read More