Archives: April 2014
SSMS Add-ons
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
SSMS is a fantastic tool but many people and companies have found ways to enhance it to make it even…
0 comments, 24,683 reads
Posted in The SQL DBA in the UK on 24 April 2014
SSMS Queries on Function Keys
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
If you have simple queries or functions that you use regularly you can assign them to a…
0 comments, 843 reads
Posted in The SQL DBA in the UK on 23 April 2014
SQL Server Training – Spring 2014
I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA skills upgrade class in an onsite class to one of Learning Tree’s clients. For those of you that don’t know, a Learning Tree onsite is event is when Learning… Read more
0 comments, 830 reads
Posted in The SQL DBA in the UK on 22 April 2014
Central Management Studio CMS
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
One of the subjects I covered was Registered Servers and the Central Management Studio
These are two…
0 comments, 1,934 reads
Posted in The SQL DBA in the UK on 21 April 2014
SSMS Auto Recovery
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
SQL Server Management Studio will autosave your unsaved query every few minutes so if if your pc…
0 comments, 815 reads
Posted in The SQL DBA in the UK on 17 April 2014
From where does SSMS get its database defaults?
We can create a database simply by typing in the command
create database DB1
We don’t have to provide any other parameters for SSMS to be able to create the database
My Question is from where does SQL get the default values when we create a database without any options?
0 comments, 2,346 reads
Posted in The SQL DBA in the UK on 16 April 2014
Missing Database Owner
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
A scenario
A DBA creates a new database and by doing so he become the owner of…
0 comments, 1,645 reads
Posted in The SQL DBA in the UK on 14 April 2014
Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
You may have come across this error message when using SQL Server Management Studio
It’s new in…
0 comments, 667 reads
Posted in The SQL DBA in the UK on 10 April 2014
Dedicated Administrator Connection
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
If a SQL instance isn’t responding or you can’t login for some reason then SSMS has a…
0 comments, 678 reads
Posted in The SQL DBA in the UK on 9 April 2014
SQL Saturday Exeter
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time, my friend, colleague and fellow contributor to this blog, David Postlethwaite was making his full speaking debut delivering a session entitle “Real DBAs Don’t need a GUI” it was a… Read more
0 comments, 561 reads
Posted in The SQL DBA in the UK on 7 April 2014