Create an Empty Database Using SQL Server Integration Services
Recently, we were working on a small project. The requirement was to create an empty copy of an […]
Archives de l’année : 2023
Use DDL Triggers to Automatically Keep SQL Server Views in ...
The post Use DDL Triggers to Automatically Keep SQL Server Views in Sync appeared first on SQLServerCentral.
Make data more human with Azure OpenAI and Azure SQL
[alert type= »important » heading= »Guest Post »]Valentina is a Microsoft Specialist, focusing on Azure OpenAI. She has been working with […]
Finding and Tuning Expensive Stored Procedures using SQL Monitor
The post Finding and Tuning Expensive Stored Procedures using SQL Monitor appeared first on SQLServerCentral.
Data Oriented Cloud Security Mechanisms
Introduction Cloud Computing escalates the security risks of an organization. This happens because of the extended trust boundary […]
Three Use Case Examples for SQL Subqueries
The post Three Use Case Examples for SQL Subqueries appeared first on SQLServerCentral.
Cumulative Update #20 for SQL Server 2019 RTM
The 20th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Cumulative Update #3 for SQL Server 2022 RTM
The 3rd cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
5 reasons to join us at Securely Migrate and Optimize ...
The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft […]
[Video] Office Hours: Ask Me Anything About Azure SQL DB ...
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. Here’s what we […]
SQL ConstantCare® Population Report: Spring 2023
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for […]
Announcing Azure Data Studio 1.43
Our regular users may have noticed we typically release Azure Data Studio every other month. As such, this […]
How to secure legacy ASP.NET MVC against Cross-Site(CSRF) Attacks
Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered […]
PASS Data Community Summit registrations are open!
The post PASS Data Community Summit registrations are open! appeared first on SQLServerCentral.
WIT Engagement Survey For Female Speakers
The post WIT Engagement Survey For Female Speakers appeared first on SQLServerCentral.
Announcing .NET 8 Preview 3
.NET 8 Preview 3 is now available. It includes changes to build paths, workloads, Microsoft.Extensions, and containers. […]
Announcing Live Office Hours on Wednesdays & Thursdays
It’s time for summer school! I’m doing live streaming on my Twitch channel on Wednesdays & Thursdays this […]
PostgreSQL Schema: Learning PostgreSQL with Grant
An important aspect of building and managing a database is organizing the objects within your database. You […]
Announcement: New Features and changes to SQL IaaS Agent Extension
SQL Server on Azure Virtual Machines is powered by the SQL IaaS Agent extension which provides many features […]
A Beginners Guide To MySQL Replication Part 2: Configuring Source ...
A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers In the first part […]
Enhancing SSIS ETL Tools with SolarWinds Task Factory
The post Enhancing SSIS ETL Tools with SolarWinds Task Factory appeared first on SQLServerCentral.
How to work with ChatGPT in Visual Studio Code
ChatGPT in Visual Studio Code In this article, we will play with a ChatGPT extension for Visual Studio […]
可用性グループリスナーへの接続方法
こんにちは。日本マイクロソフト SQL Server サポートチームです。 今回は可用性グループリスナーへの接続方法についてご案内します。可用性グループリスナーに接続する際、アプリケーションや接続文字列でのサーバー名について、サポートされる指定方法とサポートされない指定方法は次の通りです。 サポートされるサーバー名の指定可用性グループリスナーが既定の 1433 ポートの場合:listenernamelistenername,port 可用性グループリスナーが既定以外のポートの場合: listenername,portlistenernameinstancename,port ※ listenernameinstancename,port と指定した場合は、instancename の部分は無視され、listenername,port […]
Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud ...
The post Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches appeared first on […]
Performance Tuning with SQLFacts Tools
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved […]
What SQL Server People Should Know About Amazon Aurora Serverless
You, dear reader, are most likely a Microsoft SQL Server user – either a DBA or developer. Set […]
[Video] Office Hours: Ask Me Anything at Sea
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I […]
The ten habits for highly successful compliant database DevOps
The post The ten habits for highly successful compliant database DevOps appeared first on SQLServerCentral.
PASS Data Community Summit 2023 registrations are open!
The post PASS Data Community Summit 2023 registrations are open! appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? April 2023 ...
Is your company hiring for a database position as of April 2023? Do you wanna work with the […]
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from […]
Improving SQL Server Performance and Availability with Accelerated Database Recovery
For many businesses, database performance and availability are crucial elements. A database crash or a lengthy transaction can […]
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Improving the Quality of your Database Monitoring
The post Improving the Quality of your Database Monitoring appeared first on SQLServerCentral.
Happy April Tools Day!
While many folks observe April 1 as April Fool’s Day, we in the SQL Tools team celebrate April […]
Snowflake Temporary Tables vs. Transient Tables
The post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral.
Shrink Database Log Files One by One
I have about 25-30 client databases on my computer for testing purposes when I support or do new […]
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Generic ODBC external data sources may not work after installing ...
Symptoms After you install SQL Server 2019 CU19 or SQL Server 2022 CU2, external data sources using […]
Update XML files using PowerShell
There are many blogs on internet already speaking about updating XML files in PowerShell, but I felt […]
A Beginners Guide to MySQL Replication Part 1
MySQL Replication is a process where data from one MySQL database known as the source (formerly called […]
Let's make it easy! How to read System Health and ...
Hi Everyone, The system_health session is an extended event session that is included by default with SQL […]
[Video] Office Hours: Ask Me Anything About SQL Server in ...
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: […]
Data API Builder Quickstart Demo from VS Live Vegas
I was fortunate enough to be able to present Data API builder the week of March 20th […]
Piping, Filtering and Using Flyway Output in PowerShell
The post Piping, Filtering and Using Flyway Output in PowerShell appeared first on SQLServerCentral.
The role of forethought for a computer engineer
If you have ever played a game of chess against someone good, or perhaps against a computer, […]
Accelerated Database Recovery enhancements in SQL Server 2022
Part of the SQL Server 2022 blog series. We are excited to share that there are several Accelerated Database […]
Is SQL Server 2019 More CPU-Intensive Than SQL Server 2016?
I’m running into something that I’m having a hard time believing. A client was hitting CPU issues during […]
The Curious Case of…. alcoholism
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve […]