SQL Server Security – Only about a day left to register!
Our SQL Server Security virtual workshop is happening Friday – so you only have a day or so to get registered and save your spot! I’ll be teaching the workshop and we’ll be covering the different aspects of SQL Server security, including injection and what you need to be doing about it, how it works, how you prevent it, security best practices, a bunch of free tools and a LOT more.
Be sure to register here, and I’ll see you Friday for the workshop, look for me in the live Q&A chat room that runs the entire time during the workshop, so you can get answers and updates along the way.
Featured Article(s)
Troubleshooting SQL Server 2008 Integration Services
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 Integration Services. He also tells how you can resolve these problems.
TODAY – Webcast:
Avoid Slow SSAS Queries: MDX Query Troubleshooting
Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often challenging because the level of support provided by the tools and the Analysis Services engine is not as mature as that found in the relational engine. This session covers the methods for examining slow queries using the SQL Profiler and Performance Monitor to determine the need for aggregations, caching problems, memory constraints, and so forth. Best practices for optimizing MDX will be examined, and various server properties will be discussed as necessary to help correct query issues. Attendees will leave armed with a practical approach to locating bottlenecks and strategies for speeding up queries.
> Register Now
> Live date: 4/28/2010 at 12:00 Pacific
Does SharePoint Change Your Approach?
I’ve been talking with several SharePoint Admins and we’ve been trying to work out a bit of best practices, tips and such for SharePoint from an admin perspective.
I thought I’d toss out a question to everyone – if you’re working with SharePoint, do you find that your duties and expectations are changed because of SharePoint? Are there things you do (or don’t do) that are specifically because of SharePoint?
I know there are differences for performance-related reasons that include database sizes, splitting up databases as they grow past certain milestones and so-on. What have you found to be best practices? What changes from a database perspective in how you work with your databases when they’re specifically related to SharePoint? So many questions and thoughts here – but if you could share your experiences, suggestions, ideas and approaches, we’ll get it out to the community and see if we can find some common targets.