Two weeks ago, I wrote the first of several articles on HANA. In this week's newsletter, I'm going to expand that to common data types in HANA, as well as Microsoft SQL Server, and some of the ...
-- 16.0.1050.5 RTM GDR 2/14/2023 https://support.microsoft.com/en-us/topic/kb5021522-description-of-the-security-update-for-sql-server-2022-gdr-february-14-2023 ...
--SQL Server code for Q1 resolution SELECT o.id AS order_id, p.latitude AS pickup_latitude, p.longitude AS pickup_longitude, d.latitude AS delivery_latitude, d.longitude AS delivery_longitude, ROUND( ...
SQL functions are powerful tools that allow developers to encapsulate complex logic and calculations within their database queries. While they provide modularity and maintainability, the use of SQL ...
Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...
As a postscript to my series on Power BI refresh timeouts (see part 1, part 2 and part 3) I thought it would be useful to document how I was able to simulate a slow data source in Power BI without ...
TL;DR: if you want to use date/time values from a SQL Server table in PowerApps, use the datetimeoffset column type and your life will be easier. The datetime (and friends) column type represent an ...
As promised, I’m going to be putting up a few more DAX examples here – although they may not demonstrate any new and interesting concepts, I’m still learning the language and blogging is a good way ...
SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results