Tips
Access to SQL Server 2008 Virtual Environment
Back in June 2007, we announced that SQL Server 2008 is on its way in this tip SQL Server 2008 has arrived. In addition, we talked about how to learn more about SQL Server 2008 in this tip Learning SQL Server 2008. The problem with learning something new is that it often takes a lot of time to setup an environment before you can actually do anything. With server virtualization this is much easier to setup and take down servers at will, but this still requires effort to get the virtual server setup in the first place. Are there any easier solutions for getting your hands on SQL Server 2008?
Identify database features restricted to a specific edition of SQL Server 2008
One of the Junior SQL Server database administrators (DBA) in my company approached me yesterday with a dilemma. He wanted to know how he can identify whether a database uses any of the features that are restricted to a specific edition of SQL Server 2008. In this tip we will go through the steps a DBA needs to follow to identify a database which uses edition specific features.
Learning SQL Server 2008
I have been hearing all of the buzz about SQL Server 2008 from many of your recent tips (SQL Server 2008 - Features, Function and Value) and your web cast (SQL Server 2008 - First Look). I did not get a good jump on learning SQL Server 2005 and we have been slow to migrate to SQL Server 2005 because of this and a few other reasons. I really want to get on the bandwagon and try to adopt SQL Server 2008 earlier and maybe even upgrade some of our legacy applications directly to SQL Server 2008. Do you have any recommendations on going down that path?
SQL Server 2008 Books Online May Update
SQL Server Professionals are lucky to have what I believe to be the most comprehensive set of product documentation available to them FREE from the vendor through SQL Server Books Online.
SQL Server 2008 consume output directly from the OUTPUT command
SQL Server 2008 Data Compression and Backup Compression
SQL Server 2008 Developer Training Kit
The Microsoft Developer and Platform Evangelism Team has put together a training Kit on SQL Server 2008.
SQL Server 2008 Features, Function and Value
In preparation for the upcoming MSSQLTips.com SQL Server 2008 web cast, I want to start to introduce some of the new SQL Server 2008 technologies at a surface that will start to shape the industry. The features are across just about every major component in the product suite so the benefits should be broad and perceived as beneficial not only from an IT perspective, but also from a user perspective. This should ultimately yield a significant business benefit as SQL Server 2008 is adopted in 2008 and 2009.
SQL Server 2008 First Impressions
At our organization we have had limited exposure to SQL Server 2005 because SQL Server 2000 just works. We have worked with SQL Server 2005 in some particular areas, but we do not have the enterprise experience we need to move forward. We know support will be lifted for SQL Server 2000 and know we need to jump on SQL Server 2005 or 2008 in short order. How can I get some first hand experience and what sorts of things should I try to do?
SQL Server 2008 Group By Sets
SQL Server 2008 has arrived
Too many changes, not enough time. Here we go again, another new version of SQL Server ready to be launched sometime in the near future. Microsoft has officially named the next version of SQL Server as SQL Server 2008, so based on the official name I would assume we will see the RTM release sometime in 2008. This release was previously known as "Katmai", but this week Microsoft has released the first CTP version available for download. As far as the clients that I work with, most are still running SQL Server 2000, so does this potentially mean a double jump like a lot of people took from SQL Server 6.5 to SQL Server 2000?
SQL Server 2008 Inline variable initialization and Compound assignment
SQL Server 2008 List of New Features
SQL Server 2008 MERGE More than UPSERT
SQL Server 2008 Transaction Logging Enhancements
Top 10
SQL Server 2008 Features, Function and Value
In preparation for the upcoming MSSQLTips.com SQL Server 2008 web cast, I want to start to introduce some of the new SQL Server 2008 technologies at a surface that will start to shape the industry. The features are across just about every major component in the product suite so the benefits should be broad and perceived as beneficial not only from an IT perspective, but also from a user perspective. This should ultimately yield a significant business benefit as SQL Server 2008 is adopted in 2008 and 2009.
Identify database features restricted to a specific edition of SQL Server 2008
One of the Junior SQL Server database administrators (DBA) in my company approached me yesterday with a dilemma. He wanted to know how he can identify whether a database uses any of the features that are restricted to a specific edition of SQL Server 2008. In this tip we will go through the steps a DBA needs to follow to identify a database which uses edition specific features.
SQL Server 2008 First Impressions
At our organization we have had limited exposure to SQL Server 2005 because SQL Server 2000 just works. We have worked with SQL Server 2005 in some particular areas, but we do not have the enterprise experience we need to move forward. We know support will be lifted for SQL Server 2000 and know we need to jump on SQL Server 2005 or 2008 in short order. How can I get some first hand experience and what sorts of things should I try to do?
Learning SQL Server 2008
I have been hearing all of the buzz about SQL Server 2008 from many of your recent tips (SQL Server 2008 - Features, Function and Value) and your web cast (SQL Server 2008 - First Look). I did not get a good jump on learning SQL Server 2005 and we have been slow to migrate to SQL Server 2005 because of this and a few other reasons. I really want to get on the bandwagon and try to adopt SQL Server 2008 earlier and maybe even upgrade some of our legacy applications directly to SQL Server 2008. Do you have any recommendations on going down that path?
Access to SQL Server 2008 Virtual Environment
Back in June 2007, we announced that SQL Server 2008 is on its way in this tip SQL Server 2008 has arrived. In addition, we talked about how to learn more about SQL Server 2008 in this tip Learning SQL Server 2008. The problem with learning something new is that it often takes a lot of time to setup an environment before you can actually do anything. With server virtualization this is much easier to setup and take down servers at will, but this still requires effort to get the virtual server setup in the first place. Are there any easier solutions for getting your hands on SQL Server 2008?
SQL Server 2008 has arrived
Too many changes, not enough time. Here we go again, another new version of SQL Server ready to be launched sometime in the near future. Microsoft has officially named the next version of SQL Server as SQL Server 2008, so based on the official name I would assume we will see the RTM release sometime in 2008. This release was previously known as "Katmai", but this week Microsoft has released the first CTP version available for download. As far as the clients that I work with, most are still running SQL Server 2000, so does this potentially mean a double jump like a lot of people took from SQL Server 6.5 to SQL Server 2000?
SQL Server 2008 Books Online May Update
SQL Server Professionals are lucky to have what I believe to be the most comprehensive set of product documentation available to them FREE from the vendor through SQL Server Books Online.
SQL Server 2008 Developer Training Kit
The Microsoft Developer and Platform Evangelism Team has put together a training Kit on SQL Server 2008.
