March 2, 2020 at 9:16 am
Glad to see everyone is talking about SQL Server stuff. Hope you've had a good last month.
The end of last month was fantastic because I had a week in Reykjavik. Lots of snow, waterfalls and cool bars. Unfortunately the snow meant the Northern Lights weren't visible and the snorkelling between tectonic plates couldn't happen but I still got to see a geyser erupt and walk on a glacier. The two 'failures' give us a great excuse for going back though.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 2, 2020 at 10:05 am
Different subject and a bit of a rant/warning.
I went into work this morning as I needed to work with a coworker, basically a code review of changes I was making. While at my desk I got a call from a Career Consultant. Yes, I am starting to get ready for a job search as funding for my position is only good through August 14th. Told this person what career area I was interested in and was told she could help. By the way, no company info at this point and was told the conversation was recorded.
First question she asked me was when did I graduate high school. My immediate response was that is an illegal question to ask, as it allows someone to determine the age of a person. She said she was just verifying. I didn't ask what she was verifying but continued to stress that the question was illegal. She didn't hang up but the line went quiet. After about 15 seconds I hung up.
Just a word of warning. I will say that I had not provided any personal information during the short conversation.
Well done for refusing.
March 2, 2020 at 2:26 pm
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.
March 2, 2020 at 2:36 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.
Oh man - was it SAP?
MVDBA
March 2, 2020 at 3:19 pm
Ed Wagner wrote: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.
Oh man - was it SAP?
Dynamics CRM is my semi-educated guess.
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 2, 2020 at 4:00 pm
Steve Jones - SSC Editor wrote:Glad to see everyone is talking about SQL Server stuff. Hope you've had a good last month.
The end of last month was fantastic because I had a week in Reykjavik. Lots of snow, waterfalls and cool bars. Unfortunately the snow meant the Northern Lights weren't visible and the snorkelling between tectonic plates couldn't happen but I still got to see a geyser erupt and walk on a glacier. The two 'failures' give us a great excuse for going back though.
Did you have the chance to try the seasonal Þorramatur?
😎
March 2, 2020 at 4:21 pm
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
MVDBA
March 2, 2020 at 4:36 pm
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 😉
😎
March 2, 2020 at 4:47 pm
I'm not going near anything that uses the words "sour milk", "seal flippers", "sheeps head" or "testicles"
I'd rather swap all of my tables to heaps, remove keys and forget to sanitise my inputs.... in fact sheeps head that is where I sanitise my input of food 🙂
MVDBA
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
Viewing 15 posts - 64,531 through 64,545 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply