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.
2007-10-24
12,716 reads
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.
2007-09-17
8,431 reads
Part 3 of Vincent Rainardi's data warehousing series looks at some of the situations and challenges of loading a fact table in a data warehouse.
2007-01-02
44,481 reads
We get Vincent Rainardi's "Data Warehouse Loading Part 2" article taking a look at how you can perform an "upsert" in your data warehouse.
2006-11-28
14,398 reads
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.
2006-10-24
15,029 reads
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.
2006-08-16
11,589 reads
Continuing with his fantastic series on data warehousing. Vincent Rainardi brings us the next installment, which takes a look at upgrading the various components of your data warehousing system.
2006-07-31
16,226 reads
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.
2006-05-23
14,108 reads
The fourth part of a great data warehousing series from Vincent Rainardi. This article continues the look are still other methods of extracting data from the source system along with the advantages and disadvantages of each.
2006-05-02
14,434 reads
The third part of a great data warehousing series from Vincent Rainardi looks different methods of extracting data from the source system along with the advantages and disadvantages of each.
2006-04-25
16,935 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers