A time may come when you will need to alter your database to use a different collation. You can do this by using the following snippet: USE master;…
sql
7 Articles
7
To get a rough view of how many rows, total, used and unused space each table has, in a sql server database you can run…
In Entity Framework code-first, if you have a domain model like the following: public class Country { public int Id { get; set; } [Index]…
In Azure if you have two or more SQL Databases and you want to perform a query across them, you might come across the following error: Reference to…
These are some quick notes on how to configure an SQL Server to Listen on a Specific TCP port. Open Run Command line and type: SQLServerManager12.msc for SQL…
SQL Server management studio allows you to have Database Diagrams to graphically show the structure of the database. In addition, you can create and modify tables, columns,…
Page 1 of 1