Making Guesses
When working on a new database, Steve Jones hesitates to make too many guesses, or at least, too many exact guesses.
Catch-up on Redgate Summit
Did you miss the excellent presentations from DevOps experts Pramod Sadalage, Kellyn Pot’Vin Gorman, Samir Behara, and Kendra Little? Good news – all Redgate Summit sessions are available on-demand now. Choose from ‘the future of database DevOps’ keynote, latest DevOps trends, Q&A discussion, and demos.
Power BI Small Multiples Visual Example
Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.
An Amazing Interview
There are many amazing candidates in IT, but how many can give an amazing interview. I feel I can't, can you?
Using ADF to Upload Disparate CSV Files into Azure MySQL
In this article our objective is to showcase how to leverage Azure Data Factory (ADF) and a custom script to upload data in Azure MySQL database when we have CSV files with different schemas. As there is no straightforward way to upload data directly using ADF for this given scenario, it will actually help to […]
SQL Server 101 Tutorial
Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform. While the core of SQL Server is still it's database engine, it is now so much more than just a relational database plat
Stairway to U-SQL Level 2: Breakdown of a U-SQL Statement
Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.
You know what we really need? Better interpersonal communication
Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.
Create Calendar Table Using Power Query M Language
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
PowerShell editors and environments: Part 1
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU Menara Bidakara Telp:0821-8200-233
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers