I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2020-05-13 (first published: 2020-04-29)
589 reads
I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at...
2020-05-06
16 reads
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,...
2020-04-21 (first published: 2020-04-08)
350 reads
GroupBy is a virtual conference, for the community and by the community. Content is focused on the Microsoft Data Platform. Speakers can submit sessions for two events: GroupBy Europe...
2020-04-14
18 reads
Sometimes in life you have to do things you really don’t like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData...
2020-04-07
1,201 reads
WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data. Sometimes you directly want to manipulate data without having...
2020-04-02
48 reads
Okay, the title of this blog post could also have been “SUMX returns unexpected results with duplicates”. The results only seem incorrect because an incorrect assumption might have been...
2020-03-02 (first published: 2020-02-27)
484 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2020-02-04
50 reads
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-27 (first published: 2020-01-21)
224 reads
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-21
7 reads
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers