Viewing 15 posts - 7,771 through 7,785 (of 59,072 total)
oogibah You have GOT to be kidding me.
Are you saying that you ran into a SQL dev that could not produce the current date/time let alone datepart?
#Scary
AND A DBA...
February 4, 2020 at 11:34 pm
Hi there
I am developing an SSIS package to bulk load data. Now the data can be high in volume (300,000 to 2 million records)
What i want to design is...
February 4, 2020 at 11:31 pm
It'll also say that ',,,,,,,,,,,' is a valid numeric. And the cool part about converting to MONEY during imports (if you don't need more than 4 decimal places) is that...
February 4, 2020 at 11:13 pm
JEFF Do NOT go all SSIS on me 🙂 we all know it's Bulk insert with a formatfile or openrowset
Jeff's blood pressure just went up...
February 4, 2020 at 2:41 am
I have inheritance SQL Server environment where the Server team, etc wanted to be System Admin on the SQL Server.
They might perform some upgrade.
And, I found the work-around.
That link...
February 4, 2020 at 2:30 am
Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in excel...
February 4, 2020 at 2:25 am
Wow. Just WOW! Thanks for the feedback on what you found, Greg.
February 4, 2020 at 2:16 am
Someone create a SQL Login and grant DBO permission to a user database "AppDB1".
I apologize for asking such an obvious question but have you actually verified that happened correctly? ...
February 3, 2020 at 3:08 pm
I agree... I hate the "blame game". That's why I get pissed off when people, who frequently don't know much about databases, blame the DBA for being a supposed bottle-neck...
February 3, 2020 at 2:59 pm
I absolutely agree that cooperation leads to learning. That's why I sit with the Developers and have a symbiosis with them. Cooperation does not mean letting bad stuff happen and...
February 3, 2020 at 2:00 pm
My favorite IT related job posting of all time was also the shortest, most honest, and most accurate one I've ever seen...
HELP WANTED
"Basically, we want someone that can look at...
February 2, 2020 at 8:37 pm
When the business overrides you, there really isn't much you can do. Education is key. However, I'm still very much on the side of being part of the...
February 1, 2020 at 3:16 am
Maybe you are right but I think there is also a cultural issue. A good default pose for a developer might be as a collaborator who wants data to...
January 31, 2020 at 10:57 pm
sigh... my heart dies a little bit when we ignore the option of getting a provider of data to make it useable , I know they are often...
January 31, 2020 at 3:39 pm
Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in excel...
January 31, 2020 at 3:36 pm
Viewing 15 posts - 7,771 through 7,785 (of 59,072 total)