The SQL Server MCM...do I need one?

SQL Server allows you to reassign the ports used by default instance or named instances. Using SQL Server Configuration Manager, you can reassign the TCP port. Your SQL Server environment is more secure when you change the default ports to a difference number.

Sometimes you need to update data in a table and then update data in another table but based on a filter condition found from the first table. Use the OUTPUT clause to obtain data from the UPDATEd row(s) in order to use them further. Also this is a "thread-safe" way to obtain data.

Why Object Relational Mappers are the New Standard Practice for Application Development

Permitting concurrent transactions in database management systems is essential for performance but introduces the possibility of reading inconsistent data. To balance concurrency problems and performance, SQL Server has four transaction isolation levels.

Authentication mechanism to login to SQL Server database engine is either Windows authentication or SQL Server account. Sometimes you will face authentication issues with database portability, example when you migrate a database from one SQL Server instance to another SQL Server instance, DBA has to...

Power View is a new feature available in SQL Server 2012 reporting services, It is a browser based application which requires Reporting Services to run in SharePoint Integration mode. The datasource for Power View application is either a analysis services CUBE or Power Pivot work book that needs to ...

Integration Services Catalog is a new feature in SQL Server 2012 which supports the centralization of storage of packages and configuration files. You can host only one catalog for one SQL Server Instance. When you deploy your project using project deployment model all project components stored in c...

The Visual Studio Environment introduces some user-interface changes from previous version of Business Intelligence Development Studio(BIDS). The new interface contains the enhanced appearance of tasks and dataflow components with rounded edges and icons.

Learn several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios.

A scenario familiar to many web developers is the requirement to provide a location search to your client's users. The user enters their address and/or zip code, and is shown the 5 closest locations that they can visit. Add information from your Inventory system, and you can tell the user which loca...

This post discuss about security of SQL Server data and steps required to configure SSL Encryption in SQL Server. There is a feature named Transparent Data Encryption in SQL server 2008 which provides security for static data, what about the data that flows over the network. SSL Encryption can answ...

Avoiding temporary tables and cursors for queries can lead to scripts that are easier to understand and maintain, and that provide better performance than the cursor-based alternative. One option for complex queries is the use of common table expressions.

Some result sets are difficult to extract from a database without performing multiple queries or using temporary tables and cursors, which can harm performance. Derived tables help with some problems by creating virtual tables within the scope of a query.