[Video] Office Hours in Glacier Bay, Alaska
Thankfully, we didn’t hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:29 gb DBA: Hi Brent, I have over 200 …
PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones)
The post PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones) appeared first on SQLServerCentral.
PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones)
The post PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones) appeared first on SQLServerCentral.
Analyze Data with a Serverless SQL pool in Azure Synapse Analytics
Introduction Azure Synapse Analytics is a Powerful analytics tools which combines data warehousing and big data analytics together. Azure Synapse provides two types of SQL Pool – Serverless and Dedicated. The dedicated SQL pool is designed for high per …
Power BI Connections Management
Some time between January and now, a new preview feature was included in Power BI Portal. It’s a new Manage Connections and Gateway window, still in preview. We can access this option on the Settings button. In the past, the connections were rela …
AWS Aurora Cut Our Database Costs for SQL ConstantCare® – Again.
In May, Amazon brought out a new Aurora I/O Optimized Serverless instance type. By switching to it, we cut our database costs by 43% overnight, saving us about $1,200 per month. No strings attached. Just lower prices. So what’s the magic? Well, c …
Poll: Are You Going Back to In-Person Events?
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}) …
First speakers announced for Summit 2023
The post First speakers announced for Summit 2023 appeared first on SQLServerCentral.
Bing Chatbot vs ChatGPT
Introduction In previous articles, we learned about ChatGPT, and we also learned how to use it to generate T-SQL code. This time we will talk about the Bing Chatbot vs ChatGPT. Also, we will first talk with the Bing Chatbot and show its features and th …
How to Filter a SQL Server Audit with a Predicate
The post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral.
SQL WHERE LIKE to Construct More Efficient Queries
The post SQL WHERE LIKE to Construct More Efficient Queries appeared first on SQLServerCentral.
Flyway and SSDT: Merging Work from a Branch
The post Flyway and SSDT: Merging Work from a Branch appeared first on SQLServerCentral.
MuleSoft Integration with Azure Key Vault
Introduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As part of the data integration, the MuleSoft Anypoint Environment needs source system and target system login credentials stored in …
SQL Server 2022: Capture SQL Anti-Patterns
One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended event allows to identify anti-patterns on the SQL queries sent to the server. An anti-pattern in this case is some code that the SQL Server …
Microsoft Fabrics Monitoring Tenant Settings
I am sure you have heard about all great announcements from last Microsoft Build. If it’s not the case, most of them are present in this Book of news 2023. One of the BIG announcements was the Preview of Microsoft Fabric. Microsoft Fabric is an end-to- …