Finding Referenced Objects in SQL Server

Last Updated on Tuesday, 28 May 2013 01:05 Written by David Bauernschmidt Friday, 31 May 2013 12:00

When working with a large amount of objects in sql server there are times when you want to know what columns or fields are used in other objects (views, stored procedures, triggers, functions, etc). In SQL here are two queries that you can run to determine what if any dependencies there are.
Just replace the ‘%LastName%’ with whatever you are looking for. The only thing you have to remember is if you have multiple table names with the same named column then you will get a result back with both tables. To prevent this then you might what to fully qualify the table names in your objects and then search for them that way. For example; if you a salesman table and a customer table with ‘LastName’ fields then this could be a problem.

How Do I Bundle JavaScript Files in Web Forms?

Last Updated on Tuesday, 28 May 2013 01:04 Written by David Bauernschmidt Wednesday, 29 May 2013 12:00

The other day I was working on trying to create faster page loading in a .NET project and decided to tackle the idea of minifiying my JavaScript files. After trying tiressley to attach a minify routines to my web site between compiling and deploying I was not happy with the results. I would have to build something in each page to load the .min version if I was in debug but the full uncompressed version if I was testing. It seemed like a lot of work to do with many places that things could go wrong. I then remembered an article about bundling in asp.net but it seemed to relate to a feature in asp.net 4.5. What about 4.0? I was pleasantly surprised to see that you can get this to work with 4.0.

How to Compress a PDF for Faster Download

Last Updated on Monday, 27 May 2013 01:24 Written by David Bauernschmidt Tuesday, 28 May 2013 12:00

It is always amazing to me to download a PDF from a site and compress it using several different tools.  Before I get started let me preface that I have absolutely nothing against the author or the document(s) they present but this is just showing you what you can gain by spending a few extra minutes.  This document contains a lot of images.  It seems that the more images you have inside a PDF the greater compression ratio you can achieve.  By using different tools online as well as the wide range of options from each site you can achieve some amazing results.  I also admit that some of these might not be acceptable alternatives for this kind of document but in general you can achieve great results for a small amount of effort.

Get Set, Get Select, Which One Do I Use in SQL?

Last Updated on Tuesday, 21 May 2013 02:03 Written by David Bauernschmidt Wednesday, 22 May 2013 12:00

If you are like me I frequently use cursors in sql, but the other day I had created a piece of code like below. Before telling me I could do this a different way, I want to show you what I found.–Go with me…

How to Add a Favicon to a Web Site

Last Updated on Saturday, 11 May 2013 06:14 Written by David Bauernschmidt Thursday, 16 May 2013 12:00

Branding a site can include a wide range of initiatives.  Some can take a large amount of time and energy (graphic designs, target marketing, etc.) while others can take just a few minutes.  Today, I am going to show you a way to add branding to your site without paying a dime and take less than 15 minutes.  You don’t need to pay anyone and can do this completely online for free.  The only requirement is that you have a company image.  When you get this then follow the steps below.

Go to a site that will allow you to upload your image and tweak the image like

• favicon.cc
• Degraeve.com
• Favicon-generator.org