Viewing 15 posts - 151 through 165 (of 380 total)
July 14, 2017 at 5:39 am
I did neglect to mention the tool sets available. While there are a few good ERD tools out there, they tend to be expensive. For a free tool, I rather...
July 7, 2017 at 8:00 am
Proper database modeling is more than just knowing how to draw diagrams or about normalization rules. A huge portion is understanding the subject area, data flows, processes and goals. I...
July 7, 2017 at 5:56 am
Agreed, the use of "dw" threw me off as well for the very same reason and I picked the only one that had "day" without noticing the order of the...
July 4, 2017 at 4:53 am
It seems to me that there is a trend to have most, if not all, of the business logic layer in code (Java, .NET, etc.) and the database is used...
June 20, 2017 at 6:06 am
Having grown up in the days of "green" screens (green text on dark screens), I've always preferred dark backgrounds and high-contract fonts for all-day working. My eyes have always been...
June 2, 2017 at 5:48 am
April 26, 2017 at 10:04 am
To be honest, I'm rather suspicious of the whole "data science" aspect. In my humble opinion, much of what I've done over my career could be considered "data science" with...
April 26, 2017 at 6:04 am
Jeff, that's pretty amazing! I have truly blown away by the performance this provides. Using an iTVF is something I would not have considered. This also provides me with ideas...
March 14, 2017 at 5:50 am
March 13, 2017 at 7:49 pm
March 10, 2017 at 12:54 pm
March 9, 2017 at 1:13 pm
DROP FUNCTION IF EXISTS dbo.FancyDateDiff;
go
CREATE FUNCTION dbo.FancyDateDiff
...
March 9, 2017 at 12:14 pm
March 8, 2017 at 2:47 pm
SELECT CAST(ABS(CAST(CAST(FirstDate AS DATETIME) AS INT) - CAST(CAST(SecondDate AS DATETIME) AS...March 8, 2017 at 2:09 pm
Viewing 15 posts - 151 through 165 (of 380 total)