How to create a New Database in SQL Server

As a Database developer or Administrator you will be required to create a New Database at some point. You have two ways of doing that: Using SQL Server Management Studio (SSMS) interface or by using a T-SQL script. Let’s have a look at both options.   Create a new database using SSMS visual interface Open SSMS In Object Explorer (Left side of the application) Right Click on the Database node and…

Read more Leave a comment

How to restore a database backup in SQL Server

As a database developer or administrator it often happens that you need to investigate a bug and do tests on a previous versions of a database or just run a stored procedure that alters data on the wrong table and screw things up. That’s why we keep backups. (.BAK files) All good when you have one but how do we restore a database from a backup? Well pretty simple. Here’s…

Read more Leave a comment

Building a SSRS Report that sends emails

I’ve been tasked recently with building a SSRS report that displays the count of users that will receive a welcome email. So this is what the report should do: Show how many users registered to the site and did not receive a welcome email. Have a button that will act as a trigger to send emails Sounds simple. How hard can it be, right? Well, reports built with SQL Data…

Read more Leave a comment

How to find a table in your database using SQL Server

Find where a table is stored in your databases using the below query. Same principle applies when looking for a column name. Replace MytableName in the WHERE  clause withe the keyword you need. Execute the query by pressing F5 or the Execute button.     SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE t.name LIKE ‘%MytableName%’ ORDER BY schema_name, table_name; by

Read more One Comment

How to find a column in your database using SQL Server

I bet there were times when you didn’t know the structure of your database and you were looking for a specific column. Well that happens a lot when you start working on a new project, a new database and so on. A very easy way to find the column you were looking for is by using the below script. Open a new query window in Microsoft SQL Server and paste…

Read more Leave a comment

Subscribe to our newsletter and stay up to date with:

  • Latest posts
  • News and Articles
  • Products, Promotions and Giveaways

Get our FREE step by step guide to Building SSRS reports 101

Hide me
Show me
Build an optin email list in WordPress [Free Software]