Featured Article(s)
Troubleshooting SQL Server 2005 service pack 2 problems (Part 2)
In this article, you can find the description of SQL Server 2005 service pack 2 bugs and the information on how to resolve or work around these problems.
SQL Server Database Snapshots: Are They Right for Me?
In this webcast, sponsored by Quest Software, SQL Server expert Tom LaRock will discuss SQL Server database snapshots and how you can implement them in your environment. He will outline the advantages and limitations of using these snapshots and investigate common use cases where they can successfully be deployed. Tom is a DBA manager with ING Investments and a member of Quests Association of SQL Server Experts.
> Register Now
> Live date: 9/9/2008
SQL Server Show Available
SelectViews: SQL Server 2008 Upgrade Experiences, Departmental Databases, What is Growing Your Database? Uptime and Downtime Planning, Upcoming Events, xp_cmdshell Tips and a Lot More.
[Watch Show]
Using Excel with SQL Server?
Have you played with, or outright worked with Microsoft Excel and SQL Server? We’ve been building some dashboards and other utilities that directly integrate the two – and it’s working quite well. Excel talks directly to SQL Server, and does so especially well in Excel 2007. We’ve had some really solid success building workbooks that contain several sheets and lots of information at both a summary and more detailed level.
I’m wondering what types of things people are successfully (or even unsuccessfully) doing in integrating SQL Server and Office for reporting, dashboards, etc.
Have you built out solutions using the products – not reports necessarily, but moving beyond that into manipulatable information and analysis? Where do you feel the applications are really well suited to work together? Where would you like to see changes? Do you have suggestions for others?
One thing I’d like to see is an information "expiration" option – allowing you to indicate how long the data in the sheet will be shown before an information refresh is requested. This way you can know (or at least *think*) that the information is pretty fresh and accurate as you’re using the workbook, for example.
So, what applications, ideas, thoughts and experiences do you have? Drop me a note, let me know…
Featured White Paper(s)
Addressing the Insider Threat
This paper discusses the current state of database security, and the importance of activity monitoring and vulnerability asse… (read more)
Best Practices for Monitoring Privileged Database Users
Whether its financial information, healthcare data, Personally Identifiable Information (PII), intellectual property or other… (read more)