Tracking CPU Use Over Time
A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...
2019-12-16 (first published: 2019-12-02)
665 reads
A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...
2019-12-16 (first published: 2019-12-02)
665 reads
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
12 reads
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
112 reads
I’m a creature of habit. With the software tools that I use, I like to have everything in the same place every time, even if I’m working on a...
2019-12-15
288 reads
Did you know that SQL Server Management Studio can help you arrange your SQL scripts into logical groupings? SSMS includes the ability to associate multiple code files together into...
2019-12-14
44 reads
Occasionally, I’ll stumble across one of those neat tricks that makes me ask myself, “Why didn’t I know about this years ago?”. This next tip was one such discovery,...
2019-12-13
57 reads
It’s still 2019, but we’re looking forward to 2020 and wonder how your world has changed since our survey last year. There are a number of questions and this...
2019-12-13 (first published: 2019-12-02)
92 reads
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-13
23 reads
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...
2019-12-13
5 reads
gethynellis.com is proud to sponsor the Woman in STEM award at the Woman’s Business Club conference 2019! The Women in STEM award recognises the outstanding contributions of woman in...
2019-12-13 (first published: 2019-11-28)
184 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers