Muthusamy Anantha Kumar

(“Microsoft.SqlServer.Smo”) | out-null $srv=New-Object “Microsoft.SqlServer.Management.Smo.Server” When the above cmdlets is executed, it displays the table property of all of the tables in the AdventureWorks database, as shown below. [Refer Fig 1.2] Result Parent : [adventureworks] AnsiNullsStatus : True CreateDate : 4/26/2006 11:44:31 AM DataSpaceUsed : 808 DateLastModified : 4/26/2006 11:45:46 AM FakeSystemTable : False FileGroup […]

LoadWithPartialName(“Microsoft.SqlServer.Smo”) | out-null $srv=New-Object “Microsoft.SqlServer.Management.Smo.Server” The above cmdlets display the tables names from the AdventureWorks database on the “HOME\SQLEXPRESS” server. [Refer Fig 1.2] Result AWBuildVersion DatabaseLog ErrorLog Department Employee EmployeeAddress EmployeeDepartmentHistory EmployeePayHistory JobCandidate Shift Address AddressType Contact ContactType CountryRegion StateProvince BillOfMaterials Culture Document Illustration Location Product ProductCategory ProductCostHistory ProductDescription ProductDocument ProductInventory ProductListPriceHistory ProductModel ProductModelIllustration ProductModelProductDescriptionCulture […]

This script will take the Transaction log backup of the MyDatabase database onto the folder c:\test as shown below. [Refer Fig 1.3] Fig 1.3 Method 3 Let us assume we have a database ‘MyDatabase’, on the server ‘HOME’. Now let us assume that we want to take a Differential backup of the databases onto the […]

The above command created the ‘MyDatabase’ database on the ‘HOME’ server, using the default values and path. [Refer Fig 1.1 and 1.2] Fig 1.1 Fig 1.2 Method 2 Let us assume that we have to create a new database named ‘MyDatabase1’ on the ‘HOME’ server. Let us also assume that the data file should be […]

“Server=$SQLSERVER;Database=master;Integrated Security=True” $SqlCmd = New-Object System.Data.SqlClient.SqlCommand $SqlCmd.CommandText = “select ‘Servername: Step 2 Execute the script shown below. [Refer 1.1] ./connect2 "HOME" Note: HOME is the server name. Please change it to your server name. Result Result —— Version:Microsoft SQL Server 2000 – 8.00.2039 (Intel X86) … Servername: HOME Database: VixiaTrack Database: vixiadata Database: vixia Database: […]

Let us assume that we have the following code on PowerShell script ‘a.ps1’. [Refer Fig 1.1]Echo “test” If we try to execute the script when PowerShell’s execution policy is restricted, we get the following error message. [Refer Fig 1.2] Command to Execute a PowerShell script. /a.ps1 ResultFile C:\ps\a.ps1 cannot be loaded because the execution of […]

As you probably know, Windows PowerShell is the new command shell and scripting language that provides a command line environment for interactive exploration and administration of computers. In addition, it provides an opportunity to script these commands so that we can schedule and run these scripts multiple times. Windows PowerShell depends on .NET framework 2.0. […]

SQL Server Database administrators often have requirements such as importing multiple files to a table on a database. This article discusses how to upload multiple files, especially XML files, to the SQL Server database XML data type column. Pre-requisite a.  Make sure xp_cmdshell is enabled. If it is not enabled, execute the following command as […]

The objective of this article is to guide Microsoft SQL Server Database Administrators on how to: Create XML Schema Create a table with XML data type Import XML file to the table with XML data type Query the XML file Query the XML file and produce results, similar to results produced by Transact SQL Statements […]

In Part I, part II and part III of this article series, we saw how to use simple case expressions in queries. In this installment, I illustrate how to use case functions in clauses like ‘group by’. Method 7: Usage of the simple case function in GROUP BY clause Let us assume we have the […]

In Part I and Part II of this series, we have illustrated how to use simple case expressions in queries. In this installment, I am going to illustrate how to use case functions in clauses such as group by. Method 6: Usage of simple case function in GROUP BY clause Let us assume we have […]