March 2, 2020 at 4:53 pm
MVDBA (Mike Vessey) wrote:don't - I went once and it was "an experience" (this is from Wikipedia)
Kæstur hákarl, fermented Greenland shark.
Súrsaðir hrútspungar, the testicles of rams pressed in blocks, boiled and cured in lactic acid.
Svið, singed and boiled sheep's heads, sometimes cured in lactic acid.
Sviðasulta, head cheese or brawn made from svið, sometimes cured in lactic acid.
Lifrarpylsa (liver sausage), a pudding made from liver and suet of sheep kneaded with rye flour and oats.
Blóðmör (blood-suet; also known as slátur lit. 'slaughter'), a type of blood pudding made from lamb's blood and suet kneaded with rye flour and oats.
Harðfiskur, wind-dried fish (often cod, haddock or seawolf), served with butter.
Rúgbrauð (rye bread), traditional Icelandic rye bread.
Hangikjöt, (hung meat), smoked and boiled lamb or mutton, sometimes also eaten raw.
Lundabaggi, sheep's loins wrapped in the meat from the sides, pressed and cured in lactic acid.
Selshreifar, seal's flippers cured in lactic acid.
Súr Hvalur, whale blubber pickled in sour milk.
Rófustappa, mashed turnips
stick to good old fashioned polish food - pierogi
...and now I'm drooling 😉
😎
Any chance of getting what some of us would consider normal food, you know steaks, chicken, burgers, potatoes, salad? Unfortunately, looking at this list, I'd starve. This dog is getting a little too old for new tricks.
March 2, 2020 at 5:00 pm
On a different note, here's one of the many reasons I fear both the cloud and any automatic performance metrics collected by any company...
https://mspoweruser.com/microsoft-accidentally-exposes-250-million-customer-support-records-online/
This has gotten to be a totally stupid problem, especially since it's so easy to prevent.
This happens to many companies. This wasn't a cloud issue, nor anything to do with perf data. This was normal customer service data, which many orgs collect.
I get your concerns, but conflating things here isn't a sign of being security conscious, but rather over-hyping a common, and easily preventable, problem to relate it to another situation.
March 3, 2020 at 9:24 am
x wrote:I (occasionally) work with an app like that, thousands of tables, no foreign key constraints, even better, if you add an index to a table, the next build will helpfully remove it again unless you add the index to the table from within the app.
For extra credit, name the vendor and app@!
How about this one? This is from our ERP. Everything that is used by the app uses a specific schema with a schema_id of 5.
select count(*)
from sys.tableswhere
schema_id = 5The above returns 3,773. Now let's look at foreign keys.
select *
from sys.foreign_keys
where schema_id = 50 rows returned!!!
I have a very similar scenario, but only 2968 tables. The system was initially designed with a flat file system, and apparently that's still how it likes to treat it's data. There's not a single bit of data referential integrity throughout the whole application. >_<
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 3, 2020 at 9:37 am
Eirikur Eiriksson wrote:MVDBA (Mike Vessey) wrote:don't - I went once and it was "an experience" (this is from Wikipedia)
Kæstur hákarl, fermented Greenland shark.
Súrsaðir hrútspungar, the testicles of rams pressed in blocks, boiled and cured in lactic acid.
Svið, singed and boiled sheep's heads, sometimes cured in lactic acid.
Sviðasulta, head cheese or brawn made from svið, sometimes cured in lactic acid.
Lifrarpylsa (liver sausage), a pudding made from liver and suet of sheep kneaded with rye flour and oats.
Blóðmör (blood-suet; also known as slátur lit. 'slaughter'), a type of blood pudding made from lamb's blood and suet kneaded with rye flour and oats.
Harðfiskur, wind-dried fish (often cod, haddock or seawolf), served with butter.
Rúgbrauð (rye bread), traditional Icelandic rye bread.
Hangikjöt, (hung meat), smoked and boiled lamb or mutton, sometimes also eaten raw.
Lundabaggi, sheep's loins wrapped in the meat from the sides, pressed and cured in lactic acid.
Selshreifar, seal's flippers cured in lactic acid.
Súr Hvalur, whale blubber pickled in sour milk.
Rófustappa, mashed turnips
stick to good old fashioned polish food - pierogi
...and now I'm drooling 😉
😎
Any chance of getting what some of us would consider normal food, you know steaks, chicken, burgers, potatoes, salad? Unfortunately, looking at this list, I'd starve. This dog is getting a little too old for new tricks.
The only real Icelandic dish I tried was the lamb soup with rye bread which was really good. I wanted to try the shark, puffin and whale but my wife suggested that I might not enjoy my holiday quite so much if I did...
There's no danger of starving Lynn, there's plenty of 'normal food' to be had but I must say I don't recall seeing steaks on a menu. That's possibly because I wasn't looking for steaks and we perhaps weren't eating in steak places. The lamb sandwich I had and the burger my wife got here were fantastic.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 3, 2020 at 9:52 am
Go to Norway and get a reindeer steak... amazing
except that I got a lecture from my mother saying that I had killed Rudolph and spoiled Christmas for all the kids
MVDBA
March 4, 2020 at 4:17 pm
Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://www.sqlservercentral.com/forums/topic/ssis-package-error-22
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 4, 2020 at 4:31 pm
Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://www.sqlservercentral.com/forums/topic/ssis-package-error-22
oh man i wish i was in that stream ... jeff can be quite direct.
I was in a session with a guy that didn't understand the difference between a view and a table... he thought the view had switched from varchar to nvarcvhar) it took a day to get to the root of the issue.... he mentioned the word SSIS and oracle and i figured out what he was doing.. I wanted someone else (jeff, joe,grant, anyone) to just tell him he should not be around the complicated toys 🙂
MVDBA
March 4, 2020 at 4:44 pm
Michael L John wrote:Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://www.sqlservercentral.com/forums/topic/ssis-package-error-22
oh man i wish i was in that stream ... jeff can be quite direct.
Is that good or bad? 😀 I thought I was pretty nice about saying that he needs to slow down and read his code... especially in the areas that SQL Server was telling him to look.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 4, 2020 at 4:55 pm
no, it's a good thing.. but I read the stream and was waiting for the jeffplosion (trademarked) where you decided he was "response by agonising reponse" (see what I did there) - I think we do need to be kind, but some times we do get "time vampires" - they suck the time out of your day because they don't try
MVDBA
March 4, 2020 at 4:59 pm
MVDBA (Mike Vessey) wrote:Michael L John wrote:Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://www.sqlservercentral.com/forums/topic/ssis-package-error-22
oh man i wish i was in that stream ... jeff can be quite direct.
Is that good or bad? 😀 I thought I was pretty nice about saying that he needs to slow down and read his code... especially in the areas that SQL Server was telling him to look.
His last post was the kicker. "The files empty". Uh, duh, did you fill it with anything?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 4, 2020 at 5:03 pm
Michael L John wrote:Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://www.sqlservercentral.com/forums/topic/ssis-package-error-22
oh man i wish i was in that stream ... jeff can be quite direct.
I was in a session with a guy that didn't understand the difference between a view and a table... he thought the view had switched from varchar to nvarcvhar) it took a day to get to the root of the issue.... he mentioned the word SSIS and oracle and i figured out what he was doing.. I wanted someone else (jeff, joe,grant, anyone) to just tell him he should not be around the complicated toys 🙂
I remember that thread. I guess I stopped following it before he mentioned SSIS, but then I could have just missed that.
March 4, 2020 at 5:04 pm
Jeff Moden wrote:MVDBA (Mike Vessey) wrote:Michael L John wrote:Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://www.sqlservercentral.com/forums/topic/ssis-package-error-22
oh man i wish i was in that stream ... jeff can be quite direct.
Is that good or bad? 😀 I thought I was pretty nice about saying that he needs to slow down and read his code... especially in the areas that SQL Server was telling him to look.
His last post was the kicker. "The files empty". Uh, duh, did you fill it with anything?
good lad jeff.. you aren't dropping your standards
MVDBA
March 4, 2020 at 5:10 pm
could be worse jeff - I called a colleague over for some guidance on who wrote some code... he talked me through the 5000 line long proc with cursors, functions, triggers and all of the stuff that happens on Halloween... I put my head in my hands and said " which idiot wrote this pile of ****"
the reply was "me"
There are days when you feel like jeff and that was mine 🙂
now i'm waiting for a joe celko day 🙂
MVDBA
March 4, 2020 at 5:29 pm
Sean Lange wrote:x wrote:I (occasionally) work with an app like that, thousands of tables, no foreign key constraints, even better, if you add an index to a table, the next build will helpfully remove it again unless you add the index to the table from within the app.
For extra credit, name the vendor and app@!
How about this one? This is from our ERP. Everything that is used by the app uses a specific schema with a schema_id of 5.
select count(*)
from sys.tableswhere
schema_id = 5The above returns 3,773. Now let's look at foreign keys.
select *
from sys.foreign_keys
where schema_id = 50 rows returned!!!
From the description, by guess would have to be baan...or whatever the current incarnation of it is called nowadays. If you have table names like ttdsls040XXX where XXX is a company number, then that's the beast. I'm so very thankful I don't have to work with it any more.
Sean, you know what I'm talking about and the pain it brings.
Nope not Baan, but that company was assimilated by the company of the "ERP" I get to work with. Thankfully they abandoned that table naming policy.
Also not Dynamics CRM or SAP. Pretty sure that either of those would be a big step up. 🙁
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 64,546 through 64,560 (of 66,572 total)
You must be logged in to reply to this topic. Login to reply