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.
Tags : mssql
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
5 good reasons to upgrade to SQL Server 2016
the following 5 reasons will make you want to upgrade to sql server 2016 without hesitation.
Microsoft releases updates for SQL Server 2017 and Azure data services
at the pass summit 2017 conference yesterday, microsoft announced several new improvements to sql server 2017 and azure data services.
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.