Azure Storage and Data Services
We have introduced Azure Storage Services. There are other services about storage and data on Azure.
Microsoft is Too Smart to Name Their Products
Microsoft made lots of software, and even hardware devices. Also, Microsoft named lots of products which they released. If you are a developer, or if you used Microsoft products, you also know Microsoft keeps changing many product names and canceling many products, especially they cancelled when you just spent time to learn them. but what ever, you know a truth, Microsoft like to give names to their products, and, they always thought the names were great.
How to Stop a SQL Server Instance
In some cases you might have to stop a SQL Server instance. For example: you want to install SQL Server 2012, but you have a previous version like SQL Server 2008 installed. and, both of two versions are set the default TCP/IP port number, which is 1433 for SQL Server. so in this case you will have to stop the old SQL Server and install new one.
Delete multiple tables in SQL Server by table names
If data tables have similar table names, such as data log tables named by dates, you might want to delete multiple tables, for example, you wanted to delete all tables in a month, or in a year.
Check SQL Server Database Size
There are 2 ways to check SQL Server database size:
Upgrade to Windows Server 2012 R2 from Windows Server 2008 R2
We have a running Windows Server 2008 R2 system, for our development, it has not been used as a stable server, but just for development, so we often change this system due to our different development requests such as testing. Now we receive Windows Server 2012 from Microsoft, which is more closing the cloud service and platform for our company, so we want to upgrade the Windows Server 2008 R2 to 2012 R2, for any new software and existing software in our company.
Install Microsoft SQL Server Compact 4.0
Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix, and seamless migration of schema and data to SQL Server. – From Microsoft
ADO.NET connected mode vs disconnected mode
ADO.NET can work on either connected mode or disconnected mode.
DataSet vs DataReader
DataSet is an in-memory representation of a database, providing a consistent relational programming model no matter what format of data source. It contains multiple data tables and their relationship and constraints information.
If your site is based on WordPress, the one of maintain tasks is updating WordPress since their new versions released time to time.
Stored Procedures Permissions Management
Simply writing stored procedures isn't enough to adequately secure your application. You should also consider the following potential security holes.
Can not add a Non-Nullable field in your data table?
Maybe you got error when you try to update your database SQL Server such as add a Non-Nullable field.
Build Generic Data Access Layer in ADO.NET for multiple database types
Want to build a DB Access layer for multiple database types ?