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

To contract or not to contract – that is the question !

I’ve been deliberating over the last few years whether to make the leap into the contracting/consulting world.

Speaking to a good friend of mine last week has again opened up the debate in my head.

There are numerous advantages and disadvantage in leaving a somewhat stable permanenet job to go… Read more

0 comments, 286 reads

Posted in DatabaseExpertise.com on 18 May 2012

Help I’m an Oracle guy – whats all this SQL Server stuff ?

Having ventured into both the SQL Server world and the depths of Oracle RDBMS – Im often asked what the differences between the two are, or more often than not what, what my preference would be in choosing one technology.

Each has its own benefits for their own situations.

But… Read more

0 comments, 397 reads

Posted in DatabaseExpertise.com on 18 May 2012

I’m back !

Hello Everyone – its been a while.

I’ve been out of the blogging scene over the last year or so due to ongoing work commitments.

I’m back now though and intend on posting updated blogs daily – both useful tips and my somewhat sceptical view of the world !

This… Read more

0 comments, 282 reads

Posted in DatabaseExpertise.com on 12 May 2012

New Diagnostic Manager functionality

 

The latest version of Ideras’ SQL Diagnositc Manager offers some pretty nifty predictive analysis capability. Offering at present, a 12 hour forecast.

This gives you the likelihood of what might happen – a powerful trait for any DBA surely ?

Also the reports “database growth forecast” and “disk space usage… Read more

0 comments, 461 reads

Posted in DatabaseExpertise.com on 6 May 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, 299 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, 382 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, 375 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, 480 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, 351 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, 299 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, 392 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, 380 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, 968 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, 359 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, 272 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,216 reads

Posted in DatabaseExpertise.com on 4 April 2011

Oracle Drops the Bomb

The below information has been taken from SSWUG.org.

Oracle Drops the Bomb
Since the purchase of Sun and it’s holdings by Oracle corporation there has been much speculation regarding the leverage Oracle now owns in the Server and RDBMS worlds. An March 23rd Oracle has begun flexing that muscle, announcing… Read more

1 comments, 271 reads

Posted in DatabaseExpertise.com on 28 March 2011

DevWeek 2011 – Day 1

Unfortunately, I couldn’t be in two places at one time, there were two tracks dedicated to the SQL Server DBA and the topics were equally appealing in both tracks. To start I chose Performance Enhancements in SQL Server 2008. The speaker Bob Beauchemin, A SQL Server developer from Portland, Oregon… Read more

1 comments, 286 reads

Posted in DatabaseExpertise.com on 25 March 2011

OUG Back to Basics Event – London Mar 2011

First Things First

At UKOUGs’ Back to Basics Special Event held in London today (Mar 24th), Niall Litchfield presented a very worthwhile session on “Getting the Basics Right”.

Now I’ve been more of a SQL Server DBA in recent years than I have an Oracle one, so this session was… Read more

0 comments, 227 reads

Posted in DatabaseExpertise.com on 25 March 2011

DevWeek 2011 – A DBAs view

The title itself would lead you to believe this conference was only for the those looking to master the art of Silverlight or those busting to find out what’s new in the latest version of C# ! But no – over the last couple of years the SQL Server DevCon… Read more

0 comments, 336 reads

Posted in DatabaseExpertise.com on 17 March 2011

Older posts