I use sequence objects when I need a unique key across a set of tables.  This has always been to support each item having a different key when they are...

I'm absolutely not dissing CS degrees in any way... but mostly pointing out that a proven record of success in a field weighs much more heavily, at least in my...

I select File, Open, Analysis Services Database....  In the resulting dialogue box, select the server and the cube.

If you don't see that, you may need to install the Analysis Services...

I have degrees in Political Science and History, which were useful for the jobs I had following getting those degrees.  I had done some BASIC programming in High School in...

Time is THE most valuable resource.

When my third child came along, I gave up watching whole football games.  I would check in in the second half, and if close, would...

Time is THE most valuable resource.

When my third child came along, I gave up watching whole football games.  I would check in in the second half, and if close, would...

Badminton.  I was actually pretty good at it in college.  I spent four years in South Korea, where it is an important sport.  Most Americans have experienced it in the...

I have sometimes been surprised at things people I know are experts don't know.  I've also been surprised at things people with much less knowledge than me have contributed to...

I have run into issues trying to restore a file for which I didn't include .BAK.  So now I do it religiously.

Getting back to the subject, Ron suggested that I was pretty well set in my opinion and that he wasn't going to try to change my opinion.  I'm suggesting that...

You may have never seen a good data warehouse.  The advantages over standard reporting procedures are significant.  Calculations such as YTD, PTYD and the comparisons of the two, rolling averages...

I have used a similar approach to help show work orders that had been open a long time to stand-out more easily yet more orderly.  Worked great.

Once you start thinking of a table as singular, your mind shifts to RBAR instead of set thinking.

Totally disagree.

If you have the skillset in house, I highly recommend using SSIS.  If the skillset is not in house, scripts are probably preferred.  But in ETLs of any complexity, they...

I use SSMS.  My complaints are minor and I've been using it in some form for more than 20 years.  I don't want to get used to a new GUI...