5.1 SSIS SSAS SSRS
What is SSIS? SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The…
9. Entity Framework, Linq, Lambda Expressions
What is Entity Framework? Entity Framework is Microsoft’s latest and recommended way for data access for new applications. EF 4.1 enhances the offering by adding support for Code First model…
Remove spaces from a string C# VB.Net
Replace all white space in a string A string is a sequential collection of Unicode characters that is used to represent text. String objects are immutable that is they cannot…
MVC, IIS, CSS, Notes
MVC (section 1) TempData Usage TempData : https://stackoverflow.com/questions/21454232/asp-net-mvc-how-to-pass-full-model-from-view-to-controller Using the code below you can send data back and forth from controller to view and view to controller. TempData["savedControl"] = "Successful";…
1. C# & OOP
C# Questions https://www.toptal.com/dot-net/interview-questions What is Object oriented Programming? It is a programming methodology in which the programs are organized as collections of objects. Each object represents an instance of some…
11 Keyboard Shortcuts Every SQL Server Geek Should Know
. Open a new Query Window with current connection (Ctrl + N) This shortcut opens up a new query window with an existing connection. It will query to the same database…
Strange Things That Happen in Visual Studio -General Build issues
Project wont build 1. Projects have a filename that ends in .proj. When you go to them in Visual Studio they can be managed from the properties panel. but there…
SQL Server 2008 R2 Stuck in Single User Mode
Problem/Description: Cannot get the Database to go back into mulit user mode. Answer: For Checking the proccess IDs so you can kill them later exec sp_who SELECT request_session_id FROM sys.dm_tran_locks…
How to turn on line numbers – ALL APPS
Directions for the Following list of APPs: (Find App then Skip further below to see full Instructions) Visual Studio - Notepad - SQL Management Studio - Instructions Below VBA - …
SQL – Setting the Value of Variables inside server scripts.
Using SELECT: SELECT @ModelID = m.modelid FROM MODELS m WHERE m.areaid = 'South Coast' Using SET: SET @ModelID = (SELECT m.modelid FROM MODELS m WHERE m.areaid = 'South Coast') See…
Transactions in MVC C#
EF6 Onwards Only - The features, APIs, etc. discussed in this page were introduced in Entity Framework 6. If you are using an earlier version, some or all of the information…
Build RESTful APIs with ASP.NET Web API
In recent years, it has become clear that HTTP is not just for serving up HTML pages. It is also a powerful platform for building Web APIs, using a…