Last year I had the most wonderful opportunity. I took part in Data Relay, an event in the UK which tours several cities. Wonderful time, but not the focus here. The very first one was held at the National Museum of Computing at Bletchley Park. Without a doubt, you've heard of Alan Turing, Enigma, and […]
Today Steve wonders if you have a go-to person at work or maybe if you are that person. Or if that is even a good thing in a company. It might be better if there were more tools available to help others.
This article covers the basics of how different AI tools can be used to write SQL.
This article shows how a table variable can be used to capture error information and log it when your code doesn't work as expected.
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.
Learn how to get started with a few sample prompt templates by using the gpt-4 LLM within OpenAI and LangChain in a Databricks notebook.
Learn how you can model days in a dimension that might need to be aggregated in different ways for your data warehouse operations.
Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.
If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it?
Read a message from Bob Ward about the first Microsoft Fabric conference taking place in Las Vegas this March.
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Nguyen Khanh Tung Email: traiphieu.com@gmail.com ORCID: 0009-0002-9877-4137 -------------------------------------------------------------------------------- Abstract This article presents a numerical...
Hello, I think I need a recursive cte query but unsure of the logic....
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers