Using the OPENROWSET function in SQL Server
OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.
Mining for Experts
How do you determine who is an expert in a field? Or if they are willing to answer questions for others? A new system that should do just that intrigues Steve Jones.
The Next Frontier of Performance Troubleshooting
The number of tools for troubleshooting SQL Server performance problems has recently expanded at a dizzying rate. Is the latest one any reason to get excited?
Transparent Data Encryption (TDE) SQL Server 2008
Transparent data encryption, otherwise known as TDE is one of the new features introduced in SQL Server 2008.
Finding the causes of poor performance in SQL Server, Part 2
In the first part of this series of articles, Gail showed how to find the procedures that contributed most to performance problems. In this final part, she shows how to use query statistics to pinpoint the queries that are causing the biggest problems, and then use the query execution plans to find out which operations are the root cause.
Installing Reporting Services on SQL Server 2005 Express Edition
Having completed our coverage of the Service Broker characteristics specific to SQL Server 2005 Express Edition, we now turn our attention to Reporting Services. In this article, we will present the initial setup process, leaving discussion of configuration, management, security, and usability for future installments.
Starting Conversations - Part 3
If you haven't already, start with Part 1 and Part 2. In Part 2 I mentioned that I have hired Don to coach me on networking, and this week I'll share some results from our first 1.5 hour session.
Mining for Experts
How do you determine who is an expert in a field? Or if they are willing to answer questions for others? A new system that should do just that intrigues Steve Jones.
Mining for Experts
How do you determine who is an expert in a field? Or if they are willing to answer questions for others? A new system that should do just that intrigues Steve Jones.
Mining for Experts
How do you determine who is an expert in a field? Or if they are willing to answer questions for others? A new system that should do just that intrigues Steve Jones.
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
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