Posted by
Jason Massie 
on Tuesday, August 19, 2008 at 10:54 AM to
SQL Server 2008
108 Views |
0 Comments |
Edge provides a front row seat in the SQL Server 2008 ship room.
Inside the SQL 2008 Ship room
Posted by
Jason Massie on Friday, August 15, 2008 at 4:20 PM to
SQL Server 2008, SQL Server 2005, SQL performance tuning, Rumor mill, Rumor mill
128 Views |
1 Comments |
The podcast from Brian Moran and Bill Bosworth provides good insight into the the deal. Click here.
Here is an excerpt for the forthcoming press release:
Quest Software is announcing its new partnership with Solid Quality Mentors, a global provider of education and solutions for Microsoft data and development platforms.
This is not a sales reseller relationship, but a true joining of forces to provide new real value to the SQL Server community. Specifically, our plans are to work together in three specific areas: community outreach, product development and professional services.
Community outreach: The companies will work together on joint programs including speaking at Quest and Solid Quality Mentors events, authoring technical briefs and white papers and providing joint webcasts and podcasts for the SQL Server community.
Product development: Quest will collaborate with Solid Quality Mentors on product road maps and feature sets, drawing on their combined experience of real-world SQL Server challenges to provide the best solutions possible for SQL Server DBAs and developers.
Professional services: Quest customers will benefit from consulting services offered by Solid Quality Mentors to help implement tools and manage complex environments.
Peep http://quest.com Monday for more details.
Posted by
Jason Massie on Wednesday, August 13, 2008 at 5:02 PM to
SQL Server 2008
145 Views |
2 Comments |
Note: Let me start off by stating my definition of physical database design might be broader than the classical definition.
A look into the past
The landscape changes a little with each release. In SQL Server 2005, partitioning, partial database availability and mirroring really stand out as things to consider when planning the physical design. Less databases are better for mirroring. You must think in filegroups when partitioning and when implementing partial database availability.
Learn and plan today
What about SQL Server 2008? Well, at first look, nothing really changes from the physical database design concepts except filestream and filtered indexes. Check out what's new in SQL Server 2008.
However when you pull out the feature palette and start painting, it is deeper. What if you want to encrypt and compress data\backups? They don't work well together. You could put the sensitive data in a separate database and use transparent data encryption(column level encryption could be argued for as well.) The idea being the sensitive data is a small percentage of the total data. With filestream, considerations go further than just the location of the files. It would probably make sense to separate file stream data in its own database as well. Filestream doesn't play well with others just yet. Some issues are mentioned here. Mirroring, TDE, snapshot isolation and other are not supported on a database with filestream enabled. How about partitioning and compression? You could compress the partitions that are less often queried and less likely to be in cache while leaving the hottest data uncompressed. Sprinkle on compressed ,covering, partitioned but aligned, filtered indexes with a cherry on top just for fun!
Design for the future
At any rate, I don't have any production SQL Server 2008 servers yet much less any databases designed from the ground up for SQL Server 2008+. We should still plan for new features even if we are still designing SQL 2000\2005. Some of these are hard to change later. Imagine squashing several databases together that have been in production for several years. How about moving all of the objects out of the primary filegroup to implement partial database availability on a database that needs to be ..err... available.
Any other angles I am missing?
Posted by
Jason Massie on Sunday, August 10, 2008 at 9:44 PM to
SQL Server 2008, Certifications
122 Views |
0 Comments |
It is an open beta. Get the registration codes here: http://blogs.technet.com/betaexams/default.aspx I took the first two and reviewed the admin test here. I am still anxiously awaiting the results. I will take 71-452 this week and post a review later.