Tag Archives: sql

SQL Connectivity Behavior

Connecting over the Network By default, the default protocol for SQL Server clients is TCP/IP. If the connection cannot be made using TCP/IP, the other enabled protocols are attempted. A shared memory connection cannot be made over a network. Use … Continue reading

Posted in develop | Tagged , | Leave a comment

SQL Server 2016 SP1

https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/   Understanding Incremental Servicing Model for SQL Server A CLONED database always contains the schema and the default clone also contains the statistics and query store data. For more information refer KB 3177838. How to determine the version, edition and update level … Continue reading

Posted in develop, Uncategorized | Tagged , , | Leave a comment

Microsoft SQL Server Powershell

https://www.mssqltips.com/sqlservertip/1759/retrieve-a-list-of-sql-server-databases-and-their-properties-using-powershell/ https://books.google.co.uk/books?id=SjnlCwAAQBAJ&pg=PA344&lpg=PA344&dq=sql+powershell+set+PrimaryFilePath&source=bl&ots=n8gFMa3Cq8&sig=wkCX6kKziGyEgBBPgvXFe9ZbSL0&hl=en&sa=X&ved=0ahUKEwjz2sfxjZvPAhXDZpoKHdDuDiAQ6AEIQDAF#v=onepage&q=sql%20powershell%20set%20PrimaryFilePath&f=false https://books.google.co.uk/books?id=SjnlCwAAQBAJ&printsec=frontcover http://sqlblog.com/blogs/allen_white/archive/2008/04/28/create-database-from-powershell.aspx To see the details on any error run: $error[0]|format-list -force

Posted in develop | Tagged , , , , | Leave a comment