With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
2009-10-22
468 reads
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
2009-10-20
528 reads
A new feature is available on SQLServerCentral, and Steve Jones talks a little about how it fits in with your strategy here at the site. Visit ask.sqlservercentral.com and let us know what you think.
2009-10-19
560 reads
Feel like making a prediction this Friday? Steve Jones looks to the future with information workers and a knowledge economy. Answer this Friday poll and give us your guess about the future.
2009-10-16
104 reads
Is it hard for technology workers to ask for help? Or accept it? We seem to often be the type of people that want to solve problems and fix things on our own. Is that a problem? Steve Jones thinks that we should sometimes put aside our pride and get things done.
2009-10-15
79 reads
What great historical figures would make great DBAs? A guest editorial from Grant Fritchey examines the traits and characteristics we look for in this role and which famous people we might choose and why.
2009-10-14
444 reads
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
2009-10-13
83 reads
Are you a manager of one? Steve Jones say show this might be a good thing to be. You might improve your chances of landing the next job by showing your employer that you can be more productive.
2009-10-12
612 reads
Do you invest in your own career? Should you? Steve Jones asks the question in today's Friday poll.
2009-10-09
757 reads
Hadoop is an interesting new software project in the Linux world that deals with large data sets. Steve Jones wonders if anyone in the SQL Server world has started working with it.
2009-10-08
804 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Nitazoxanide 500 mg Buy Online is a search term used by people looking for...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
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