Using the Import Extension in Azure Data Studio
Learn how this extension in Azure Data Studio makes it easy to import flat files in a CSV or JSON format.
2023-11-29
7,904 reads
Learn how this extension in Azure Data Studio makes it easy to import flat files in a CSV or JSON format.
2023-11-29
7,904 reads
In this article, we look at how using the Tablock hint in SQL Server could impact concurrency and block other sessions.
2023-11-29
Updating and deleting documents, creating queries, and managing query results in Microsoft's new NoSQL database-as-a-service.
2023-11-29
2023-11-27
6,490 reads
Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining.
2023-11-27
This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]
2023-11-24 (first published: 2021-03-30)
11,399 reads
November approaches again. For Europeans, that is a month like any other, for Americans, November means: Black Friday, with huge discounts!
2023-11-24
Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
2023-11-24
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]
2023-11-22
5,986 reads
Coding for the new NoSQL JSON database service that supports SQL queries.
2023-11-22
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers