Viewing 15 posts - 8,251 through 8,265 (of 39,771 total)
Eric M Russell (4/12/2016)
April 13, 2016 at 8:34 am
Completely agree. This is one area developers' laziness is an issue.
Personally, it should be a challenge to rebuild quickly, using knowledge, but correcting the the things you noticed weren't well...
April 13, 2016 at 8:32 am
You could potentially change to partial containment to solve the tempdb issues, if this is SQL 2012+.
We're in the 2008 forum, but posts sometimes are incorrectly posted.
However, that's a great...
April 13, 2016 at 8:31 am
Make sure you shut things down regularly. The ongoing prices are fairly high.
https://blogs.endjin.com/2015/01/using-azure-automation-to-run-vms-during-office-hours-only/
April 13, 2016 at 8:12 am
Make sure you read about implications. I think you're fine, since this was a migrated database, but I'd ensure you pick the correct collation. There are Windows and SQL collations,...
April 13, 2016 at 7:50 am
shaneoneillis (4/13/2016)
Isn't it a bit cheeky having a question where the answer was in one of your previous articles? 😛
Not sure. Many people don't read all the articles, or even...
April 13, 2016 at 7:49 am
POCs aren't the issue. The main issue is management and developers not wanting to throw away code. The temptation to reuse something that's mocked or just setup is great. However...
April 13, 2016 at 7:47 am
Eirikur Eiriksson (4/12/2016)
Steve Jones - SSC Editor (4/12/2016)
I'll be there. Should arrive Thursday sometime.Would love to have a chat on version control and cloud implementations:-)
😎
Sure thing. Haven't done enough in...
April 12, 2016 at 3:19 pm
I'll be there. Should arrive Thursday sometime.
April 12, 2016 at 12:50 pm
below86 (4/11/2016)
Eric M Russell (4/6/2016)
April 12, 2016 at 11:17 am
Beatrix Kiddo (4/12/2016)
I'd love to go, but no budget. It looks great.
Saturday is free. Other than the train.
April 12, 2016 at 9:15 am
Gary Varga (4/12/2016)
SQL Bits XV looks really exciting but unfortunately I...
April 12, 2016 at 9:15 am
Carlo Romagnano (4/11/2016)
Steve, the right event is "DROP TABLE" instead of "DELETE TABLE".
That's an incorrect answer.
April 12, 2016 at 9:14 am
I also used triggers once to separate out replication. We had a Sales database and an accounting database. We did this:
Sales.dbo.SalesOrder table
|-> trigger to insert into...
April 12, 2016 at 9:11 am
Viewing 15 posts - 8,251 through 8,265 (of 39,771 total)