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
Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.
2009-02-04
3,381 reads
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
2009-02-04
3,287 reads
If you are building packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post.
2009-02-03
1,319 reads
I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?
2009-02-03
3,559 reads
Continuing his discussion on SQL Server 2008 Data Collections, Greg Larsen explains how to create your own custom Data Collections.
2009-02-02
2,538 reads
ANSI SQL can perform breakthrough any-to-any hierarchical data structure reshaping. These are transformations that are performed utilizing only the structure semantics in the data assuring correct semantic results.
2009-02-02
1,284 reads
Public sector agencies very often need to work at ensuring that their corporate cultures establish a high value on, and properly reward, a push toward analysis.
2009-01-30
2,758 reads
Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL Server on each machine or can I do so from a single application?
2009-01-30
2,589 reads
We are looking to grow our team and we are interested in finding out what a reasonable set of questions would be for Network Administrator candidates that also state that they can support SQL Server. Do you have any suggestions?
2009-01-29
3,420 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers