05Oct

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.

Some Awesome SQL Development Blogs  
http://jessicammoss.blogspot.com/ http://www.sqlservian.com/
http://adventuresinsql.com/ http://sqlblog.com/blogs/andy_leonard/
http://www.sqlis.com/sqlis/ http://www.brentozar.com/
http://agilebi.com/jwelch/ http://blogs.msdn.com/b/mattm
http://sqlblog.com/blogs/jamie_thomson/ http://blog.sqlauthority.com/
http://crysmanson.com/ http://thesqlagentman.com/
http://jesborland.wordpress.com/ http://sqlchicken.com/
http://www.sqlskills.com/blogs/paul/ http://sqllunch.com/Default.aspx

30Sep

Documenting Isn’t That Hard

Filed in Blogging | Work Leave a comment

Just like the title said it’s not that hard and it one of the most important things in software and process fridgeNotebookHack.jpgdevelopment is the the Documentation part. But it’s most often the most over looked do to time and no short term benefit. But long term after the developer has forgotten what they did back then the documentation they have written will still be there for the next developer to come along and revise, enhance, or just get a better understanding of what is taking place and how it done. Below are a couple of things everyone should remember when documenting.

  1. Don’t forget to spell check, what you say will live on forever so try not to look so dumb with all the spelling error. As for grammar who cares right? your a developer not a English teacher.
  2. Process flow charts are golden, everyone likes pretty pictures and maps to follow.
  3. Show samples, though the reader may not understand the code work they can at understand the references you put in front of them.

24Jul

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)))

15Jul

Who owns your hard programming work

Filed in Blogging | Ranting on | SQL | Website Development | Work Leave a comment

Rails Code by davestfu.

 

??????????????????????

to be continued…..

But in the mean while comments and thoughts welcome

17May

Determing SQL Server Table Size Tip

Filed in Microsoft | SQL | Work 1 Comment

 

From time to time i run into problems of where some new table appears on m  server and starts eating up all my space. Well i came across this blog posting a while back that does a great job of explaining how to determine the table sizes in a database in SQL 2000 it works in 2005 too.  check it out and let me know what you think.  http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx

TOP
Stop SOPA