Tuesday, June 29, 2010

Ask Your Instructor: SQL Server Permissions

Peter,

I was a student in your May 24-26 class and was hoping that you could assist me with a sequel question.

In the SQL Server there is a section to set up users, groups and permissions. If there is a change in the permissions for a group, is there any way to research when this change took place and who updated the permissions?

Thanks for your consideration.

Tricia
----------------------------------------------------------------------------

Tricia,

Yes, there is a feature called SQL Server audit and I have a link to the MSDN webpage that explains it. The basic concept is to create an audit that can have one or more audit specifications assigned to it, enable the audit and the audit specs and track any type of activity that is available through audit specs.

http://msdn.microsoft.com/en-us/library/cc280663.aspx

This should get you started. We cover this briefly in Module 4 of the 6231 class which I am teaching June 28-July 2. We don’t spend a lot of time on it but you get to see it and try it, as well as learning many other aspects of maintaining SQL Server throughout the week.

Hope to see you there. Please feel free to ask any further questions!

- Peter Trast, SQL Expert; MCITP DBA, MCITP EA, MCT
LinkIn with Peter

Bookmark and Share

Monday, June 21, 2010

Bob's TechEd 2010 Presentations



My TechEd 2010 presentations are shown below!


Bookmark and Share

Cloudy with a chance of outsourcing?



If you are not yet familiar with cloud computing, the basic idea is that instead of buying your own servers and creating your own infrastructure to manage and deliver your data and services, you can hire a third party to do it for you. The provider can then add processing power and storage capacity as your needs change, theoretically reducing the headache of scaling it yourself.

Amazon was an early arrival on the cloud computing scene with the Elastic Compute Cloud service. Google Apps was launched by Google as a way to develop software online and run the apps on the monster hardware at Google.

The idea of not owning and managing IT infrastructure can be very appealing to small and medium sized businesses and can be a great solution in some cases. The main benefit is if the cost of running your business from the cloud is less expensive than doing it yourself. It usually is.

But there are many concerns about security and justifiably so. What business wants to have sensitive data out of their direct control? Which businesses can legally put that sensitive data (like maybe your patient records) out on a cloud service? Many vendors are working on ways to make the customer data more secure in the cloud, but most experts agree that it is best to keep the important data close to home inside a private IT infrastructure and only send the less sensitive data, stuff that is probably already out on a web facing server, to a cloud solution provider.

Even Microsoft has been experiencing some pushback from experts who are not employed by the software giant, as I witnessed recently at the TechEd conference in New Orleans, a venue used by Microsoft to train and promote their products. Many of the speakers at the conference spoke at great lengths about the dangers of cloud computing, security being the first concern and availability being the second. What if the cloud provider needs to bring down the network, reboot a server, change a public IP address, any of which might interrupt your service? Can your business afford to lose internet presence and for how long? How long can your business function without an application or some data? These are some of the concerns expressed by the "non-koolaid drinkers", as one speaker put it.

Personally, I think it is a great idea. Much of our data is not too sensitive to be out there and there are ways to secure data out in the public domain. Which companies truly have data that is too sensitive to allow capture by random internet hackers? Of course some companies have true, legitimate security concerns but I think most have little to fear. And as far as availability, there are many ways to have multiple copies of your data and applications available to avoid being placed at the mercy of one cloud provider by using more than one provider and I expect we will see many solutions proposed and implemented in the coming year.

I do know that Microsoft's SQL Azure, a cloud solution for databases, is very easy to set up and connect to (for a pretty reasonable fee) and that many small companies will jump at the opportunity to have a serious, professional and scalable database solution for a fraction of the cost to do it yourself. The process to set it up was described to me by one Microsoft employee:
"First you export your data to a text file or something like that, send it to us, pay the fee and we send you the connection information." When I asked him to elaborate he said "That's all there is to say..."

It just doesn't get any simpler.

Since the vast majority of businesses are small businesses, I fully expect Microsoft Azure (web services) and SQL Azure (database services) to do a fair bit of business in the next business cycle, and many will choose to cloud compute.

- Peter Trast, SQL Expert; MCITP DBA, MCITP EA, MCT
LinkIn with Peter


Bookmark and Share