Featured Article(s)
Mastering Microsoft Business Intelligence: Introducing Named Sets in Analysis Services, Pt. 3
Part 3: Get hands-on exposure to Named Sets within Analysis Services. Join BI Architect Bill Pearson as he introduces the Mastering Microsoft Business Intelligence series, another new SSWUG exclusive.
Webcast: How to Hire a DBA Part 3 of 3
Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part three of this series we will talk about the interview. We will finish up with making a decision on who to hire. Presented by: Chris Shaw
> Register Now
> 7/29/2009 at 12:00pm Noon Pacific
Where is SQL Server Going?
We had a great time at the vConference this last week, and it’s pretty interesting to see where some of the questions and comments since have gone. It seems clear that integration with reporting services, the failover technologies and BI are a HUGE direction of choice. This maps well to the work being done with SQL Server 2008 R2. There are very big things being done for better tools for end-users and such and I think it’ll pay big dividends as the release comes out and is made available.
It’s kind of a weird shift, especially from a DBA perspective. I think it changes our responsibilities a bit, and I think it means stepping up security as well. First, it changes our responsibilities because we’re going to be working to provide access to much less structured environments. From Excel to query tools to BI applications, the demands for information certainly won’t be decreasing, let alone going away. For so long "DBA" has been about administration and protecting data. I think you’ll see the demands of the position begin to shift. I think we’re headed to a "protective facilitator" role where we’re needing to make sure people can get to what they need, but can’t do damage to things they shouldn’t be harming.
This leads to the second item.
The second role is really a polishing of our collective understanding and application of user rights, permissions and how those impact how users can get to information. If part 1 above is a given, that means more access, not less. This means that the access that is provided will need comprehensive access and usage controls, auditing, validation and more. I think the database will be becoming the central collection place for access management and I think we’ll really be much better off understanding how to apply security, create views and more, all in support of people getting more and better use of information in our systems.
Are you seeing this yet? Are you users using less-structured tools to access SQL Server data? If so, how have you approached the security of that data? I’ve heard from a few people now that access has been officially trumping security, while unofficially, the DBA is working madly to provide management-edicted access while at the same time providing compliant and best-practice-oriented control.
What are you seeing? Drop me an email here. I’d really like to hear how you’re working with this, even if you’re not seeing changes yet.
Webcast: DTS Conversion to SSIS – Conversion Best Practices
Join this webcast and Learn how and why to convert DTS to SSIS. See how you can save time and money and easily migrate your DTS packages to SSIS * Introduction to SSIS and its differences vs. DTS * Advantages of SSIS over DTS * Options for converting DTS packages to native SSIS * Adding value to packages during the conversion process * Assessing the scope of a DTS conversion project Presented by: Brian Knight (www.pragmaticworks.com)
> Register Now
> 8/5/2009 at 12:00pm Noon Pacific
Featured White Paper(s)
Building High-Performance Database Systems with EMC Storage Technology and Microsoft SQL Server 2005
In this white paper, you’ll read about Microsoft SQL Server 2005 Enterprise Edition, which incorporates powerful data managem… (read more)