Archives du mois : janvier 2023
Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions
In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all […]
Microsoft Drivers 5.11.0 Beta 1 for PHP for SQL Server ...
We recently released the next beta of the Microsoft Drivers for PHP for SQL Server, version 5.11.0-beta1. This […]
Backup Directly to a GCS Bucket in SQL Server 2022
SQL 2022 is here! Lets back up our databases directly to GCS! This new release of SQL Server […]
Dealing with Mutually Dependent Databases in Flyway
The post Dealing with Mutually Dependent Databases in Flyway appeared first on SQLServerCentral.
Encrypt SQL Server Stored Procedures to Protect Source Code
The post Encrypt SQL Server Stored Procedures to Protect Source Code appeared first on SQLServerCentral.
Publishing a Public Power BI Report from Google Sheets
I find Power BI to be a neat way to visualize data, one that allows interactivity to help […]
Dealing with Cross-Server Database Dependencies in Flyway Projects
The post Dealing with Cross-Server Database Dependencies in Flyway Projects appeared first on SQLServerCentral.
Configure Contained Availability Groups for High Availability in SQL Server ...
The post Configure Contained Availability Groups for High Availability in SQL Server 2022 appeared first on SQLServerCentral.
SQL Server Management Studio (SSMS) 19.0 Released!
The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here! This is […]
HPE SGLX – The new Azure VM extension for SQL ...
Overview Mission critical SQL Server instances have the need to utilize high availability and disaster recovery features […]
[Video] Office Hours: Ten Minutes of SQL Server Answers
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. […]
Azure Data Studio 1.41 release
We are less than one month into 2023 and already have a new release of Azure Data Studio […]
Bite-Sized Office Hours: Q&A on TikTok
Wanna learn about SQL Server and the Microsoft data platform, but you don’t wanna sit through long videos? […]
Dynamic ELT with Azure Data Factory – Part 3 of ...
In Part 1 of this series, we talked about the art of data ingestion where we discussed the […]
DevOps Process Improvement Course
The post DevOps Process Improvement Course appeared first on SQLServerCentral.
Azure Cosmos DB & Power BI Incremental Refresh
Abstract Data Collection has become a daunting task with the ever-growing amount of data. The growth of […]
Azure Functions and Managed Identity: More Secrets
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I […]
How to Import Data in Power BI Using R
Introduction In this article, we will learn how to import data in Power BI using R. R and Python […]
A Version Control Strategy for Database DevOps
The post A Version Control Strategy for Database DevOps appeared first on SQLServerCentral.
SQL Server Function Examples with JSON Files
The post SQL Server Function Examples with JSON Files appeared first on SQLServerCentral.
CTEs, Views or Temp Tables?
I’ve just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several […]
Released: General Availability of Microsoft.Data.SqlClient 5.1
We have released for general availability Microsoft.Data.SqlClient 5.1. This .NET Data Provider for SQL Server provides general connectivity […]
SQL Server point in time recovery
The post SQL Server point in time recovery appeared first on SQLServerCentral.
Verifying Trees
Introduction Employee lists in organizations are often maintained in spreadsheets or database tables which record each employee’s number, […]
PostgreSQL Basics: Roles and Privileges
Authentication Authorization Verify that the user is who they claim to be. This can be through password, […]
Best practices assessment -Arc-enabled SQL Server
If you are a Database Administrator (DBA) and responsible for managing, securing, protecting, and governing hundreds of SQL […]
The 20th Anniversary of the SQL Slammer Worm
Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high […]
Technical Considerations for Data Ingestion – Part 2
In part one of this series, we discussed how to prepare for the ingestion of data. In this […]
Understanding Windows Server Cluster Quorum Options
The post Understanding Windows Server Cluster Quorum Options appeared first on SQLServerCentral.
Manage Data Over Time with SQL Server MERGE Statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 8 items […]
[Video] Office Hours: Back Live on Twitch Again
After I stopped selling live classes, I took some time off all live broadcasting period. It was a […]
SQL Server containers on Kubernetes with S3-compatible object storage – ...
One of the new features introduced with SQL Server 2022 is the ability to connect to any S3-compatible […]
Synapse Serverless: CETAS requires DFS to work
CETAS is the acronym for Create External Table As Select. This allow us to export the result […]
How to Install SQL Server and the Stack Overflow Database ...
To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an […]
.NET 7更新之网络，是你期待的吗?
最新的.NET 7现已发布，我们想介绍一下其在网络领域所做的一些有趣的更改和添加。这篇博文讨论了 .NET 7 在HTTP 空间、新 QUIC API、网络安全和WebSockets方面的变化。 HTTP 改进了对连接尝试失败的处理 在 .NET 6 之前的版本中，如果连接池中没有立即可用的连接，（处理程序上的设置允许的情况下，例如HTTP /1.1中的MaxConnectionsPerServer，或 HTTP/2中的EnableMultipleHttp2Connections）新的 HTTP […]
How to work with web information, maps, and images in ...
Introduction Sometimes, we need to work with images in Power BI. This tip will be about the FIFA […]
Bucket Sort Algorithm in Python to Sort a List of ...
The post Bucket Sort Algorithm in Python to Sort a List of Array Values appeared first on SQLServerCentral.
Hotfix: JDBC Driver 10.2.3 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.3. The update addresses a few […]
Hotfix: JDBC Driver 11.2.3 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.3. The update addresses a few […]
Development with SQL in containers on macOS
There are a bunch of tools available for developing with SQL on macOS, including the mssql extension […]
Database Sharding to help Improve Performance and Maintenance Tasks
The post Database Sharding to help Improve Performance and Maintenance Tasks appeared first on SQLServerCentral.
Using pre-commit to prevent simple mistakes
There is no level of experience or intelligence where we cease to make mistakes. The simpler the mistake […]
How to Create a Box and Whisker Plot in Power ...
The post How to Create a Box and Whisker Plot in Power BI Desktop appeared first on SQLServerCentral.
Working with time series data in SQL Server 2022 and ...
Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the […]
[Video] Office Hours: Bad Hair Edition
I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take […]
Office Hours: Bad Questions Edition
Normally, y’all post and upvote great questions at https://pollgab.com/room/brento, but in today’s episode, y’all upvoted some stinkers. Buckle […]
Translate Text Data using Azure Cognitive Services
Executive Summary Microsoft Azure has several capabilities, including support for Machine Learning (ML) and Artificial Intelligence (AI). One […]
Useful Commands for Snowflake Transactions
The post Useful Commands for Snowflake Transactions appeared first on SQLServerCentral.
3 Ways to Debug T-SQL Code
Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers […]