Are You Registered Yet? 70 online sessions!
The SSWUG.ORG Virtual Conference is closer than you think! We’ll have more than 70 sessions, more than 20 speakers – topics ranging from marketing yourself to 101-level topics to advanced topics – on SQL Server, Business Intelligence, SharePoint and development. There is SO much information to be presented! I’m excited to bring you an amazing online event – straight to your computer. No travel, re-watch sessions on-demand, get session transcripts, slides and demos. It’s all here – check it out here and get registered today!
Tuning Your Cloud-Based Applications
Jeff’s thoughts on the subject – "I haven’t played with any cloud-based solutions (yet), but in addition to your concerns, I would think tuning would be more challenging when the server environment is totally out of your control. It’s hard enough when the server is in a corporate environment where one set of DBA’s is responsible for the general server responsiveness, another group is responsible for the SAN responsiveness, and yet another group is responsible for the individual database responsiveness (and functionality)."
…and Tim wrote "I can’t see where cloud computing solves much of anything since there are uber powerful enough systems that can be built in house for what will be paid for hosting several databases in a cloud over 3 years or so.
Also, when it comes to database and query/proc tuning etc, OLTP transaction performance, OLAP and reporting performance, table partitioning, I/O performance, etc. where is it stated that these things will be cared for in a cloud? To me it seems like this is a NoSQL solution to outsourced databases with a minimal amount of maintenance.
I’m no expert on cloud computing as you can see but these are my thoughts.
Here is a snag from Pinal Dave
‘In the cloud, data is stored across myriad geographic locations, and processing data from different geographic database leads to delay in receiving data. In case of applications where there is the need of processing huge database using complex queries, traditional relational database is best suited. Cloud has its limitations. As for now, it only supports distributed computing; transactional operations are not currently supported in cloud computing.’ "
What surprising and interesting to me personally is that behind the scenes I’m getting argumentative emails both in favor of and against people’s understanding of the cloud-based services. It’s really odd. Clearly we all have much to learn about what really can be done, what can’t be done and what it means for applications. It’s the first time I’ve had this sort of "off the record" argument going in both directions behind the scenes. Weird.
Featured Article(s)
Tips for using SQL Server 2008 cursors
Here are some helpful tips to ensure you use SQL Server 2008 cursors in the most efficient manner possible.
Featured White Paper(s)
What You Need to Know to Prevent Downtime and Data Loss
A major component of your virtualized SQL Server environment will likely be availability and recoverability. Consolidation a… (read more)