An opportunity to speak with Sabrena McBride, Senior Product Manager for SQL Server, provided a lot of insight into what's new in R2. Some of the highlights: Among other things, SQL Server 2008 R2 is ...

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line of business applications and ...

I'm trying to write a little VBA script that takes a range of data from one Workbook and pastes it in another. I have a form pop up that asks for the column (the rows that need to be copied never ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...