Archive to the Lake
Microsoft Fabric changes the paradigm for how you might store data in your warehouse.
Combine DATE and TIME to DATETIME2 in SQL Server
The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".
7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide
Are you looking to modernize and migrate your data but have questions about the complex organizational challenges? We recently hosted the webinar: Overcoming Organizational Challenges in Data Modernization and Cloud Migration: A Guide for Senior IT Leaders. This blog post summarizes the conversation into 7 key points.
Using Power Query to Combine Data from Multiple Sheets in Excel
This article employs Power Query features to combine queries and implement requirements in different listed scenarios.
Small Changes, Big Results
Last week I was able to attend THAT conference in Wisconsin Dells, Wisconsin. It was my first time in the great state of cheese, and the conference lived up to its reputation. As a developer focused conference (rather than a database conference), I didn't have much expectation that my session about automating database changes would […]
AutomatedLab - A Quickstart for Deploying SQL Server Labs on Windows
Learn how you can use AutomatedLab to quickly create new environments.
Flexible Work Policies are Preferred
New research says that companies with flexible work policies, hybrid or remote, find they are able to hire staff more quickly.
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
How to List First or Last n% Records Using NTILE() in SQL Server
Sometimes, we need to find the first or last n% records from a dataset based on a particular column. For instance, a teacher wants to know which students are in the bottom 25% based on marks. Hence, in such situations, the SQL NTILE() function helps. We will leverage this tip to get first or last n% records using NTILE() in SQL Server.
Constitutional AI
There is a company trying to build AI systems in a new way. Steve isn't sure what this means or if it's a good idea. Read his thoughts today.
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Forums
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Adding and Dropping Columns I
Comments posted to this topic are about the item Adding and Dropping Columns I
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers