Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

Website: https://sqlswimmer.com/
LinkedIn: https://www.linkedin.com/in/angelahenrydba

Will You Vote?

by Angela

SQL Swimmer

Voting is one of the many privileges that I have as an American citizen. It’s a privilege that most Americans...

2013-09-23

560 reads

Saving Grace

by Angela

SQL Swimmer

According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...

2013-05-30

1,232 reads

Certifiable?

by Angela

SQL Swimmer

I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...

2013-05-17

608 reads

The Long and Winding Road

by Angela

SQL Swimmer

“The Long and Winding Road” is one of my favorite Beatles songs, it reminds me of my dad, he was...

2013-05-14

562 reads

Custom Reports for SSMS 2012

by Angela

SQL Swimmer

I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions,...

2013-03-29

2,145 reads

Summit 2012 is over, but not forgotten

by Angela

SQL Swimmer

What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed...

2012-11-12

724 reads

Policy-Based Management, How Sweet It Is

by Angela

SQL Swimmer

I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. ...

2012-10-24

1,909 reads

PASS Election Season

by Angela

SQL Swimmer

Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential...

2012-08-27

603 reads

Mentoring

by Angela

SQL Swimmer

I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor...

2012-08-24

633 reads

Paying it Forward

by Angela

SQL Swimmer

My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a...

2012-08-24 (first published: 2012-08-22)

1,723 reads

Blogs

AI Step 1

By Vinay Thakur

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By Ige Adetokunbo Temitayo

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Active and Active Cluster

Hi Team, I am planning to apply security updates for SQL Server 2016 on...

SSIS package works in VS but failed in SSMS

Please help and thanks. Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has...

Need a list of stored procedures that execute multiple stored procedures

Hello SSC! I hope you all had a happy and safe holiday! Apologies if...

Visit the forum

Question of the Day

The Funny SELECTs

What is returned from this query?

SELECT
  ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;

See possible answers