| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|
| « Jun | Aug » | |||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
SQL Server
Fast Running Totals solution with ordered CTE update? Who says you need a cursor to get a running total? I’ve typically done these kinds of things with expensive CROSS JOINs and/or nasty INNER JOINs. Good to know there’s a nicer way.
Extended Events Manager Update: Now A SSMS Addin SQL 2008 Extended Events are a [...]
I work in isolation. I don’t mean physical isolation – I have coworkers and we talk and go to lunch and do all kinds of coworker things. I work in physical isolation from other practicing database professionals. My manager is a former DBA, but he hasn’t worked with SQL Server newer than SQL 2005 and [...]
SQL Server
Learn Microsoft BI So you want to learn all about the BI, do ya? Lots of videos. Lots and lots of videos. They’re all free.
Getting a NEWSEQUENTIALID() How do you get the ID that’s created after an insert if you’re using NEWID() or NEWSEQUENTIALID()? Pat Wright has the answer! (Hint: The answer is not [...]
First off, I want to say thank you to the Central Ohio .NET Developers Group for giving me the opportunity to speak last night. I really enjoyed it and I was glad that I could share some of the things that I’ve learned with such a great group of people.
Everyone at CONDG was very welcoming, [...]
Here are the slides and sample code from my recent presentation “From Tables to Objects” that I gave at the Central Ohio .NET Developer Group.
To those who did not attend, you can skip the rest of this post unless you want some NHibernate and SQL Server resources.
NHForge – this is the project home page [...]