Archive for May, 2011
Using Memory Beyond 4GB in SQL Server
|
Physical Address Extension (PAE) allows you to use up to 64 GB of physical memory depending on operating system you use. All existing 32 bit processors supports this extension of memory. PAE mode requires an Intel Architecture processor and more than 4GB of RAM. |
 |
You can configure at two levels to use Memory Beyond 4GB in a 32 bit windows server operating system.
- Operating System Level
- Application Level
To enable operating system to access more than 4GB of physical memory , add a /PAE switch in boot.ini file as below
Related Posts:
No commentsAnalyzing SQL Server Performance using Performance Monitor Counters
|
This post discusses about using Performance Monitor tool to create a base-line using different performance counters. It also discusses analyzing hardware resource bottlenecks and retrieving performance monitor data in sql server using views. Performance Monitor Tool collects the detailed information of system resources including memory, processor , disk and network.SQL Server 2008 provides extensions to Performance Tool to analyze various areas in SQL Server. |
 |
Performance Monitor tool provides performance counters to represent the specific aspects of a resource.
What is Performance Counter?
Related Posts:
No commentsWhat is new in SQL Server Code-Named “Denali”?
|
This post just re-caps the T-SQL features that introduced in SQL Server 2008 and discusses the new T-SQL features in Microsoft SQL Server next version code name “Denali”. Actually there are not any T-SQL features in SQL Server 2008 R2 as it is purely a BI release. You can download the Denali CTP version from here |
 |
Related Posts:
2 commentsCreating SQL Server Database Objects Backup using SMO
|
This post explains taking the SQL Server Database Objects backup only schema not data in SQL Server 2008 R2. In an ETL server you may come across the situation where you need to change the database objects schema quite frequently especially when data source changes. In this case we may need maintain our schema or take the backup our database objects script some place where we can restore them back to the server. |
|
What is SMO?
This can be achieved in earlier versions of SQL Server using Distributed Management Objects (DMO) but now it is no longer supported in SQL Server 2008 R2 and future versions. We can achieve the same using SQL Server Management Objects (SMO) in 2008 R2. SMO provides objects which are used to manage SQL Server.
Related Posts:
1 commentCreating a Sample Visual Studio LightSwitch Beta2 Application
| Microsoft Visual Studio LightSwitch allows the developers to create a high-quality line of business applications with less writing of code. LightSwitch provides the screen templates for common business tasks such as data entry, search , formatting and displaying the data. LightSwitch includes built-in functionality to validate the input with little or no code. We can also write the code either in C# or VB.NET to extend the business logic. |  |
Related Posts:
5 commentsWCF AJAX Service Without Configuration
| This post discusses how to develop Windows Communication Foundation (WCF) service using AJAX and without any configuration settings for WCF. This service can be consumed from Javascript. The service uses a special setting in .svc file which automatically enables an AJAX endpoint. |  |
Related Posts:
No commentsWCF Service using MTOM in .NET FW 4
Web services having a greater interoperability to communicate messages across heterogeneous systems, however challenge is serializing the data into XML. Users may want to send images,videos, drawings, xml documents etc. together with SOAP message.
What is MTOM?
Message Transmission Optimization Mechanism (MTOM) is a mechanism of transferring transferring large amounts binary data as an attachment to SOAP message.
Typical SOAP message transmission shown in the below image
Image Source crosscheknet.com
Related Posts:
1 commentMicrosoft Windows Server APPFABRIC
|
Windows Server APPFABRIC is an extension to Application Server role in windows server. It provides a better application infrastructure for developers which enables them to create faster, scalable and more manageable applications. This release of APPFABRIC has consist of two parts
|
 |
APPFABRIC CACHING SERVICES
It speeds up the frequently accessed data like Session data used by ASP.NET application.
Related Posts:
No comments
