A Script A Day - Day 1 - Database File To Volume Mapping
Today is the 1st February 2012 and as promised here is the first of script in my "A Script A Day"...
2012-02-01
585 reads
SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They...
2012-02-01
2,335 reads
DevConnections Offers DBAs Many Options for Training
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-02-01 (first published: 2012-01-31)
2,508 reads
App Domains and Their Uses
What is an app domain
An App Domain can be thought of as a kind of lightweight process. So What is...
2012-01-31
144 reads
Your Road to Becoming a DBA: Laying a Strong Foundation
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-01-31
2,154 reads
Setting the DAC port….
TweetG’day,
I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port.
The main...
2012-01-31
9,886 reads
Review: ICE-21 Ice Cream Maker
I’ve had making home made ice cream on my list of things to try for a while, since watching an...
2012-01-31
1,670 reads
Tech on Tap v1.1 Wrap-up
The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in...
2012-01-31
2,081 reads
SQL Server – Send email using Powershell
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts...
2012-01-31
1,969 reads
Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget
Charts present summary data in a visually appealing format. Following is a chart for sales over month:
Before
I frequently use a few...
2012-02-01 (first published: 2012-01-31)
8,031 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Alamat BCA KCP Cideng Timur Telp:0821-8200-203
Telp/Wa 628218200203 Jl. Cideng Timur No.11 F, RT.5/RW.4, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP KEM Tower Telp:0821-8200-233
Telp/Wa 628218200233 Kem Tower, Jl. Landas Pacu Barat No.Kav 2 Blok B, RW.10, Gn....
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers