Finally Cloud SQL for SQL Server is now available in beta. Announced at Google Next ‘19, Cloud SQL Server is a managed database service that makes it easy to set up, maintain, manage, and administer your SQL Server databases on…
Read More >Problem: You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below: “The selected Subscriber does not satisfy the minimum version compatibility…
Read More >Kubernetes is an open-source container orchestration system for automating deployment, scaling and management of containerized applications. Running a SQL Server database on Kubernetes is a topic of discussion nowadays as Kubernetes provides ways to provision stateful containers using persistent volumes,…
Read More >Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error: The error is succinct and direct to the point: “Please create a master key in the database or…
Read More >It is easy to get this one wrong. SSISDB is just a database, after all, and I’ve seen a number of instances where it was restored to another server and a number of errors/issues crop up. After all, SSISDB is…
Read More >SQL Server is one of the most adopted and widely-used database engines in the world. Almost every company either builds on it or uses some enterprise third-party software that uses it as the back end. For this reason, it makes…
Read More >SQL Server started having encrypted backups since SQL Server 2014. You can see the technical details here. This is a very good feature that allows you to encrypt the backups upon creation with different algorithms that will meet your security…
Read More >This blog post covers sharding a SQL Server database using Azure tools and PowerShell script snippets. Sharding, at its core, is breaking up a single, large database into multiple smaller, self-contained ones. This is usually done by companies that need…
Read More >It’s not uncommon to have authentication issues with Microsoft SQL Server. Not only with users trying to access the server, but problems related to the connection between instances, like AlwaysOn Availability Groups. The traditional way to solve it is well…
Read More >This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.
Read More >