Tag Archives: sql

Database Diagrams with SQL Server Management Studio

Database Diagrams lets us see the relationship between entities in a database. In this article I will give you a step-by-step guide on how to Create a New Database Diagram with …

Tags: , , , , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 2, MSSQL, WebsitePanel Tutorials, Windows Server Admin | Leave a comment

Determine the Last Time a SQL Trigger was Used

In SQL 2008 and higher there is a new feature that can help audit triggers. By running the script below you can get some important information about triggers that are …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Setting Up Data and Log Files For SQL Server

NOTE: As with all SQL Server ALTER DATABASE commands, I strongly suggest you back up your data before running these scripts. Among the many questions and options when setting up …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment