Archives: April 2011
DevConnections – Heavily Discounted Passes !
DevConnections – London June 2011
DatabaseExpertise has negotiated 10 tickets for the main 2 day conference, at an amazing price of £100!!!
The first 10 people to call Penton with their credit card details on 0161 929 2800, quoting MSD0611 – databaseexpertise.com; will be registered
Come and hear from… Read more
0 comments, 193 reads
Posted in DatabaseExpertise.com on 28 April 2011
Daily Denali Delight – Day 6
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to expect some excellent new features.
Here I continue to delve into these delights, highlighting those to look out for.
Juneau (New Development Environment)
Juneau is the code name… Read more
1 comments, 259 reads
Posted in DatabaseExpertise.com on 28 April 2011
Daily Denali Delight – Day 5
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to expect some excellent new features.
Here I continue to delve into these delights, highlighting those to look out for.
Spatial Features
Not that I get to play around… Read more
2 comments, 249 reads
Posted in DatabaseExpertise.com on 27 April 2011
Daily Denali Delight – Day 4
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to expect some excellent new features.
Over the next week or so, I aim to delve into these delights, highlighting those to look out for.
FileTable
Another new feature… Read more
2 comments, 313 reads
Posted in DatabaseExpertise.com on 26 April 2011
Daily Denali Delight – Day 3
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to expect some excellent new features.
Over the next week or so, I aim to delve into these delights, highlighting those to look out for.
Columnar Indexes
Dubbed as… Read more
1 comments, 223 reads
Posted in DatabaseExpertise.com on 21 April 2011
Daily Denali Delight – Day 2
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to expect some excellent new features.
Over the next week or so, I aim to delve into these delights, highlighting those to look out for.
Day 2 – Contained…
1 comments, 180 reads
Posted in DatabaseExpertise.com on 21 April 2011
Daily Denali Delight – Day 1
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released (is this still unconfirmed?) you can be sure to expect some excellent new features.
Over the next week or so, I aim to delve into these delights, highlighting those to look out for. Read more
0 comments, 236 reads
Posted in DatabaseExpertise.com on 20 April 2011
CodeName for the next generation of SQL Server??
Ever since the first version of SQL Server (1988??), Microsoft has found some interesting codenames for their releases
- 1993 – SQL Server 4.21
- 1995 – SQL Server 6.0 was called SQL95
- 1996 – SQL Server 6.5, was called Hydra
- 1999 – SQL Server 7.0, was called Sphinx
- 1999 – SQL…
0 comments, 256 reads
Posted in DatabaseExpertise.com on 20 April 2011
Optimising SQL Server for Sharepoint 2010
I attended the SharePoint Best Practices Conference this week in London. As a complete newbie, this event was superb - a lot of quality speakers, experts in the world of SharePoint and loads of knowledge to share.
One of the sessions on Day 2 revolved around what DBAs need to… Read more
1 comments, 672 reads
Posted in DatabaseExpertise.com on 14 April 2011
Cloud computing – not without risk?
Interesting quote from Sharepoint Best Practices Conference :” 17% of IT Pros think benefits of cloud computing outweigh the risks”!!
That’s not too encouraging is it?
Few other points:-
Not all computing resources should reside on the cloud anyway.
It’s not always cost effective?!!
Do your homework before making the… Read more
1 comments, 204 reads
Posted in DatabaseExpertise.com on 11 April 2011
Hostettler & the Bottleneckers
A bit of fun !
A long long time ago before the dawn of 2010, somewhere to the South of the United Kingdom lay the realm of SQL. The protector of the realm was Hostettler, a Viking DBA with a wealth of experience and renowned fame.
Therein dwelt DBAs of… Read more
0 comments, 149 reads
Posted in DatabaseExpertise.com on 8 April 2011
Developing with SQL Server: Three ways to get at data
Getting at data within a .NET application can be straightforward using built in controls or much more complex through connections, commands and data readers to name but a few. This article is a short introduction to each of the available options.
1. Using a SQLDataSource
The built-in .NET controls for… Read more
4 comments, 793 reads
Posted in DatabaseExpertise.com on 4 April 2011



Subscribe to this blog