Database Archives - Page 13 of 55 - SQL Authority with Pinal Dave

SQL SERVER – Guest Post – Architecting Data Warehouse – Niraj Bhatt

March 14, 2011

Best Practices, Business Intelligence, Data Warehousing, Database

Niraj Bhatt works as an Enterprise Architect for a Fortune 500 company and has an innate passion for building / studying software systems. He is a top rated speaker at various technical forums including Tech·Ed, MCT Summit, Developer Summit, and Virtual Tech Days, among others. Having run a successful startup…

SQL SERVER – What is a Technology Evangelist?

January 27, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, MVP

When you hear that someone is an “evangelist” the first thing that might pop into your mind is the Christian church. In fact, the term did come from Christianity, and basically means someone who spreads the news about their faith. In the technology world, the same definition is true. Technology…

SQL SERVER – Automated Type Conversion using Expressor Studio

November 30, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Scripts, SSIS

Recently I had an interesting situation during my consultation project. Let me share to you how I solved the problem using Expressor Studio. Consider a situation in which you need to read a field, such as customer_identifier, from a text file and pass that field into a database table. In…

SQL SERVER – DBA or DBD? – Database Administrator or Database Developer

November 29, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA

Earlier this month, I had poll on this blog where I asked question – Are you a Database Administrator or Database Developer? The word DBA (Database Administrator) is very common but DBD (Database Developer) is not common at all. This made me think – what is the ratio of the…

SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage

October 27, 2010

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Scripts, SQL TempDB

Recently, there have been a lot of interesting concepts in various challenges. My friend Jacob Sebastian is running the SQLQuiz for the entire month, and it has been very popular and going just great. So here I thought I would put something very similar to the quiz bee. The award…

SQL SERVER – A Brief Introduction to DW 2.0

October 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Warehousing, Database

The traditional form of storing digital data has been disk storage. However, the huge advances in technology means that there has been a huge need for data storage to evolve to keep up with the fast-changing times. Microsoft SQL Server has gone through a huge overhaul in order to keep…

SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology

October 13, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Database, SQLAuthority Author Visit

Everyone always dream of visiting their school and college, where they have had studied once. It is a great feeling to see the college once again – where you have spent the wonderful golden years of your time. College time is filled with studies, education, emotions and several plans to…