Cumulative Update #5 for SQL Server 2022 RTM
The 5th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
The 5th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
The 21st cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible […]
We’ve released hotfix packages for the following drivers to address important security issues: Microsoft ODBC Driver 17.10.4 […]
One of the things I love about SQL ConstantCare® (which happens to be free this month, by the […]
Microsoft SQL Server Machine Learning Services is a feature that allows you to run Python, R, Java, and […]
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 […]
This is the second post in a series discussing changes between SSMS 18.12.1 and SSMS 19, and new […]
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.
Microsoft.Data.SqlClient 5.2 Preview 2 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
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.
Toward the end of May the SQL Tools team released SQL Server Management Studio (SSMS) 19.1, which had […]
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting […]
We have released version 1.3 of the SQL Server 3rd Party Backend for Django. This release contains support […]
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 […]
I am often appalled by the lack of knowledge of the database culture of computer scientists in general […]
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 […]
One question that we hear quite often is why we chose to capitalize the first three letters when […]
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.” […]
Introduction As per Microsoft, Desired State Configuration (DSC) is a management platform in PowerShell that enables you to […]