Sign Up

Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Have an account?

Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Don't have account,

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask a question.

Need An Account,

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Home/MS SQL

Deepak Baghel – Smart Coding, Real Solutions Latest Articles

On: January 28, 2025 Posted in CMD, MS SQL Comments: 1 Views: 31k

Full backups of all databases in the local named instance of SQLEXPRESS by using Windows Authentication

Example 1: Full backups of all databases in the local named instance of SQLEXPRESS by using Windows Authentication sqlcmd -S .\SQLEXPRESS -E -Q “EXEC sp_BackupDatabases @backupLocation=’D:\SQLBackups\’, @backupType=’F'” Example 2: Differential backups of all databases in the local named instance of ...

On: September 26, 2024 Posted in MS SQL Comments: 0 Views: 74k

Clear The SQL Server transaction log

Managing SQL Server Transaction Logs: A Step-by-Step Guide Effective management of transaction logs is crucial for maintaining the performance and storage efficiency of your SQL Server databases. In this post, we’ll walk through a practical example using the AdventureWorks2008R2 database, ...

On: September 23, 2024 Posted in MS SQL, C# Comments: 0 Views: 23k

Sql server Connection String with C#

  Setting Up the Connection String A connection string contains information about how to connect to the database. In your case, the connection string is: <add name=”DbConnection” connectionString=”Data Source=.;Initial Catalog=BH_Report;Integrated Security=true;” providerName=”System.Data.SqlClient”/> Data Source: The server where the database is ...