In the realm of database management, particularly with Microsoft SQL Server, understanding and optimizing complex queries is crucial for maintaining system performance and efficiency. As databases grow and complexity, the queries used to retrieve, update, or manipulate data can become increasingly intricate, potentially leading to slower response times and decreased application performance. This blog post […]
DH2i Introduces DxOperator for Kubernetes and SQL Server Integration
According to a new press release, DH2i has announced the general availability of DxOperator, a groundbreaking solution designed for the integration of Kubernetes and SQL Server. Engineered to address the increasing demands of businesses for efficient, scalable, and highly available (HA) database environments, DxOperator streamlines SQL Server container deployments on Kubernetes. Developed in collaboration with […]
Navigating SQL Server High Availability in Kubernetes for Improved Performance
There’s a compelling rationale for SQL Server not being the easiest pick for Kubernetes containerization initiatives. SQL Server environments are often characterized as formidable entities, known for their substantial scale and tendency to consume a significant portion of budget resources. Furthermore, SQL Server environments: Containers offer substantial potential for enhancing SQL Server’s agility, flexibility, and […]
A SQL Server Solution That Developers Should Know
Microsoft SQL Server is a critical database server for software developers, helping to store and retrieve data that other software applications request. That’s why SQL Server developers are in such high demand – and command average salaries close to six figures. Yet while SQL Server remains a go-to relational database management system, it has some significant […]
On-Premises/Cloud Hybrid for SQL Server Data Availability
Click to learn more about author Dave Bermingham. Today, organizations are buying cloud infrastructure services rather than on-premises hardware and software. For those companies running mission-critical SQL server environments, cloud vendors promise geographically distributed cloud data centers that make it easy to configure SQL server instances for high availability (HA) and/or disaster recovery (DR). This […]
StreamSets Announces Support for New Microsoft SQL Server 2019 Big Data Clusters
According to a new press release, “StreamSets®, provider of the industry’s first DataOps platform, announced today support and platform integration for Microsoft’s recently announced SQL Server 2019 Big Data Clusters. With this integration, SQL users are empowered to design and operationalize data pipelines for big data workloads without the complexities of coding for big data […]
PASS Adopts New Redgate Data Cataloging Solution to Stay Ahead of Data Privacy Concerns
A new press release reports, “PASS, the global community of data professionals, has become one of the first major users of a new solution from Redgate that automatically discovers and classifies sensitive data in SQL Server. The adoption of SQL Data Catalog will give the organization a clear picture of data across its entire estate, […]
Essential Open Source Big Data Tools
Click to learn more about author Paul Bates. The analysis of Big Data is a phenomenon that has gained considerable momentum in the past decade. The transition into the information age has made the analysis and visualization of Big Data vital to the success of any business. Data visualization tools enable researchers to gain insight into […]
Welcome to the New World of Curating Data, Not Owning it
Click to learn more about author Richard Macaskill. Faced with the new challenges of data protection – and increased levels of oversight – many of us working with SQL Server have come to the same conclusion. Quite simply, the column names and free text descriptions available to us to describe the data in our care (or […]
Data Modeling Trends in 2018
The Database Management and Data Modeling landscapes have evolved significantly in the past few years, from the traditional relational model to now include non-relational models as well. The growth of Big Data and its unstructured and semi-structured data formats, along with trends in Cloud Computing, Artificial Intelligence, Data Lakes, Machine Learning, Blockchain and others pushing […]