Power BI Connections Management
Some time between January and now, a new preview feature was included in Power BI Portal. It’s […]
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 case, […]
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 […]
The post How Snowflake Creates and Detects Deadlocks appeared first on SQLServerCentral.
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.
Please head over to https://aka.ms/json-preview to learn more about the private preview of native JSON type and JSON […]
It seems like just last week we were just releasing Azure Data Studio 1.43 (oh wait, that was […]
Is your company hiring for a database position as of May/June 2023? Do you wanna work with the […]
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
.In this blog I will illustrate how we can ingest data from a blog storage to a […]
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
Introduction Sometimes we need to deploy many SQL Servers on Azure in the enterprise environment. Wwe can do […]
I just finished writing this book a few weeks ago, and as I read it, I thought […]
Goooood morning, party people! Today is the opening day of the annual Microsoft Build conference, an event focused […]
Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams. […]
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the […]
Introduction In this article, we will learn how to generate images with AI. This time we will work […]
The post PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL appeared first on SQLServerCentral.
The post Cache SQL Server Data in a .NET Web Application appeared first on SQLServerCentral.
Introduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as […]
The post The Journey to Team-based Development with Flyway appeared first on SQLServerCentral.
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […]
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Here’s what […]
It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your […]
Azure Marketplace is an online store that contains thousands of software applications and services built by industry-leading technology companies. […]
We are pleased to announce the support for SQL Server 2022 on SUSE Enterprise Linux v15 SP4. This […]
Problem A customer recently reported that they tried to build a SQL Server running on Windows Server […]