Viewing 15 posts - 1 through 15 (of 33 total)
This is an awesome article. I t falls in line with my learning Python and Pandas. Also, I a Database Connection class and choose pyodbc over SQLAlchemy. Azure Data Studio...
January 8, 2024 at 12:42 pm
This problem has been resolved. Thanks to all.
January 13, 2023 at 11:10 pm
The fix was [hashing].[CreateSha256KeyFromJsonInputSalesCustomer] not [hashing].[CreateSha256FromJsonInputSalesCustomer].
Thanks for your suggestion about changing the naming.
January 13, 2023 at 11:09 pm
create table [Audit].[SalesCustomerHistory](
[SalesCustomerHistoryId] [sdSequenceNumber].[SurrogateKeyNumber] identity(1,1) not null,
[AuditDateTimeStamp] [sdSysTime].[AuditTriggerTimestamp] not null,
[DBAction] [dbo].[DbAction] not null,
[CustomerID] [sdSequenceNumber].[SurrogateKeyNumber] not null,
[CountryID] [sdSequenceNumber].[SurrogateKeyNumber] not null,
[CustomerExpenditureClassificationID] [sdSequenceNumber].[SurrogateKeyNumber] null,
[CustomerName] [sdPersonNameString].[CustomerName] null,
[CustomerAddress1] [sdAddressesString].[AddressString] null,
[CustomerAddress2] [sdAddressesString].[AddressString] null,
[CustomerPostalCode]...
January 13, 2023 at 11:08 pm
This is a great proprietary solution but lacks portability in a heterogeneous database environment using ANSI SQL.
You said "All those solutions are hacky, and it is simply not always possible...
August 19, 2022 at 12:07 pm
Any suggestions to get to work using localhost,13001 and the default database?
June 7, 2022 at 4:14 pm
Great article, I will use it in my database class. It works cross platform which will be awesome for the students.
May 11, 2022 at 10:53 am
I was asked how I liked to report to my manager?
I responded that I liked to respond to my manager in the manner in which they would like to me...
May 9, 2022 at 9:20 pm
I liked the article and made me think of the acronym of KISS (Keep It Simple and Standard).
May 6, 2022 at 10:41 am
May 6, 2022 at 10:38 am
Gentlemen's agreement is an arrangement or understanding which is based upon the trust of both or all parties, rather than being legally binding. "a gentleman's agreement by the grain growers...
December 4, 2021 at 2:33 pm
The question is if you need data masking, why not use SQL Server data masking by keeping it simple and standard versus Gallium Data which is non-enforceable since it is...
December 3, 2021 at 1:39 pm
SSMS is the winner since you can access Azure Data Studio from SSMS as an external tool. Azure Data Studio lacks the full blown bells and whistles of the Redgate...
November 11, 2021 at 5:57 pm
There is such a high expectation of the DBAs in a heterogenous database environment which now entails NOSQL. At best, they a jack of all databases and probably a master...
July 30, 2021 at 1:57 pm
The go to has been suggested to try to avoid at all costs for the past 35 plus years.
July 19, 2021 at 3:36 pm
Viewing 15 posts - 1 through 15 (of 33 total)