Feed on
Posts
Comments

Archive for the ‘Data Warehousing’ Category

SQL SERVER - Guidelines and Coding Standards complete List Download
Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where [...]

Read Full Post »

SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
What is Data Compression?
In SQL SERVE 2008 Data Compression comes in two flavors:

Row Compression
Page Compression

Row Compression
Row compression changes the format of physical storage of data. It minimize the metadata (column information, length, offsets etc) associated with each record. Numeric data types and [...]

Read Full Post »

SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
1) General Questions of SQL SERVER
What is Cursor?
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time.
In [...]

Read Full Post »

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible report layout, data visualizations and richly formatted text. The download includes the following functionality above the RC0 release of Report Builder:

Easy to use wizards for creating table, matrix and chart data regions.
Support for directly [...]

Read Full Post »

What is difference between DBMS and RDBMS?
DBMS - Data Base Management System
RDBMS - Relational Data Base Management System or Relational DBMS
A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to [...]

Read Full Post »

Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks
The Windows Live Security team shares best practices - from platform and network security to incident management - in providing security for web applications and infrastructure.
Organizations across the globe face unique challenges in enhancing security for Web applications and their IT infrastructures. Issues [...]

Read Full Post »

I am very pleased to write my 500th post. After 500 posts, I still have same feeling when I wrote first post on this blog. I would like to thank my family for their continuous support in writing this blog. Most of all I want to thank all of YOU for being wonderful readers of [...]

Read Full Post »

Questions I often get asked :

How big is market for SQL Server?
Is SQL Server industry leader?
Does learning SQL Server technology will help future career?
Why did you pick SQL Server as your expertise?

I just love SQL Server.
Let us read following article taken directly from Microsoft, which explains why SQL Server is Data Platform Leader.
Microsoft is positioned [...]

Read Full Post »

Yesterday on this blog I wrote about SQL SERVER - 2005 - Understanding Licensing Model. I have received many questions about pricing and comparing SQL Server with other RDBMS. One of the reason I like SQL Server because I am strong believer of licensed software usage and SQL Server is feature rich and dirt cheap [...]

Read Full Post »

SQL Server 2008 Brochure is available to download. It contains many information like available Server Editions, Top New Features, New Available Technologies and additional resources.

Click on above image to open large image.
Top New Features

Use Resource Governor to manage concurrent workloads
Enforce policy compliance consistently across the enterprise with the Policy-Based Management
Reduce storage requirements and increase query [...]

Read Full Post »

Top 10 Best Practices for SQL Server Maintenance for SAP
By Takayuki Hoshino
SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an outline of best practices for maintaining SQL Server database for an SAP implementation.
1) Perform a full database backup daily
2) Perform transaction log backup Every 10 to 30 minutes
3) Back [...]

Read Full Post »

Just a day ago, while I was surfing wikipedia about SQL Server, I came across this generic architecture image. I found it interesting. Click on image to view it in large size.

Reference : Pinal Dave (http://www.SQLAuthority.com), Wikipedia - SQL Server

Read Full Post »

If you are subscribed to my blog you will know that I receive request to send Database or SQL Server very frequently. Following is list of articles of my questions and answers series.
Download SQL Server Interview Questions and Answers Complete List
Complete Series of SQL Server Interview Questions and Answers
SQL Server Interview Questions and Answers [...]

Read Full Post »

I always ask question about Third Normal Form in interviews I take.
Q. What is Third Normal Form and what is its advantage?
A. Third Normal Form (3NF) is most preferable normal form in RDBMS. Normalization is the process of designing a data model to efficiently store data in a database. The rules of 3NF are mentioned [...]

Read Full Post »

If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India. Please send me your resume, if selected you may get chance to work with one of the most progressing industry in world as well some [...]

Read Full Post »

SQL SERVER - Cursor to Kill All Process in Database
SQL SERVER - Find Stored Procedure Related to Table in Database - Search in All Stored procedure
SQL SERVER - Shrinking Truncate Log File - Log Full
SQL SERVER - Simple Example of Cursor
SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper [...]

Read Full Post »

Best Downloads on SQLAuthority.com
SQL SERVER - Query Analyzer Shortcuts
SQL Server Interview Questions and Answers Complete List Download
SQL SERVER - Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts)
SQL SERVER Database Coding Standards and Guidelines Complete List Download
SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download

Read Full Post »

Business Intelligence
Business intelligence is a method of storing and presenting key enterprise data so that anyone in your company can quickly and easily ask questions of accurate and timely data. Effective BI allows end users to use data to understand why your business go the particular results that it did, to decide on courses of [...]

Read Full Post »

White paper describes the use of virtual copy Storage Area Network (SAN) snapshots in a load-balanced scalable querying environment for SQL Server 2005 Analysis Services.
This architecture provides the following improvements

Improves the utilization of disk resources
Optimizes cube processing operations
Supports dedicated snapshots for specific users at different points in time

In selecting a snapshot implementation for use with [...]

Read Full Post »

I just came across PDF published by Microsoft to promote SQL Server 2005. I find few things very interesting. I will list them here.
NASDAQ

NASDAQ, the world’s first electronic stock market replaced its aging mainframe computers with Microsoft® SQL Server™ 2005 on two 4-node clusters to support its Market Data Dissemination System (MDDS).
Every trade processed in [...]

Read Full Post »

Older Posts »