Securely Manage Database Credentials Using VS Manage User Secrets
In this tip we cover how to manage application secrets in a development environment to securely store database credentials.
Sherlee Dizon works as an I.T. consultant web application developer for SMART Communications in the Philippines. Has 14 years of experience in I.T. as a software and web application developer using MS-Access, MYSQL, MS-SQL 2000, SQL 2005 and SQL 2008 as back-end. For programming languages has used FOXPRO for DOS, Foxpro for Windows, Visual Foxpro, Clipper, Visual Basic 5 and 6, VB .Net 1.0, 2.0, ASP Classic, Visual Studio 2005 C# .net and ASP .net, Visual Studio 2010 C# .net and ASP .net and for reporting Seagate Crystal Report and MS-SQL Server Business Intelligence Development Studio. In 2006, got her MCP title by taking the 070-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. Has been involved in different software application development for accounting systems, payroll systems, inventory systems, accounts receivable systems, ERP Applications, Web-based HR and Payroll systems and a customized CRM application and is now exploring .net socket programming.
SQL Server differences of char, nchar, varchar and nvarchar data types
Learn about some of the differences of char, nchar, varchar and nvarchar when working with SQL Server data.
Searching for database objects using SQL Server Management Studio
In this tip I will show you a quick way to find database objects using SQL Server Management Studio.
LINQ Example to Join Multiple Tables Where Null Match Are Expected
The need to combine results in multiple SQL Server tables for producing a list of records or a summary reports are often a challenge to us as a developer. In this tip I will show you how I resolve a problem I have faced regarding joining tables where a nu
Using SQL Server Concatenation Efficiently
In this article I would like to share some tips on using concatenation efficiently for application development when using SQL Server.
SSRS Image Source Report Options
Companies often need to generate reports and forms from scanned images and various government supplied formats. Proper knowledge of how to incorporate images in a report is a must. I am new to SQL Server 2008 Reporting Services (SSRS) and Business Intelli
.NET Application for SQL Server Data Management
You are assigned the task of creating an application to maintain the data for a new application from a data administration perspective. The application should be able to add new records, but first check to see if the record already exists. If the record a
Using LINQ to join data from multiple SQL Servers
In my project I need to retrieve and join data from two different SQL Server databases on two different SQL Server instances. The data retrieval can only be done via the existing stored procedures that have been created in these databases. In this tip we