Sites anglophones


30%-off health checks and self-service via credit card – no waiting!

Publié le 8 juin 2023 sur sqlskills.com - paul randall
 

We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget approval, just click and go! Once you purchase the health check, you get access to our health check pac …

[Video] Office Hours at Sea: Leaving Juneau

Publié le 8 juin 2023 sur brentozar.com
 

I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:42 Dirty_Pages: You mentioned recently how much you swear, what is your favorite swea …

 

Unmasking SQL Server Dynamic Data Masking – Part 2 – Setting up Masking

Publié le 7 juin 2023 sur simple-talk.com
 

This is the second part of a series on SQL Server Dynamic Data masking. The first part in the series was a brief introduction to dynamic data masking, including use cases. The focus of this blog will is setting up masking and some base examples. Config …

 

[Video] Office Hours in Glacier Bay, Alaska

Publié le 7 juin 2023 sur brentozar.com
 

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)

Publié le 7 juin 2023 sur sqlservercentral.com
 

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)

Publié le 7 juin 2023 sur sqlservercentral.com
 

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

Publié le 7 juin 2023 sur sqlservercentral.com
 

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

Publié le 6 juin 2023 sur simple-talk.com
 

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.

Publié le 6 juin 2023 sur brentozar.com
 

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?

Publié le 5 juin 2023 sur brentozar.com
 

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

Publié le 5 juin 2023 sur sqlservercentral.com
 

The post First speakers announced for Summit 2023 appeared first on SQLServerCentral.

Bing Chatbot vs ChatGPT

Publié le 5 juin 2023 sur sqlservercentral.com
 

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

Publié le 5 juin 2023 sur sqlservercentral.com
 

The post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral.

SQL WHERE LIKE to Construct More Efficient Queries

Publié le 2 juin 2023 sur sqlservercentral.com
 

The post SQL WHERE LIKE to Construct More Efficient Queries appeared first on SQLServerCentral.

Flyway and SSDT: Merging Work from a Branch

Publié le 2 juin 2023 sur sqlservercentral.com
 

The post Flyway and SSDT: Merging Work from a Branch appeared first on SQLServerCentral.


Pages :