I’ve been tracking my usage and comparing that with the estimates for my solar power system. I wrote about the database design and tracking the usage and some of...
2022-08-19 (first published: 2022-08-03)
365 reads
UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about making a HEAD utility to find the top few lines from a text file. I...
2022-08-18 (first published: 2022-08-17)
135 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-18
7 reads
I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is about the IS [NOT] DISTINCT FROM predicate. I was...
2022-08-17 (first published: 2022-08-04)
1,213 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-17
10 reads
I’ve been working to better understand graph databases and where they can be useful. There is a file from Neo4J that comes with the Desktop and contains a data...
2022-08-17 (first published: 2022-08-08)
209 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-16
10 reads
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as ... Continue reading
2022-08-16
106 reads
One of the things I did often in my first career job was create utilities that we could use as a network support team. I was an intern coming...
2022-08-15
75 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-15
5 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item New SQL Server 2022 Functions
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers