885 0
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
sql performance tips
695 0
Restore (Import) database from .bak file in SQL server (With & without scripts)
In this short article, I am giving steps with images to restore database from .bak file in SQL server & I have also explained ways in sql server to restore database from bak file using script.
Type
Article
SQL restore database using .bak sql server sql restore database from bak file script
670 2
Getting error 'A transport-level error has occurred when receiving results from the server.'

When I am trying to Load page of my clients web application, which has shared connection string, I am getting the below error

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

...

Type
Question
SQL sql-server transport-level error
669 2
Where can I download SQL server 2016 express full?

Hi, I have searched on google about links to download complete sql server express 2016 full version but i wasn't able to find it, as previous version of SQL Server Express were available in both web and full downloads, so can anyone provide me link(s) to download full sql server express 2016(preferred) or 2017 edition

Need offline installer, thanks

...
Type
Question
SQL-Server-2016 sql express 2016 offline installer sql express 2016 management studio
669 1
how to take back up of all sql server databases?

I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.

 

...
Type
Question
SQL Back-up all-databases SQL-Server

648 0
Stored procedure in sql server (With Example)
In this article, I have explained basics and important points to understand stored procedure in sql server with examples.
Type
Article
SQL stored procedure in sql server stored procedure in sql sql create stored procedure sql server procedure
645 2
How to retrieve an int from Stored Procedure and not an objectResult using EF ???

Hi,

 

im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data.

after setting i should recive an int id of the record that was created.

my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int...

How to retrieve an int from Stored Procedure using EF ???

...
Type
Question
sql web service
642 0
SQL server date format and converting it (Various examples)
This article provides you in-depth knowledge of SQL server date format available and how to convert from one date format to other using examples
Type
Article
SQL Sql server date format date format conversion SQL
611 0
Row constructor in SQL server (Explanation With example)
This article gives a quick explanation about Row constructor (Table value constructor) in SQL server with various usage example
Type
Article
SQL Row constructor Table Value Constructor
609 1
Database Threats and how to Prevent them

I am tasked with security of the systems database, as the previous operation lacked security and left gaping holes in the system. The Systems information was leaked, and clients records were leaked as well as workers salaries. I need to find One technique or strategy to prevent this information loss, and propose how we will prevent this in future. I am relatively new to DBMS, can you please help me.

...
Type
Question
DBMS SQL

Page 2 of 5