Viewing 15 posts - 1,876 through 1,890 (of 3,678 total)
I would be interested to know just how Azure changes things for DBAs. There seems to be a lot of standard DBA tasks that just aren't relevant in SQL...
January 4, 2012 at 4:11 am
Yep, that sounds familiar. If you are using a public cloud service that is cheap or free then realistically you shouldn't expect much from it. You might be...
January 3, 2012 at 4:25 pm
I've been wrestling with data in the cloud for a while. It doesn't help that the definition of cloud is so nebulous.
I'm not an infrastructure guy but I've been...
January 3, 2012 at 10:10 am
Let me get this straight:
You stumbled over some new features.
CORRECT. In the Microsoft course material
You glanced at books online
Did a bit more than glance and also read what little...
December 23, 2011 at 11:36 am
A lot of ideas that are painted black are due to mis-interpretations.
Take Hungarian notation. Simonyi suggested its use to signal intent but people mis-interpretted this to signify type. ...
December 22, 2011 at 4:37 pm
I very rarely use GOTO, in fact I cannot remember when I last used it.
If I have a large stored proc with a complex transaction then on failure of any...
December 22, 2011 at 3:11 am
I'd turn this on its head. My customer is my boss. That attitude might upset a few line managers but it would help build bridges between IT departments...
December 21, 2011 at 1:45 pm
CyberWomble (12/8/2011)
1.) Are the plans cached by sp_prepexec stored in the same place as the plans cached when using Stored Procedures?
2.) Do...
December 8, 2011 at 7:26 am
I've seen something like this before with linked servers.
In that particular instance the code below alleviated the problem
EXEC master.dbo.sp_serveroption @server=N'YourServer', @optname=N'lazy schema validation', @optvalue=N'true'
Thanks for the star rating. If...
December 8, 2011 at 1:37 am
collins.jmj (12/6/2011)
December 6, 2011 at 10:34 am
The documentation tools so are seem to be focused on getting data out of extended properties, not necessary making the population of those values practical.
At this point I feel...
November 30, 2011 at 3:45 pm
As a teenager I had a job delivering potatoes to fish and chip shops across the staffordshire plains. The boss had a book called a ready-reckoner to help calculate...
October 21, 2011 at 4:07 pm
Joe, I should have remembered that. I think one of your books mentioned storing a calendar table rather than trying to workout calendar maths on the fly.
It is so...
October 19, 2011 at 12:17 pm
Yes, and apparently each space shuttle launch expected at least 6000 components to fail but was still designed to work.
On my list of things not to think about is precisely...
October 19, 2011 at 9:50 am
Well October 14th 1962 was the start of he Cuban missile crisis so has Red-Gate been bought by the Russians?
October 12, 2011 at 8:33 am
Viewing 15 posts - 1,876 through 1,890 (of 3,678 total)