New LOGICAL functions in SQL Server Denali
IFF Function
If you are an old Access or Excel “developer” you know this one. This is not a function I...
2011-09-06
2,982 reads
Parallelizing Slow Parts of the Data Flow - Part 1 - Preparation
It's quite common to have parts of your Data Flow that are slow, and there are some techniques you can...
2011-09-06
872 reads
When technology works.
Living in the South East has it perks with the abundant rivers, lakes, streams, mountains, and friendly people. It also...
2011-09-05
417 reads
My Guide to Passing MCTS Exam 70-432
A reader wrote in to me last weekend regarding the MCTS Exam 70-432 (SQL Server 2008, Implementation and Maintenance).
Hi John,
I...
2011-09-05
2,397 reads
Managing AlwaysOn with Powershell
Although you can use SQL Server Management Studio or T-SQL to manage AlwaysOn, SQL Server Denali CTP 3 includes 25...
2011-09-05
19,192 reads
The Principle of Least Privilege – Skill #3
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-09-05
5,543 reads
PASS 2011 Countdown – 5 Weeks To Go
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you...
2011-09-05
862 reads
SQL Education
They always used to tell us that education is important.
Education is (They said) key, in fact. We as a technical...
2011-09-05
471 reads
Youngest MCM in the world?
As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness...
2011-09-05
1,498 reads
SQL Server 2011 “Denali”: Give feedback and win nice gifts
Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for...
2011-09-05
647 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers