Using Windows Security and Encryption with Flyway
The post Using Windows Security and Encryption with Flyway appeared first on SQLServerCentral.
The post Using Windows Security and Encryption with Flyway appeared first on SQLServerCentral.
MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible […]
One of the things I love about SQL ConstantCare® (which happens to be free this month, by the […]
This is the third part of a series on SQL Server Dynamic Data Masking. The first part […]
It’s back to lighter fog-friendly clothes as the ship pulls into San Francisco and I answer your questions […]
Introduction I want to share the solution to the problem of searching for prime numbers using T-SQL. The […]
Introduction I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was […]
One of the big principles of our SQL ConstantCare® monitoring product – which happens to be free this […]
Last week, I asked if y’all had been to in-person regional events before, and whether you were going […]
So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, […]
The post Flyway for SQL Server Data Tools Users appeared first on SQLServerCentral.
This article explains the T-SQL scripts that can be used to manage and monitor the disk space on […]
The post Multiple Relationships on the same Table in a Power BI Data Model appeared first on SQLServerCentral.
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, […]
The post Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders appeared first on SQLServerCentral.
Article Overview In this article, we will discuss the ‘COPY’ functionality of PostgreSQL database which is one of […]
The post Data Transfer from Snowflake to Azure Blob using Synapse Analytics appeared first on SQLServerCentral.
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting […]
I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento. Here’s what we […]
This is the second part of a series on SQL Server Dynamic Data masking. The first part […]
Thankfully, we didn’t hit any icebergs or glacier droppings, so I put my comfiest coat on to answer […]
The post PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones) appeared […]
The post PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones) appeared […]
Introduction Azure Synapse Analytics is a Powerful analytics tools which combines data warehousing and big data analytics together. […]
Some time between January and now, a new preview feature was included in Power BI Portal. It’s […]
In May, Amazon brought out a new Aurora I/O Optimized Serverless instance type. By switching to it, we […]
Two short yes/no questions about regional & national conferences: var gform;gform||(document.addEventListener(« gform_main_scripts_loaded »,function(){gform.scriptsLoaded=!0}),window.addEventListener(« DOMContentLoaded »,function(){gform.domLoaded=!0}),gform={domLoaded:!1,scriptsLoaded:!1,initializeOnLoaded:function(o){gform.domLoaded&&gform.scriptsLoaded?o():!gform.domLoaded&&gform.scriptsLoaded?window.addEventListener(« DOMContentLoaded »,o):document.addEventListener(« gform_main_scripts_loaded »,o)},hooks:{action:{},filter:{}},addAction:function(o,n,r,t){gform.addHook(« action »,o,n,r,t)},addFilter:function(o,n,r,t){gform.addHook(« filter »,o,n,r,t)},doAction:function(o){gform.doHook(« action »,o,arguments)},applyFilters:function(o){return gform.doHook(« filter »,o,arguments)},removeAction:function(o,n){gform.removeHook(« action »,o,n)},removeFilter:function(o,n,r){gform.removeHook(« filter »,o,n,r)},addHook:function(o,n,r,t,i){null==gform.hooks[o][n]&&(gform.hooks[o][n]=[]);var e=gform.hooks[o][n];null==i&&(i=n+ »_ »+e.length),gform.hooks[o][n].push({tag:i,callable:r,priority:t=null==t?10:t})},doHook:function(n,o,r){var t;if(r=Array.prototype.slice.call(r,1),null!=gform.hooks[n][o]&&((o=gform.hooks[n][o]).sort(function(o,n){return o.priority-n.priority}),o.forEach(function(o){« function »!=typeof(t=o.callable)&&(t=window[t]), »action »==n?t.apply(null,r):r[0]=t.apply(null,r)})), »filter »==n)return r[0]},removeHook:function(o,n,t,i){var r;null!=gform.hooks[o][n]&&(r=(r=gform.hooks[o][n]).filter(function(o,n,r){return!!(null!=i&&i!=o.tag||null!=t&&t!=o.priority)}),gform.hooks[o][n]=r)}}); I've […]
The post First speakers announced for Summit 2023 appeared first on SQLServerCentral.
Introduction In previous articles, we learned about ChatGPT, and we also learned how to use it to generate […]
The post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral.
The post SQL WHERE LIKE to Construct More Efficient Queries appeared first on SQLServerCentral.
The post Flyway and SSDT: Merging Work from a Branch appeared first on SQLServerCentral.
Introduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As […]
One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended […]
I am sure you have heard about all great announcements from last Microsoft Build. If it’s not the […]
You’re responsible for the health and performance of your company’s SQL Servers. You can’t afford most monitoring products […]
En route from San Francisco to Juneau aboard the Ruby Princess, I stopped to hit a few of […]
dbatools bring us a set of useful commands to manage sequence objects in SQL Server. In this article, […]
I’m still blown away that I have a blog post here that says, “Last updated: 21 years ago.” […]
The post How Snowflake Creates and Detects Deadlocks appeared first on SQLServerCentral.
Introduction As per Microsoft, Desired State Configuration (DSC) is a management platform in PowerShell that enables you to […]
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […]
The post Flyway and SSDT: Extracting a DACPAC from a Flyway-managed Database appeared first on SQLServerCentral.
This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is […]
<sigh> Okay, so, the last few Cumulative Updates have had known issues around broken remote queries using the […]
Introduction to Google Cloud SQL Google Cloud SQL is a powerful and easy-to-use managed database service that lets […]
This week was Microsoft Build. After four years, it was back in person in Seattle and available online. […]
The post Getting Started with Ensemble AI Models in SQL Server appeared first on SQLServerCentral.
The post A First Look at PostgreSQL Monitoring in SQL Monitor appeared first on SQLServerCentral.
Is your company hiring for a database position as of May/June 2023? Do you wanna work with the […]