Geometry Objects in SQL Server using Latitude/Longitude coordinates
(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in...
2018-03-31
3,546 reads
(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in...
2018-03-31
3,546 reads
(2018-Feb-10) A few days ago Microsoft provided another update for its desktop version of the Power BI data analytical tool...
2018-02-21 (first published: 2018-02-10)
53,267 reads
(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in...
2018-02-04
713 reads
(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10...
2018-01-23 (first published: 2018-01-13)
1,820 reads
(2018-Jan-20) It has been a long journey for the Excel data integration tool Power Query from its early version as...
2018-01-20
1,103 reads
(2017-Dec-29) Sankey diagram (chart), named after Matthew H Riall Sankey, is a good visualization tool for information flow within a system....
2017-12-29
3,138 reads
(2017-Nov-19) I don't remember how I actually found this book "Small Data: The Tiny Clues that Uncover Huge Trends". Most...
2017-11-19
1,285 reads
[2017-Oct-31] If you have never read the "Iacocca: An Autobiography" book by Lee Iacocca, I highly recommend it. I read it...
2017-10-31
612 reads
[2017-Sep-01] There is a well-known phrase, "the rescue of a drowning man is the drowning man's own job" from one of the...
2017-09-01
1,775 reads
[2017-Aug-08] Support for XML structured files as a data source has been available in Excel, then was introduced into the Power...
2017-08-08
12,660 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 Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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; GOSee possible answers