What Makes a Good Programmer
Are top notch programming skills innate or can they be learned? Janet Wong takes a look at the skills and capabilities of great programmers in this essay.
2008-05-15 (first published: 2007-07-03)
21,020 reads
Janet Wong
My Projects Have Never Failed
As a SQL Server DBA or developer, how do you measure the success of your projects? What about your users? Here is an interesting look by Janet Wong at a few of her projects and how their success was perceived. See if any of your experiences are similar.
2008-02-28 (first published: 2007-04-30)
8,384 reads
Problems In Building a Data Warehouse
Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this
type of project.
2008-01-29 (first published: 2007-03-05)
7,567 reads
The Dynamic Process of Loading Data
When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.
2007-12-31 (first published: 2007-01-23)
9,990 reads
What's a Good Manager
What makes a good manager? In response to a recent thread, Janet Wong takes us through some of the good and bad managers she's had during her career and talks about the problems today with technical managers.
2007-12-20 (first published: 2007-01-16)
12,920 reads
Developers and DBAs
The battle between developers and DBAs can be a rough one at times. However DBAs are often outnumbered by developers and need to be sure they fit in. DBA Janet Wong brings us one of her experiences about how you can better go with the flow.
2007-11-29 (first published: 2006-12-05)
8,951 reads
Are you ready for Data Warehouses?
Data warehousing is being used more and more everyday and longtime data warehouse DBA Janet Wong brings us a short look at
her first project and some thoughts about warehousing in general.
2007-03-21
6,259 reads
The Data Warehouse DBA
We have hosted a number of articles on various aspects of being a DBA, but we have usually focused on production or development DBA. New data warehousing DBA Janet Wong brings us a look at another type of DBA, the data warehouse DBA and the skills they need.
2006-12-14
9,766 reads
SQL Server Adventures for the Oracle DBA
Oracle and SQL Server are both database platforms built on SQL, but there are vast differences between them. Janet Wong brings us a tale of her experiences in moving from Oracle to SQL Server as a developer.
2006-10-19
8,155 reads
Data Quality
What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you.
2006-09-18
8,487 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers