Vincent Rainardi

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

SQLServerCentral Article

Date and Time in SQL Server 2008

SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.

4.13 (32)

2007-10-24

12,516 reads

SQLServerCentral Article

From DBA to DWA

Everyone wants to know what a DBA does and it is becoming a hard question to answer as the responsibilities and capabilities of database platforms increase. Longtime author Vincent Rainardi brings us the proposition of a new type fo DBA, one that focuses more on data warehousing.

4 (3)

2007-09-17

8,286 reads

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)

2006-10-24

14,826 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)

2006-08-16

11,526 reads

Blogs

What do we want to achieve by encrypting our data?

By

On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022

By

Today’s coping tip is to look for new reasons to be hopeful, even in...

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Read the latest Blogs

Forums

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

10 years as Sql server dba but still fears of Interview and lack of Confidence

By anoop.mig29

I dont know whether i may asking question at right or worng place but...

T-SQL Code Review - Where Field DOES NOT contain

By carlton 84646

Hello community, Quick question to get your opinion on simply T-SQL code. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers