I Must Be an Idiot: Automatic Tuning Never Works for ...
The post I Must Be an Idiot: Automatic Tuning Never Works for Me. appeared first on SQLServerCentral.
sqlservercentral.com
How to Slice Data by Fiscal Month using DAX for ...
The post How to Slice Data by Fiscal Month using DAX for Power BI Reports appeared first on […]
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
The post Microsoft Fabric: Using Lakehouse data in Real Time Dashboards appeared first on SQLServerCentral.
Is it still worth it to sponsor PASS Summit?
The post Is it still worth it to sponsor PASS Summit? appeared first on SQLServerCentral.
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
The post Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level appeared first on SQLServerCentral.
Is your DevOps strategy missing a vital link?
The post Is your DevOps strategy missing a vital link? appeared first on SQLServerCentral.
Big Northwind with AI
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking […]
SQL Local Variables and Performance Issues
The post SQL Local Variables and Performance Issues appeared first on SQLServerCentral.
Auditing SQL Server – Part 3 – SQL Server Configuration ...
The post Auditing SQL Server – Part 3 – SQL Server Configuration Audit appeared first on SQLServerCentral.
A New and Improved Data Warehouse: Data Engineering with Fabric
Microsoft Fabric is their fourth version of a Data Warehouse. Back in September of 2008, Microsoft bought DATAllegro […]
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT
The post Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT appeared first on SQLServerCentral.
Data Prediction with SQL Server Machine Learning Services, Python, and ...
AI is increasingly becoming part of everyday life across various domains. For the uninitiated, AI which stands for […]
10 tips for Test Data Management success
The post 10 tips for Test Data Management success appeared first on SQLServerCentral.
Recover a Database from Suspect Mode Step by Step
On 19th June 2024, the world faced a major outage. The computer on which the Windows operating system […]
SSIS in One Hour: Hands-On Tutorial
The post SSIS in One Hour: Hands-On Tutorial appeared first on SQLServerCentral.
Introducing PASS Summit Charitable Organization Scholarship
The post Introducing PASS Summit Charitable Organization Scholarship appeared first on SQLServerCentral.
Hiring in IT and Relevance of Domain Experience
We recently wanted to hire two candidates (SQL developers with around 5-10 years of experience) to join our […]
Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces
The post Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces appeared first on SQLServerCentral.
Introducing the pre-con schedule for PASS Summit 2024
The post Introducing the pre-con schedule for PASS Summit 2024 appeared first on SQLServerCentral.
Promote Simple Talks podcast episode 2: Coffee chat with Huxley ...
The post Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell appeared first on SQLServerCentral.
Express a Number or Currency in Words with T-SQL Code
The post Express a Number or Currency in Words with T-SQL Code appeared first on SQLServerCentral.
Choosing a File Format – Data Engineering with Fabric
Microsoft Fabric has OneLake Storage at the center of all services. This storage is based upon existing Azure […]
The full agenda for the Redgate Summit New York is ...
The post The full agenda for the Redgate Summit New York is live! appeared first on SQLServerCentral.
Level up your learning in 2024 with PASS Data Community ...
The post Level up your learning in 2024 with PASS Data Community Summit appeared first on SQLServerCentral.
Create Document Templates in a SQL Server Database Table
The post Create Document Templates in a SQL Server Database Table appeared first on SQLServerCentral.
Git, GitHub and Visual Studio Code for SQL Server
Introduction This article will teach us to integrate Git, GitHub, and Visual Studio Code. Visual Studio Code (VSCode) is […]
Redgate Summit: The Database Landscape – New York
The post Redgate Summit: The Database Landscape – New York appeared first on SQLServerCentral.
Using Registered Servers in SSMS
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have […]
Getting Started with Azure CLI to Manage Azure Resources
The post Getting Started with Azure CLI to Manage Azure Resources appeared first on SQLServerCentral.
PASS Summit Futures Scholarship
The post PASS Summit Futures Scholarship appeared first on SQLServerCentral.
Getting Started With Azure Cosmos DB for PostgreSQL
Article Overview In this article we will learn about Azure Cosmos DB PostgreSQL, which is the latest addition […]
Migrate a SQL Server Database to a PostgreSQL Database
The post Migrate a SQL Server Database to a PostgreSQL Database appeared first on SQLServerCentral.
How to use Jupyter Notebook in VSCode
Introduction Visual Studio Code (VSCode) is a free code editor used by many programmers. In this article, we […]
Using Query Store to Identify CPU Intensive SQL Queries and ...
The post Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes appeared first on […]
Notebook Jobs in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
Configure Microsoft Fabric Database Mirroring for Snowflake
The post Configure Microsoft Fabric Database Mirroring for Snowflake appeared first on SQLServerCentral.
Four steps towards tackling the complexity of managing multiple database ...
The post Four steps towards tackling the complexity of managing multiple database platforms appeared first on SQLServerCentral.
Prompt+ EAP: your AI-powered database development partner in the making
The post Prompt+ EAP: your AI-powered database development partner in the making appeared first on SQLServerCentral.
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation
Introduction In the realm of image generation, Generative Adversarial Networks (GANs) have emerged as powerful tools, capable of […]
Add Indexes to Improve SQL DELETE Performance
The post Add Indexes to Improve SQL DELETE Performance appeared first on SQLServerCentral.
Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream
In this fast-changing world of data, businesses are looking for more insights in their data to remain competitive. […]
Save $200 by registering for a PASS Summit 2024 3-day ...
The post Save $200 by registering for a PASS Summit 2024 3-day ticket before July 16 appeared first […]
Manage OneLake Storage With PowerShell – Data Engineering with Fabric
Microsoft Fabric has OneLake Storage at the center of all services. This storage is based upon existing Azure […]
Redgate recommended in Bloor Test Data Management market update
The post Redgate recommended in Bloor Test Data Management market update appeared first on SQLServerCentral.
Docker Logging Guide Part 1: Basic Concepts and Importance
The post Docker Logging Guide Part 1: Basic Concepts and Importance appeared first on SQLServerCentral.
General program for PASS Summit 2024 now available
The post General program for PASS Summit 2024 now available appeared first on SQLServerCentral.
Meet the new Google AI Assistant Gemini
Introduction to Gemini Gemini’s intro. In the beginning, there was Bard. A powerful language model, crafted by Google AI, […]
What does SQL NULL mean and how to handle NULL ...
The post What does SQL NULL mean and how to handle NULL values appeared first on SQLServerCentral.
How much Space can I expect to recover from a ...
In my last article – Identify Tables With Dropped Columns – we saw how we can identify tables […]
Prevent Duplicate Records in SQL using Filtered Index
The post Prevent Duplicate Records in SQL using Filtered Index appeared first on SQLServerCentral.