Vincent Rainardi

  • Interests: data warehousing and BI, family, chess, bilyard

SQLServerCentral Article

Data Warehouse Loading

Data warehousing is becoming more and more popular, especially as companies seek to leverage the information stored in various systems to improve their business processes. Warehousing expert Vincent Rainardi brings us the next installment of his series on data warehousing, examining the issues of loading data.

5 (3)

You rated this post out of 5. Change rating


14,976 reads

SQLServerCentral Article

Considerations for Data Warehousing

What type of things do you need to look at when setting up a data warehouse? Hardware is a big one as well as the settings for the server, which may be substantially different than transactional systems most DBAs work with. Warehousing expert Vincent Rainardi brings us the next installment in his data warehousing series with some advice on what you should be looking for.

4.67 (3)

You rated this post out of 5. Change rating


11,575 reads

SQLServerCentral Article

Business Intelligence or Data Warehouse

Is a data warehouse required for business intelligence? Are these synonyms for the same concept? Vincent Rainardi brings us the next part of his data warehousing series that examines these two concepts and how they fit into your data analysis infratructure.

4.83 (6)

You rated this post out of 5. Change rating


14,090 reads

SQLServerCentral Article

Using ODS As A Middle Layer

Data warehousing is a foreign concept to many DBAs since it is not used very widely in SQL Server. However it can be a very useful tool for your business and new author Vincent Rainardi brings us the first in a series of warehousing articles, this one looking at an operational data store.

5 (3)

You rated this post out of 5. Change rating


11,138 reads


Azure SQL MI License free?


A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator


A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books


I try to keep an eye on the Humble Bundle bundles for books. The...

Read the latest Blogs


username upper case lower case how to fix

By sqlguy80

there is a field userid, firstname and last name which is allowing such userids...

File backup to dedicated nic

By tapiojaa

I've SQL Server 2019 Always On cluster (latest CU) that has 4 network adapters....

DBCC CheckDB errors

By mtz676

How can I identify automatically(like email alert if error shows up) through code if...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers