If you make the decision to upgrade to 2008, there are a number of tools that make the process easier, but you still need to understand what things you should consider. We have a new article from Arshad Ali to help you understand the process and what you should consider.
2011-05-20 (first published: 2009-03-02)
22,602 reads
In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.
2010-03-26 (first published: 2009-08-28)
20,377 reads
Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.
2010-03-19 (first published: 2009-08-27)
25,187 reads
Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.
2010-03-12 (first published: 2009-07-27)
29,522 reads
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,631 reads
The fifth installment of Arshad Ali's series examines the spatial data types in SQL Server 2008. These new types allow the use of geospatial data in SQL Server applications.
2009-08-31
10,691 reads
2009-05-15
6,231 reads
2009-03-13
3,217 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers