New Features in SQL Server 2008 Management Studio – Part 1
This article shows the new features that are available in SQL Server 2008 Management Studio
2009-02-17
5,046 reads
SQL Server 2008
SQL Server 2008 Installation Process
I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
2009-02-16
3,753 reads
New data profiling tools in SQL Server 2008
New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.
2009-02-06
3,213 reads
Where is the Surface Area Configuration tool in SQL Server 2008
I just installed a new instance of SQL Server 2008 and I can't find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Database Engine features in SQL Server 2008?
2009-02-05
4,065 reads
2009-01-30
3,750 reads
Restore a SQL Server 2008 Database into SQL Server 2005
You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.
2009-01-26
4,000 reads
SQL Server 2008 T-SQL Enhancements Part - I
SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.
2010-03-05 (first published: 2009-01-22)
40,714 reads
Advanced new features in SSMS 2008
SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.
2009-01-19
3,390 reads
2009-01-09
3,289 reads
SQL Server 2008 and Data Compression
One of the more exciting new features in SQL Server 2008 is data compression and Nicholas Cain talks a bit about how this works and how to determine if it fits in your environment.
2009-01-07
10,352 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers