SQL Server 2012 Archives - Page 3 of 10

SSMS Auto Recovery

Apr 17, 2014 | DavidP, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQLSaturday, SSMS | 0 comments

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...

From where does SSMS get its database defaults?

Apr 16, 2014 | DavidP, SQL Server 2008 R2, SQL Server 2012, SQLSaturday, SSMS | 0 comments

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...

Missing Database Owner

Apr 14, 2014 | DavidP, SQL Server 2008 R2, SQL Server 2012, SQLSaturday, SSMS | 0 comments

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 scenarioA DBA creates a new database and by doing so he become the owner...

Alter Table Not Permitted

Apr 10, 2014 | SQL Saturday, SQL Server 2008 R2, SQL Server 2012, SSMS | 0 comments

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...

Dedicated Administrator Connection

Apr 9, 2014 | DavidP, SQL Server 2008 R2, SQL Server 2012, SQL Training, SQLSaturday, SSMS | 0 comments

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...

SQL Server 2012 and Virtual Service Accounts

Jan 13, 2014 | SQL Server 2012 | 4 comments

This post is written by David PostlethwaiteIf you are using SQL Server 2012 you will probably have noticed that the default account for the SQL services has changed from that used in previous versions. With SQL 2005 and 2008 the default account for SQL service and SQL...