Viewing 15 posts - 1,516 through 1,530 (of 3,617 total)
I am more worried about functions that return an INT rather than a BIGINT.
Calculations on larger datasets can easily involve values that throw overflow exceptions.
If there is a uniqueidentier datatype...
October 23, 2014 at 1:33 am
Read Daniel Kahneman's book on cognitive bias.
In theory we have the golden goose. In practise the powers that be begrudge the cost of the hen house and are...
September 26, 2014 at 1:58 pm
I'm trying to think of the features that weren't in SQL2000 that I actually used in the later versions.
1. Partitioning
2. Mirroring
3. SQLCLR (very limited)
4. Some language...
September 26, 2014 at 1:50 pm
Microsoft DocumentDB looks interesting but is only available in Azure. I'd love to know where the graph database outlined in the Trinity white paper is going to go.
I have...
September 21, 2014 at 9:27 am
Per core licencing. I actually think per core is reasonable given the power of the processors today but...
September 20, 2014 at 1:34 am
"Wah. Wah. It should all just automatically work. Wah Wah."
Lazy.
Showing my age here but YES. The whining seems to come from those who have very quiet keyboards and mouths...
September 17, 2014 at 2:56 pm
I had a lot of fun reading the drafts of these articles and they both opened my eyes and dispelled quite a few misconceptions.
I wish I had known everything that...
September 12, 2014 at 2:44 pm
Perhaps of even greater impact will be the revolution in RAM that is just around the corner. The technique that allows spinning disk to hold TB of data in...
August 25, 2014 at 5:40 am
Amen to that.
I am making the switch from TDD to BDD (behaviour driven development) simply because the readability of the tests and output is vitally important in demonstrating software quality...
August 25, 2014 at 5:31 am
I've been watching a series following the training of the Royal Marines. One of the corporals made the comment that their standards are very high for a reason. ...
August 22, 2014 at 1:35 pm
K. Brian Kelley (8/15/2014)
While some work places are great, I see the following too often:
- Long hours are expected of IT workers...
August 18, 2014 at 1:33 am
Back in the SQL2000 days replication would retry 3 times if it failed and on each attempt it would provide the DBA with an alert. Then it would give...
August 14, 2014 at 1:13 pm
What about full text search. It could have been good but the Solr/ElasticSearch horse has well and truly bolted.
August 12, 2014 at 3:17 pm
No, they follow the cluster approach, and even deprecate mirroring. We can only guess what it would have been.
It seems to have turned into Always-on availability groups.
August 12, 2014 at 3:16 pm
Back in the C19th they didn't care about clean water and drainage. In fact Joseph Bazellgette was lampooned for suggesting that London needed such things.
Amazing what rampant Cholera and...
August 11, 2014 at 1:34 am
Viewing 15 posts - 1,516 through 1,530 (of 3,617 total)