New Author! This is an introductory level look at MDX geared toward intermediate or higher SQL users. The rate of OLAP usage is lower than it should be - maybe this will be what gets you started using it. Or thinking about it at least!
2004-01-02
22,787 reads
Hopefully you never hear any of these from your sysadmin...
2003-12-31
8,123 reads
Ever wonder how SQL Server Central.com was built? Ever wonder why the three founders made the decisions they did? Here's a look at some of the choices that were made early on with the discussion forums.
2003-12-30
4,268 reads
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
2003-12-29
5,828 reads
This article on CNET has some info about how Yukon affects the MS strategy in other areas.
2003-12-29
3,447 reads
We haven't had a book review in a while and this one may not be of interest to all of you, but we decided to take a chance and post it anyway! As Andy notes in the review, odds are that you'll deal with one or both of these applications sooner or later, might be worth thinking about taking a look at what they can do. (Reviewed)
2003-12-26
3,369 reads
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-25
13,196 reads
The first part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-24
16,064 reads
Get started with using WMI (Windows Mgmt Instrumentation) by seeing two good scripts to start with, one to reboot the server, another to list all the services.
2003-12-23
10,021 reads
Dinesh looks at the date functions, how to work with time zones (or not), and does a brief comparison to see how you do similar tasks in Oracle.
2003-12-22
15,262 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