This month’s T-SQL Tuesday topic is from Allen White. He posed the question of what is my favorite little SQL trick. I can’t wait to see what tips the #SQLFamily write about. I discovered one of my favorite tricks last year, just a little background my first SQL version I started out administrating and developing on 8 years ago was SQL 2000 back then to get table statistics was no easy task. These days you just need to right-click on the database and go the reports to get much of the information you’ll need about a database. I started using SQL 2008 last year so when I when wrote a blog post about this little trick I came across online on how to quickly pull the table size information it had been one of my favorite tricks then. Since I’m still dealing with data in SQL 2000 server production environment still this trick still comes in handy. Thanks to the posting by Mitchel Sellers on How to Determine Table Size it’s become quick and easy to get the information I need about my databases.
T-SQL Tuesday #025 – My Favorite Little Trick
Filed in Microsoft | SQL 1 Comment
Meme Monday: All I Want For Christmas
Filed in Blogging | Microsoft | SQL | Windows Home Server | Xbox 360 1 Comment
Thomas LaRock (blog|Twitter) came up with another fun topic to write about this month. What I want from Microsoft for Christmas I can’t wait to see what all my #sqlfamily peeps write about.
Well this is an interesting topic cause I’m not a devoted fan of Microsoft products. I do have my favorites Xbox 360, Windows Home Server at home and SQL 2000,2005,2008 and Express at work. I can do without office products, and the OS’s and oh yes I said Express, it’s my secret little favorite local database tool. At work getting stuff done with Access only would kill me so I cache what I need locally using SQL Express, design tables there and do a lot of data cleansing using and I mean a lot of freaking cleansing. But yeah all want I want for christmas from Santa Ballmer and Microsoft is a great reason to upgrade all my home computers to Windows 8. That’s simple enough right ????? maybe Santa will bring that oh and Roku box for my wife.
Things to make my life easier
Filed in Apple | Blackberry | Blogging | Google | Grooveshark | Microsoft | Netflix | Windows Home Server Leave a comment
I thought it was time to put together a little list of my favorite computer things i use to make my life easier. No big deal just the things i use everyday no matter if I’m at work or at home. I find myself using these products all the time.
Hope you enjoy my list and post comments and share your thoughts
1) Evernote – I first found the app for my the iPad before i knew about the website. But it’s be came one of my favorites and there’s a desktop version and one for my blackberry too.
2) Grooveshark – This is one awesome little music service no need to download the music or playlist you can stream it from anywhere. They even have a app for blackberry’s too.
3) 
iPad – Web browsing, video, music, and wide range of other things all in the palm of your hand.
- Flipboard – It’s like a magazine with my twitter and facebook feeds.
- Keynote – I can make amazing presentations on it very quickly and wow the hell out of people.
- RDP Lite – in case i get inspired to do some real work from it and it’s free.
4) Toggl – I love this program it helps me manage my Jaycees development task and hours.
5) Lifehacker – All around good reading and excellent tips
6) Google Doc’s – It’s like Microsoft Office but free and online.
7) Windows Home Server – Every need a file on your home pc while on the road? well this little thing can serve you up the files from anywhere anytime.
8 ) Google Chrome – it’s not just a another browser it’s one of the fastest ones out there and i like how fast it loads pages on my laptop and desktop.
SSIS Reference Points
Filed in Blogging | Microsoft | SQL | Work Leave a comment
This is a shout out to my former team member learning about SSIS packages for the first time and getting ready to move from SQL 2000 to SQL 2008. Here’s some good reference points for how to do the 
basics. Now before you call me and ask what does SSIS stands it stands for SQL Server Integration Services. So below is a couple links that i found i think you may find helpful in your new adventure.
- Everything you need to know to develop your first SSIS package
- Creating Your First SSIS Package
- SQL Server Integration Services an Introduction – Part 1
- Import and Export Wizard in SSMS — Step by Step
- Five SSIS Best Practices you can Take to the Bank
Stupid Duplicates Die Won’t You
Filed in Microsoft | SQL | Work Leave a comment
So the other day my former team member call me asking for help. She had inserted the same data into a table three or more times and needed to get rid of them. For those of you with duplications and need to delete them here’s a little statement i came up with and gave her.
DELETE FROM TBL_Employees
WHERE (EmpID IN
(SELECT MAX(EmpID) AS Expr2
FROM TBL_Employees
GROUP BY FirstName
HAVING (COUNT > 1)))
Ten Recently Listened To Tracks- Everclear – Father Of Mine February 3, 2012
- Nirvana – Smells Like Teen Spirit February 3, 2012
- Matchbox Twenty – 3 AM February 3, 2012
- Coldplay – Fix You February 3, 2012
- Green Day – Minority February 3, 2012
- Jack Johnson – Taylor February 3, 2012
- Weezer – We Are All On Drugs - Corrected Mix February 3, 2012
- The Verve – Bitter Sweet Symphony February 3, 2012
- Daughtry – Home February 3, 2012
- Tonic – Roses February 3, 2012
- 9:30am Conference call how gross
- Fabulous sunday morning !!!!!!!
- Woo off the monthly Palatine SAL meeting !!!!
- Where am I ???? I'm rockin the suburbs just like Michael jackson did !!!!
- Broke another blackberry :( the solution given to me was 3 extra batteries to burn through a day
