Apr 21, 2014 | DavidP, SQL Saturday, SQL Server 2008 R2, SQL Server 2012, SSMS |
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...
Apr 17, 2014 | DavidP, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQLSaturday, SSMS |
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...
Apr 16, 2014 | DavidP, SQL Server 2008 R2, SQL Server 2012, SQLSaturday, SSMS |
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...
Apr 14, 2014 | DavidP, SQL Server 2008 R2, SQL Server 2012, SQLSaturday, SSMS |
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...
Apr 10, 2014 | SQL Saturday, SQL Server 2008 R2, SQL Server 2012, SSMS |
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...
Apr 9, 2014 | DavidP, SQL Server 2008 R2, SQL Server 2012, SQL Training, SQLSaturday, SSMS |
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...