SQL Awesomesauce

“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get...

2012-01-13

833 reads

Discuss

DBAs@Midnight 6 week roundup

by Jen McCown

SQL Awesomesauce

We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...

2012-01-12

688 reads

Discuss

SELECT GetDate() – 30 AS [This actually works??];

by Jen McCown

SQL Awesomesauce

I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....

2011-12-19

1,231 reads

Discuss

PASS Board of Directors – Who I’m Voting For

by Jen McCown

SQL Awesomesauce

I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...

2011-12-15

666 reads

Discuss

#SQLLove for my Mentor

by Jen McCown

SQL Awesomesauce

In 1986, my big brother Jim accidentally encouraged me on my road to geekdom by purchasing an Apple][e, and later...

2011-12-14

735 reads

Discuss

SQL Server is Smarter Than You

by Jen McCown

SQL Awesomesauce

I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...

2011-12-08

840 reads

How to Build a Resume (that doesn’t suck)

by Jen McCown

SQL Awesomesauce

Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain...

2011-12-06

3,159 reads

Discuss

Convince me to read books (WHERE LEN(argument)

by Jen McCown

SQL Awesomesauce

While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.
I...

2011-11-30

1,672 reads

Stop SOPA…it already happened in Denmark #StopSOPA

by Jen McCown

SQL Awesomesauce

I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....

2011-11-16

551 reads

Un-SQL Friday: Stop SOPA!

by Jen McCown

SQL Awesomesauce

This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...

2011-11-15

1,057 reads

SQL Awesomesauce

Answer the Question Asked

DBAs@Midnight 6 week roundup

SELECT GetDate() – 30 AS [This actually works??];

PASS Board of Directors – Who I’m Voting For

#SQLLove for my Mentor

SQL Server is Smarter Than You

How to Build a Resume (that doesn’t suck)

Convince me to read books (WHERE LEN(argument)

Stop SOPA…it already happened in Denmark #StopSOPA

Un-SQL Friday: Stop SOPA!

Blogs

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Building Power BI Reports: Desktop vs Fabric

Forums

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Having a Little Fun at SQL Server Central

Question of the Day

String Similarity I