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)
20,986 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,370 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,541 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,955 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,890 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,937 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,238 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,720 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,135 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,463 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers