Attach database in Microsoft SQL Server 2008
this article will illustrate the different usage methods of the 'for attach' clause to overcome the limitations encountered when using sp_attach_db and sp_attach_single_file_db.
Tags : sql server
Test SQL Server with Windows PowerShell - Part 7
in this section, i will show you how to get that information in top 10 queries based on cpu performance.
Test SQL Server with Windows PowerShell - Part 1
instead of using vbscript, bat files, or sql client implementations, ... we'll show you the power of windows powershell in checking sql servers status.
Test SQL Server with Windows PowerShell - Part 2
this part 2 will show you how to access the windows service on the remote computer using windows powershell and wmi-object.
Test SQL Server with Windows PowerShell - Part 3
in part 3, i will show you how to find some hardware and operating system information from the host machine.
Test SQL Server with Windows PowerShell - Part 4
in this next section, i will show you the information about network card and hard drive from the server.
Test SQL Server with Windows PowerShell - Part 5
in this part 5, we will check whether we can connect to sql server and see if we can query some properties related to sql server.
Test SQL Server with Windows PowerShell - Part 6
part 6 will show you how to check all existing databases in the sql server instance and query the database properties.
CASE function in SQL Server (part 1)
in sql server, the case function verifies the value based on the list of given conditions, then returns one or more results. in this article we will illustrate a number of
Microsoft stopped supporting SQL Server 2008 and Windows Server 2008
sql server 2008 and 2008 r2 will stop supporting on july 9, 2019. windows server 2008 and 2008 r2 will stop supporting on january 14, 2020.