How to Execute SSIS Packages from SQL Server Agent
Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow.
Mental Health and Wellness Day 2022
Our annual mental health and wellness day is slated to happen on 8th April 2022. We have a fantastic lineup,schedule as below. For more details on speakers and sessions refer to our blog post here.
Post-migration Validation and Optimization Guide
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
SQL Unit Testing reference guide for beginners
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.
Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
Advice for Business
Some advice from Steve and Sam Altman, whether you work in business or want to build one.
Machine learning K-Means applied to SQL Server data
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.
Has AI Changed Software Development?
Generative AI is everywhere, but especially in software development. Is it helping us? Steve has a few thoughts.
Dijkstra's Algorithm
Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of minimal cost between any pair of nodes in an undirected graph. His procedure is widely recognized as a fundamental tool for examining communication and transportation networks (eg. Google Maps) and is surprisingly simple. By his own admission, […]
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers