Have you been in a situation where you wanted to make a backup of a database and restore to another server and realized you couldn’t backup and restore to the new location because of the size of the database? How about even after dropping or truncating huge tables and still the database size is not […]
This is a simple script l wrote in SQL server 2012 which can be used to populate the Date table for use in a data warehouse. It provides components of the date which can be used in any situation. IF OBJECT_ID(‘tempdb..##Dates’) IS NOT NULL DROP TABLE ##Dates CREATE TABLE ##Dates(DateValue Date, YearValue INT, MonthValue INT, […]
Waterfall The Waterfall Model assumes that distinct phases of development of a whole system exist for analysis, preliminary design, detailed design, coding and unit test, and system test. Documentation produced at the end of each phase provides the basis for work performed in the next phase of development. In the Waterfall Model, characterized by a […]
Here is a simple procedure to register employees of your company only to a system. For example, l have created a site that l want only users with email ending in @kofianalytics.com to be able to register on the site. That means, once the email is validated they will have access to the site. This […]