Recover sa password or gain sysadmin access to a database

Recover sa password or gain sysadmin access to a database

Please do not re-install SQL server if you forgot/don’t know the sa password or you do not have sysadmin access to the database but you want to have. Try one of the below to recover the access.

Chicken Tandoori / Home Style / Indian Spicy

Chicken Tandoori / Home Style / Indian Spicy

Ingredients

  1. Chicken legs [4 pieces]
  2. Ginger paste [1½ tablespoon]
  3. Garlic paste [1½ tablespoon]
  4. Turmeric powder [1 tablespoon]
  5. Cumin powder [1 tablespoon]
  6. Lemon juice [1½ tablespoon
  7. Red chilli powder [1½ tablespoon]
  8. Green hot chilli paste [½ tablespoon]

Errors in the ole db provider

I have encountered this below error while I was trying to connect SQL Server Analysis Services cube using Microsoft Excel 2010.
Errors in the ole db provider: an error occurred while loading the connection dialog box component for prompting.
I remember it was working fine couple of month ago.
Now, this is how I have resolved the issue by re installing SQL server 2008 AS OLEDB drivers:
1. Go to https://www.microsoft.com/en-us/download/details.aspx?id=6375
2. Click “Download”

How to automate deployment using msbuild through command prompt

Pre-requisite is .NET framework

Assuming that .net framework is already installed in your machine.

Now follow the below instruction whether MSbuild command is working or not.
1. Open command prompt
2. Write msbuild /? and hit Enter

If you are getting below message, then it is certain that correct path is not configured to recognize the command.
'msbuild' is not recognized as an internal or external command, operable program or batch file.

Microsoft SQL Server - Find all the executed queries related with a table

Microsoft SQL Server - Find all the executed queries related with a table

In this tutorial, we’ll discuss on how to find all the executed queries related with a table in one database.

To get the all the queries that are executed in the database and related with a particular table, use below script.

Microsoft SQL Server - Find Row Count of all the tables

In this tutorial, we’ll discuss on how to find row count of all the table in one database.

To demonstrate this topic, SQL Server 2008 R2 Express version is being used. The exact version information is

Microsoft SQL Server - Find a particular text within Stored Procedure, View and Function or as Column name in a table

In this tutorial, we’ll discuss on how to find Stored Procedures, Views and Functions which contain a particular text in it. Also, we’ll discuss on how to find tables which has a column name with a particular text.

Different String Types in Delphi

In Delphi, String is a sequence of characters. There different types of string available in Delphi for different purposes.
Types of string are:
1. ShortString
2. AnsiString
3. WideString
ShortString
Maximum length can be 255 characters. Memory required for this type of string is 2 to 256 bytes. Generally, this is used for backward compatibility.
AnsiString

Bee Dance (Waggle Dance)

Dance Language of the Honey Bee

Waggle dance definition:

Communication system is defined as connect or communicate with other people, i.e. means that “any sharing of information”. Honey bees use special types of complex communication system in the form of a dance language to communicate or to inform members about the location of a food source. This special type of dance system is called “Honey bee dance”.

Why do bees do waggle dance:

Stepping into the IT world

IT industry, home of thousands of jolites…future home of thousands more. Each year hundreds of engineering graduates like us find their place in this immense world of opportunities. Like hundreds of seniors of ours, now I share a tiny place in the middle of this ocean of information.

As I write this article, I feel lucky enough to gain some knowledge in this field to put together and pen down some of the topics that I observed and can be helpful to my fellows who are taking the penultimate step before joining the industry.

Pages

Subscribe to everyEthing RSS