Category: Tips

SQL Math: Whole Numbers, Real Numbers

Post author By Jen McCown
Post date March 28, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
3 Comments on SQL Math: Whole Numbers, Real Numbers

It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no [insert name of famous math genius here], but I’ve been able to explain some basic things over the years. A common SQL Math Misunderstanding came up again recently with a fellow SQL practitioner, so off […]

24 Hours of PASS Spring 2011 Code Sins

Post author By Jen McCown
Post date March 15, 2011
Categories In 24HOP, 24HOP, Beginner, Intermediate, sql server, SQLPASS, sqlserverpedia-syndication, SSC, Tips, TSQL
5 Comments on 24 Hours of PASS Spring 2011 Code Sins

Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring 2011. Thanks to the 750+ of you that attended, and the many who commented!! I will be updating this blog post with links and answers to questions for a few days yet. The 24HOP recorded sessions […]

RTFM365, Week 1

Post author By Jen McCown
Post date December 10, 2010
Categories In Advanced, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips
2 Comments on RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t stop the server side trace, it stops SQL Server itself. Be warned. Boilerplate: For the next year (-10 days now), I will read from SQL Server Books Online a little every day, and blog about […]