SQL Server 2019 in Containers
SQL Server 2019 in containers are a fast way to get started with SQL Server 2019, and can be used throughout your data estate from development to production.
2020-05-21
Additional Articles
Run SQL Server Agent Job from SSIS
While we can schedule SQL Server Agent jobs and SSRS report subscriptions, the actual time that we want to run them is dependent on when certain processing in our SSIS packages is completed. We also have certain business rules surrounding launching these jobs that we need to enforce which the built-in scheduling capabilities cannot accommodate. For example, we execute a SQL Server Reporting Services (SSRS) report subscription every Monday at 8:00AM but we want to skip it if the current week coincides with our month end processing which will also execute a report subscription for the same report. Can you provide a solution that we can use to accomplish this?
2020-05-19
Six reasons to version control your database
For most application developers, it’s unthinkable to work without version control. So why is the database any different? This blog lays out 6 clear benefits to applying version control best practice to your database alongside your application.
2020-05-18
How SQL Clone and SQL Change Automation enable seamless Database Branch Switching
Learn how to use SQL Clone together with Git hooks and SQL Change Automation to branch your database in Git as quickly and simply as your code.
2020-05-15
Why Ordering Isn’t Guaranteed Without an ORDER BY
If your query doesn’t have an ORDER BY clause, you can’t reliably predict the order of your results over time. Sure, it’s going to look predictable at first, but down the road, as things change – the indexes, the table, the server’s configuration, the size of your data – you can end up with some ugly surprises.
2020-05-15
A Hybrid Approach to Database DevOps
A flexible approach to Database DevOps where the team maintain the current state of the database in version control, during development, and then at key stages generate and test the migrations script that will deploy the changes to the target database, safely.
2020-05-14
How to ACTUALLY save money in the cloud with SQL Server
We have all heard migrating to the cloud can save you money and there are several ways moving your SQL Server workloads to the cloud can save your organization money. But, there are also missteps that can eat away at the savings, performance and even your availability creating instead an expensive, ineffective, difficult to manage cloud infrastructure.
2020-05-14
Introduction to Azure SQL Database Instance Pools
In one of the article, Considerations for Deploying Azure SQL Database Managed Instances, recently published on this site, basic characteristics of Azure SQL Database Managed Instance were described. Its biggest selling points include nearly full compatibility with on-premises SQL Server deployments, support for SQL Server Agent, and additional security associated with its Azure virtual network integration.
2020-05-13
The Underground Map of SQL Monitor
The "metro map" of SQL Monitor, with sightseeing tips and essential stops along every line....
2020-05-13
Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space
In the third and final article of the series, Shel Burkow demonstrates several designs that cover many-to-many relationships, attribute closure, and solution space with Cassandra tables.
2020-05-12
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat BCA KCU DIPONEGORO 082225313145??WA CS
WhatsApp 082225313145 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat BCA KCU VETERAN 082225313145 WA CS
WhatsApp 082225313145 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Alamat BCA KCU GALAXY 082225313145 WA CS
WhatsApp 082225313145 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers