Featured Article(s)
View all assigned access rights for a specific user
Is a script which generates the access rights for all databases roles, any server level roles and any securable.
Office and SQL Server
Before we get to a couple more comments, a question. I’d be interested (think it would be fun, actually) in putting together a series of videos on using Office with SQL Server. Is this something that would be of interest? I’ve received SO much email about this – but most of it is that people haven’t yet done it because they weren’t sure how to go about it. Would this be something that would be helpful? Email me – let me know – and if you have a minute, please let me know if there are specific applications in Office that are more interesting than others. We’ll start there. 🙂
Chris: "I’m about to embark on a project that needs to produce many different Excel spreadsheets from data stored in SQL Server. Many of these spreadsheets need to present the dta in the form of a chart, but also provide the underlying data in the form of a table.
I was planning on using SSRS for this (exporting the results to individual XLS files), but I’m not sure this is the best way to go. For one thing, the charting features in SSRS aren’t as comprehensive as are Excel’s. For another thing, although SSRS can produce both a chart and a corresponding table on the same ‘report’, the two objects in the exported XLS document are not related to one another–so changes to the data in the table are not reflected in the chart. SSRS 2008 doesn’t even provide this feature.
So I’ve been wondering whether this would be a task better suited from within Excel. What do you think? Can you direct me to any references that you have found useful in building your dashboards and other utilities?"
George: "I’ve made reports for ASP.NET application, which has SQL Server as database, using Excel application. I use VBA for the link and refreshing. From my experience, VBA is much faster at refreshing Excel cells than .NET code. I wonder if other database developer has the same experience."
Great Job Opportunities
Post your open positions or review 100’s of other job postings here.
Featured White Paper(s)
Deploying Microsoft SQL Server in an iSCSI SAN
This Technical Report describes how to deploy SQL Server in an iSCSI SAN with PS Series storage arrays. It provides configur… (read more)
SQL Server Data Recovery Made Easy with Idera SQLsafe
When a database goes down due to hardware or software failure, data corruption, or any number of other causes, every minute … (read more)