Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 311 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, 399 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, 393 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, 507 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, 372 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…

Read more

1 comments, 319 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, 410 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…

Read more

0 comments, 394 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, 995 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, 379 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, 289 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, 1,267 reads

Posted in DatabaseExpertise.com on 4 April 2011