12 days of Geekmas..on the 3rd day

Yes, I am a geek and Yes, I'll do almost anything for something geeky :-)

#BADSQL 2

This is my 2nd submission for bad SQL..

Bad SQL 2:
The dev system has run out of disk space.  Lets shrink all the databases, that will free up some space.

EXEC sp_MSForEachDB 'DBCC SHRINKDATABASE (''?'' , 0)'

It might seam like a good idea, but it does apply to EVERY database.
DBCC SHRINKDATABASE ('master' , 0)
DBCC SHRINKDATABASE ('tempdb' , 0)
DBCC SHRINKDATABASE ('model' , 0)
DBCC SHRINKDATABASE ('msdb' , 0)
DBCC SHRINKDATABASE ('ReportServer' , 0)
DBCC SHRINKDATABASE ('ReportServerTempDB' , 0)
…

SQL Event Calendar

 

The SQL event calendar for next year is filing up!!

Tell your friends/colleagues and your pets!

 

SQL Santa London (#sqlfaq) 14th December - http://sqlserverfaq.com/events/452/SQL-Santa-2012.aspx

SQL Saturday Exeter (#sqlsat194) 8th-9th March – http://www.sqlsaturday.com/194/eventhome.aspx

SQLBits XI Nottingham (#sqbits) 2^nd–4^th May - http://sqlbits.com/

SQL Saturday Scotland  Edinburgh (#sqlsatscotland)  7th-8th June - https://twitter.com/SQLScotland

SQL Relay – (#sqlrelay) Dates coming up…. 

SQL Server User Groups (UK Wide) Various dates (#sqlfaq) - http://sqlserverfaq.com

SQL Saturdays (World) Various dates (#sqlpass) http://sqlsaturday.com

Bad SQL, Naughty SQL!

 

During my time as a dev, I’ve done some bad things in SQL, some terrible things that still give me nightmares. 

But I feel like a bit of therapy and I should share, and perhaps you would like to share too?

Bad SQL 1:

I think I used it on a dev system that ran out of space.

   1:  EXECUTE sp_MSforeachtable "ALTER TABLE ? REBUILD WITH (DATA_COMPRESSION = page)";  

 

Feel free to share your BAD SQL, please post anonymously if you are too ashamed.

SQLBits XI and SQL Saturday Exeter (194)

It never rains but it pours, not one but two SQL conferences for us to get our teeth into.

SQLBits is back and in the Midlands, Nottingham to be precise – the home of Robin hood… 2nd-4th May.  www.sqlbits.com

And SQL Saturday Exeter (192) is taking place on the 9th of March at Jurys Inn Hotel Exeter, Western Way, Exeter http://www.sqlsaturday.com/194/eventhome.aspx

I’ll be there! Hopefully you can be too!

Hello Proteo!

Today I took up my new role as Lead Developer/Architect at Proteo. 

They do a number of really interesting products; check out their website!

I have an idea of what I will be doing, but all will be revealed over the next few weeks.

Its going to be an exciting time. 2 weeks after I start there is an office move. I got to visit the new office today. 

(Here are some pictures from the development floor )

Goodbye Co-operative work family

This week I’m taking up a new challenge and moving to Proteo – It’s not only a job change but a relocation up to Norwich.  Its a huge change and a big challenge, but its one I’m very much looking forward to. 

I am leaving behind my ‘work’ family, all the people I have known over the last 6 years, people I have spent 45 hours week with, through thick and thin, good times and incredibly stressful times.  But now with the *unsocial media of Facebook and twitter I can still badger them and try to get them to go to the Southampton SQL Server User Group or the Southampton NxtGen user group.

I would like the thank my close work family (the Guys and Girls in Eastleigh) but also the cousins in Manchester and Stoke.  I will miss everyone of you! 

I am also temporary leaving behind Zara, Tabitha and Matilda – but not for long, they will be following me up very very soon.

Mark

*How social can social networking be, when you do it on your own? Doesn’t that defeat the point of being social?

And Finally in the words of Peter Cook & Dudley Moore…

Goodbye… (YouTube)

“Goodbye, we wish a fond goodbye, fa-ta-ta-ta-ta, fa-ta-ta-ta”

Full Lyrics here (search for goodbye)

SQL Sat #162–What do you get out of it?

I’ve just got back from SQL Saturday #162 Cambridge and two people have asked me “What do you get out of it?”

Two things struck me;

a) How difficult it was to come up with something tangible (there are plenty of intangible reasons) – I got a helper shirt.

b) The phasing of the question, the expectation of ‘getting something’.

 

So why do I do it? Why get involved?

BECAUSE I CAN and because I enjoy it.  I enjoy the satisfaction of putting on a good event, I get a kick from knowing I was part of a team that made stuff happen.

So it’s not about what you get out of it; it’s about what you put into it that matters.

 

Why Don't You Just Switch Off Your Television Set and Go and Do Something Less Boring Instead? 

Go to a local User Group?  Go to a SQL Saturday ? Go to SQLBits ?

Get involved!! The intangible benefits are huge…but that’s another blog post.

 

MPM (@tsqltidy)

SQL Server Management Studio (SSMS) Add-in update

Its been a while, infact a very long time since I blogged about anything....blah..blah..blah

I did some work on a SSMS Add-in for Denali, and I've only just started to look at SQL Server 2012...

Guess what... Its doesn't work! I know that Add-in for SSMS are not supported, but please.. could we have it working between any two versions?!?!

This time, its an easy fix.  The folder the .addin files are being picked up from has been changed.
So instead of looking here; C:\Users\Public\Documents\microsoft\msEnvShared\Addins
Your .AddIn needs to go here instead; C:\ProgramData\Microsoft\MSEnvShared\AddIns

Very easy to fix, but a pain to find solution.