PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.
2014-04-10
3,950 reads
If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. Dallas Snider answers the question of additional overhead caused by encryption.
2014-04-09
4,230 reads
The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.
2014-04-08
10,155 reads
Load tests give the database administrator quite a lot of valuable information and may make the difference between poor and acceptable application performance. But are there any gotchas or traps associated with big data?
2014-04-07
4,112 reads
Relational division is used in SQL to select rows that conform to a number of different criteria. Dwain Camps explains how to use it, and shows the performance gains.
2014-04-04
3,369 reads
Distributed File Databases manage large amounts of unstructured or semi-structured data. Buck Woody shows how to install Hadoop in your Data Science lab to experiment with an example of the breed.
2014-04-03
3,170 reads
A SQL Server MSDB database is flagged as "suspect"... what can you do? John Grover has some suggestions
2014-04-03
3,669 reads
The DBA Team are back, ready to save another DBA. In this episode, a rogue DBA sabotages the backups, can Robyn Page, Steve Jones, Grant Fritchey, and Phil Factor find the solution? Save the backups...save the business.
2014-04-02
4,749 reads
A relational database is a complex machine that is asked to deal with intricate problems. When things go wrong, it usually takes knowledge, deduction and a systematic approach to track down the root core of problems and to determine the best fix, Joshua Feierman illustrates how this can be done.
2014-03-31
6,661 reads
Is there a way to process only the new data for a partition in SQL Server Analysis Services? Yes, this is accomplished in SQL Server Analysis Services with the ProcessAdd option for partitions. Daniel Calbimonte demonstrates how it works.
2014-03-27
4,415 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 Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
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