One new feature in SQL Server Management Studio 2008 is the ability to restrict changes that would force a table to be re-created. This is a safety valve which can be turned off, if you choose. Let’s ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Yes, I'm currently working with Access. And boy thats fun. Is there a way to generate the SQL create script for a group of tables in Access and then run that against another Access database? The ...

As a SQL developer, I've encountered many of the shortcomings and limitations of SSMS. Looking for an opportunity to practice C#, I decided to create a tool that addresses the issues I personally ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...