May 22, 2012 at 9:27 am
I'm torn with this thread. Should we tell the OP that it is possible to hde structural changes to the tables of the database from application using views? I'd hate to take someone down this path and have them fail to do it right. This may not be the best thing to be done via forums, but best handled by an experienced DBA/Developer working directly with the company.
May 22, 2012 at 10:25 am
Lynn Pettis (5/22/2012)
I'm torn with this thread. Should we tell the OP that it is possible to hde structural changes to the tables of the database from application using views? I'd hate to take someone down this path and have them fail to do it right. This may not be the best thing to be done via forums, but best handled by an experienced DBA/Developer working directly with the company.
Why don't you just tell them that? Seems reasonable.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 22, 2012 at 10:46 am
jcrawf02 (5/22/2012)
Lynn Pettis (5/22/2012)
I'm torn with this thread. Should we tell the OP that it is possible to hde structural changes to the tables of the database from application using views? I'd hate to take someone down this path and have them fail to do it right. This may not be the best thing to be done via forums, but best handled by an experienced DBA/Developer working directly with the company.Why don't you just tell them that? Seems reasonable.
Okay, I did.
May 22, 2012 at 12:04 pm
If people would just format their code they could figure out some of their own problems. Geez.
May 22, 2012 at 12:19 pm
Lynn Pettis (5/22/2012)
If people would just format their code they could figure out some of their own problems. Geez.
Many should format it all at once, like with Format C:\
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 22, 2012 at 12:30 pm
Has anyone heard from Gianluca since the earthquake in northern Italy? I think he's up in that area, and just want to make sure that he's okay.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 22, 2012 at 1:03 pm
Stefan Krzywicki (5/22/2012)
Lynn Pettis (5/22/2012)
If people would just format their code they could figure out some of their own problems. Geez.Many should format it all at once, like with
Format C:\
:laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
May 22, 2012 at 1:06 pm
WayneS (5/22/2012)
Has anyone heard from Gianluca since the earthquake in northern Italy? I think he's up in that area, and just want to make sure that he's okay.
His last tweet was just a few hours ago, so I'd say he's probably ok.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
May 22, 2012 at 1:20 pm
SQL Kiwi (5/22/2012)
WayneS (5/22/2012)
Has anyone heard from Gianluca since the earthquake in northern Italy? I think he's up in that area, and just want to make sure that he's okay.His last tweet was just a few hours ago, so I'd say he's probably ok.
Great! (Sure wish I had thought of checking his tweets, but heck, strength in numbers! Thanks Paul)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 22, 2012 at 1:46 pm
SQL Kiwi (5/22/2012)
Stefan Krzywicki (5/22/2012)
Lynn Pettis (5/22/2012)
If people would just format their code they could figure out some of their own problems. Geez.Many should format it all at once, like with
Format C:\:laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh:
Sir, please, step slowly away from the computer and don't make any sudden moves near the mouse...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 22, 2012 at 2:28 pm
WayneS (5/22/2012)
Has anyone heard from Gianluca since the earthquake in northern Italy? I think he's up in that area, and just want to make sure that he's okay.
Thank you Wayne. No need to worry, I'm ok.
The earthquake was 200 Km from my town (Conegliano, near Venice) and we had no issues here.
I woke up in the night and everything was shaking, but no damage. I have a big sliding window in my bedroom (2.5 m x 2.7 m) which I think weights around 200 Kg and it has been rattling and shaking like a paper sheet for somehting like 30 seconds.
Fortunately no damage.
I wonder why earthquakes always happen at night here. It's the worst time of the day, when everyone is sleeping and it takes some time to realize what's going on.
This week I'm working in Bologna, just 36 Km from the epicenter. I felt quite a lot of aftershocks, but everything seems to be ok here. Bologna didn't suffer major damages.
The most affected area is the one near Modena and Ferrara, where a lot of historical buildings collapsed. Most historical buildings are made of bricks and they're well known to be not exactly antiseismic.
Newer buildings resisted well and looking at them you wouldn't say any earthquake had happened. Too bad for churches and castles.
The earthquake was 6.0 in magnitude, slightly lighter than the one that blew away L'Aquila some years ago. Fortunately we had "only" 7 victims this time, much better than the over 300 victims in L'Aquila.
-- Gianluca Sartori
May 22, 2012 at 2:35 pm
Gianluca Sartori (5/22/2012)
I wonder why earthquakes always happen at night here. It's the worst time of the day, when everyone is sleeping and it takes some time to realize what's going on.
Glad you're OK.
I used to have a bird when I lived in San Diego. He would wake up and go crazy around the cage about 30 sec before things would shake. After the first time we learned to get up and walk downstairs and out into the yard. Just in case.
May 22, 2012 at 2:45 pm
Steve Jones - SSC Editor (5/22/2012)
Gianluca Sartori (5/22/2012)
I wonder why earthquakes always happen at night here. It's the worst time of the day, when everyone is sleeping and it takes some time to realize what's going on.Glad you're OK.
I used to have a bird when I lived in San Diego. He would wake up and go crazy around the cage about 30 sec before things would shake. After the first time we learned to get up and walk downstairs and out into the yard. Just in case.
Ha! Better than a seismometer!
And cheaper, I suppose. 🙂
-- Gianluca Sartori
May 22, 2012 at 2:58 pm
OK, since I'm back to posting on The Thread, I think I'll share this one with you.
Lately I've been working a lot as a SQL Server trainer and I taught several courses.
Here's some random thoughts:
1 - MS courseware leaves a lot of space for improvement. Exception made for 6231B (Greg Low was among the authors), many of those courses are far from perfect.
Some are even a pain to teach. For instance, the 50400 had no sensible content flow and I had to go back and forth on the slide deck to make sense out of it.
2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you buy the training at all?
3 - Teaching is tiring and fatiguing. Each training day requires at least one day of preparation on my side. (That's why I disappeared from the forums lately).
Has any of you worked as a trainer? Thoughts?
-- Gianluca Sartori
May 22, 2012 at 3:10 pm
Lynn Pettis (5/22/2012)
I'm torn with this thread. Should we tell the OP that it is possible to hde structural changes to the tables of the database from application using views? I'd hate to take someone down this path and have them fail to do it right. This may not be the best thing to be done via forums, but best handled by an experienced DBA/Developer working directly with the company.
I wonder if it would be possible to tell him he can hide structure by insisting that the application's only permitted SQL is calling an SP. Surely that is much better isolation than using views? AT least that way you don't have to worry about views being updateable without instead-of triggers.
Tom
Viewing 15 posts - 36,196 through 36,210 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply