Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

It’s Time to End Password Reuse

by Andy Warren

SQLAndy

Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...

2014-05-26

684 reads

Get User In Reporting Services

by Andy Warren

SQLServerCentral

Reporting Services (SSRS)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2014-05-26

1,719 reads

Discuss

Building The SQLSaturday Orlando Marketing Plan–Part 11

by Andy Warren

SQLAndy

Just received the first flyer design – thoughts?

2014-05-24

548 reads

Building The SQLSaturday Orlando Marketing Plan–Part 12

by Andy Warren

SQLAndy

Meetup.com did refund my $19, good!
Team oPASS added SQLSaturday #318 to their calendar, you can see it here, or here’s...

2014-05-24

554 reads

Building The SQLSaturday Orlando Marketing Plan–Part 10

by Andy Warren

SQLAndy

My experiment with Meetup.com hasn’t worked out well so far. I set up the event site and sent it around...

2014-05-23

532 reads

Wishing For Error Messages That Are Good Search Terms

by Andy Warren

SQLAndy

Here’s a SQL error you might get:
not able to access the database “SomeDB” under the current security context.
If you don’t...

2014-05-23

522 reads

An Sp_addrolemember Gotcha

by Andy Warren

SQLAndy

Over the past few months there have been a handful of times when I had to fix a security problem...

2014-05-22

826 reads

Writing A Question Of the Day–More Notes

by Andy Warren

SQLAndy

One of the things I’m trying to do now is include a link to a blog(ger) in the explanation. That...

2014-05-22

489 reads

Building The SQLSaturday Orlando Marketing Plan–Part 9

by Andy Warren

SQLAndy

I’ve heard more than once that Meetup.com is a good way to reach new people so we’re looking at how...

2014-05-21

700 reads

Submitted My Application For the 2014 PASS Nominating Committee

by Andy Warren

SQLAndy

I just finished up the short and not very painful application to be a candidate for the NomCom this year. ...

2014-05-21

496 reads

Blogs

Ramblings about data communities and your contributions, no excuses

By DataOnWheels

I have been active in the data community throughout my career. I have met...

SQL Server Journey till 2025 (brief)

By Vinay Thakur

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

Building Power BI Reports: Desktop vs Fabric

Why this comparison feels confusing If you’re a Power BI report author who’s just...

Read the latest Blogs

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:...

Visit the forum

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
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?

See possible answers