Featured Database Articles
Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. Read on to learn the different ways to load data into SQL Data Warehouse.
The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In our article, we will introduce its main characteristics.
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
Extended string lengths can be very beneficial but they can also be an impediment to index and constraint creation. Read on to see what the problems are and how to get around them.
Histograms have improved greatly over the years, yet there are still those who won't use them. Read on to learn what they do and why they may not be as bad as some say.
Interestingly, you can create a B-tree index on a BLOB column; read on to see how to do it and just how useful, or not, it might be.
For the new entrepreneur who wants to implement a significant digitally-based service or sell products to customers on-line, the need to get their application written and implemented quickly is a strong one. Luckily, there are several services available to the business that wants to get its new application up and running in minimal time. In this article, we will concentrate on why you would consider having someone else host your database data, and what are the risks in doing so.
For most companies, IT-related hardware and software maintenance is costly, time-consuming and requires hiring and retaining a support staff of operating system and database management system specialists. Delegating these responsibilities to an outside firm allows a new application to be developed and implemented more quickly. However, there are issues with delegating database support to an outside service. In this article, we will concentrate on how these environments scale with application growth, especially if the data and services are stored in the cloud.
Vendors now offer Database as a Service (DBaaS) as part of a bundled solution of managed IT services. Delegating database management services to an external provider may have many benefits, but delegating database administration services has many hidden dangers. In this article, we focus on how delegating data modeling to an outside service can cause problems when making application updates, changing business rules or doing performance tuning.