Andy Warren

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

All authors

Blog Post

SQL Pi

A mildly humorous title, spawned by a link my friend Jon sent me about calculating Pi using a batch file....

2009-02-10

771 reads

Blog Post

PASS Update #4

Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my...

2009-02-05

400 reads

All authors

Blogs

Finding fields used in a Power BI report in PBIR format with Semantic Link Labs

By

Have you ever wondered where a certain field is used in a report? Or...

Adding Test data to msdb.sysjobhistory

By

One of our internal people was looking to test some process in (I assume)...

Microsoft Ignite Announcements Nov 2024

By

Announced at Microsoft Ignite last week were some new product features related to the...

Read the latest Blogs

Forums

A Strange Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Strange Query

Primary and Secondary Filegroup

By nshete

Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...

Import data from json file with special characters

By don075

I am using the following script to import data from a json file. This...

Visit the forum

Question of the Day

A Strange Query

What does this return? 

SELECT x=1 
WHERE (SELECT 1) IN ( 1, 2, 3)

See possible answers