Of course, this is not an exhaustive list that describes the application of these tools and you will find them useful in troubleshooting other issues in SQL Server as well. In my future posts, I will attempt to describe how I used these tools to troublesho...
The following sections describe SQL Server Setup log files. Summary Text Overview This file shows the SQL Server components that were detected during Setup, the operating system environment, command-line parameter values if they are specified, and the overall status of each MSI/MSP that was execute...
“An item with the same key has already been added” in dictionary (401) Unauthorized Issue asp.net and IIS [RESOLVED] [error] It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level [Help]: System.Net.WebException: The underlying connection...
When it comes to big amount of data, Excel application is not the best solution to work with, in case of storage. Much better fit would be a database like Access or MSSM. In this article I’m going to show You how to connect to Microsoft SQL Server using VBA. Database & server In...
All future development should use the Az.Sql module. Users are advised to migrate from AzureRM to the Az PowerShell module to ensure continued support and updates. The AzureRM module is no longer maintained or supported. The arguments for the commands in the Az PowerShell module and in the...
1. Go to the article for SQL Server 2008 Cumulative Update 1 (CU1). Later in this post, I'll talk about our plans to provide a known KB article which you can always use to find the latest set of fixes for setup. 2. Download the hotfix package just as though you are go...
For example, if you want to pull someone's address, the field name may not just be “address” — it may be separated into address_city, address_state, address_zip. To figure this out, use the query “Describe people_massachusetts;”. This provides a list of all the data you can pul...
There are several reasons behind the MDF to SQL file conversion. Mainly, we describe some of them have a look: 1.Versatile Usage:By migrating the .mdf file to SQL script, a user can use these files on multiple servers. the use of the MDF files can be increased by the users as per ...
If you are so inclined, you can, using the techniques I describe here, store every table script as an extended property attached to the table, but I’ll be describing how you can, using PowerShell, even tease out all the end-of-line comments and block comments from the source and store...
Now, you want to know the structure of the table then you can use SHOW COLUMNS command 1 2 3 SHOWCOLUMNSFROMcategory; The SHOW COLUMNS and DESCRIBE commands are alias of each other. 6. SHOW INDEX FROM table_name [FROM database_name] ...