A Fine Slice Of SQL Server
Sven Loesekann deploys Apache Kafka 4.0:
With KRaft for Kafka ZooKeeper is no longer needed. KRaft is a protocol to select a leader among several server instances. That makes the Kafka setup much easier.
The new configuration is shown on the example of the MovieManager project.
Click through to see how you can install and configure Kafka without taking a dependency on ZooKeeper.
Leave a CommentLee Asher shows off a neat form of indexing:
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of this series, we used the GiST index type – and its lesser known cousin: SP-GiST – to turbocharge the performance of overlap queries. But GiST indexes are extremely versatile, with uses far beyond the examples I have used so far.
In this final article, we’ll explore some of the many other ways they can be used.
Click through for use cases, such as multi-dimensional BETWEEN operations (e.g., bid price between X and Y, and ask price between X1 and Y1), date intervals, and more.
Leave a CommentElizabeth Christensen reviews some security guidance:
The Center for Internet Security (CIS) releases security benchmarks to cover a wide variety of infrastructure used in modern applications, including databases, operating systems, cloud services, containerized services, and even networking. Since 2016 Crunchy Data has collaborated with CIS to provide this security resource for those deploying Postgres. The output of this collaboration is a checklist for folks to follow and improve the security posture of Postgres deployments.
The PostgreSQL CIS Benchmark™ for PostgreSQL 17 was just recently released.
Click through for more information on the CIS, as well as a link to the benchmark PDF and some tips around it.
Leave a CommentFor the past 1.5 years, the Microsoft Fabric Product Group Product Managers have been publishing a YouTube series featuring deep dives into Microsoft Fabric’s features. These episodes cover both technical functionalities and real-world scenarios, providing insights into the product roadmap and the people driving innovation. With over 80+ episodes, the series serves as a valuable resource for anyone looking to understand and optimize their use of Microsoft Fabric.
Click through for a link to the full series, as well as 22 separate episodes covering warehousing and data storage topics.
Leave a CommentAndy Brownsword doesn’t want any blockers:
We have a platter of transformations to use when constructing data flows in SSIS packages. Not all transformations are equal though, and some can catch us out with performance impact as data volumes scale.
In this post we’ll look at blocking transformations which can trip us up if we’re not careful with them (or avoid them).
Click through for some examples of blocking transformations, as well as some tips on how to manage them.
Leave a Comment