Lee posted on June 26, 2010 10:49
I usually don't blog about the company that I work for, but wanted to mention that Capgemini/Sogeti this week was awarded something very special - the Microsoft Global Enterprise Partner of the year award.  Niiiiice!  Check out the links below for the news release and the award at the Micr... [More]

Posted in:   Tags:
I thought that you would enjoy this genius of a posting that I saw the other day...greatness!  Make sure and stop at step #8 and then go try to figure out why he got the results that he did. After reading, you'll agree that 1=2.  Enjoy!!! Lee   ----------------------- "Educ... [More]

Posted in: Etc. (Off-topic)  Tags:
You might get the following error when you run an SSIS package: Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:28:07 PM Error: 2010-06-24 15:28:08.20 Code: 0xC0011007 So... [More]

Posted in: SSIS  Tags:
I just flipped over to the North Lake College website and noticed that three courses are scheduled for Fall 2010, of which at least one I will be teaching, maybe more.  The schedule includes the following, which will be taught on Microsoft SQL Server 2008 R2: 1) ITMC-2437-7700 (638368) Program... [More]

Posted in:   Tags:
In SQL Server, there is a little-known switch…–E…which is a startup option to increase the number of extents allocated per file within a filegroup during each iteration of writes. Here’s an excerpt from the link from the KB on it: The Microsoft SQL Server 2000 Enterprise Edition (64-bit) and Mic... [More]

Posted in:   Tags:
I’m about to do several blogs on SSIS Custom Components; these are the tasks that you code and add to the SSIS toolbox to include some sort of transformation or connection functionality that Microsoft might not have delivered.  Very cool and a lot of fun to write!  While working on these I... [More]

Posted in: SSIS , .Net  Tags:
Here's a cool new feature for Windows Server 2008 R2 Service Pack 1 just in from TechEd - Hyper-V Dynamic Memory. Very nice!!!  I have a setup at home with all of my SQL Server on Windows Server 2008 R2, and this should work great for me!  Check it out! Lee   -------------------- ... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on June 14, 2010 18:41
Joe Celko created the masterpiece entitled Ten Things I Hate About You over a decade ago, and to this day I still enjoy reading his effort. (I should have pinged Ol' Joe at SQLSaturday #35 in Dallas last Month but I was busy and he looked busy, both of us preparing for our sessions). This is a class... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on June 14, 2010 12:57
For some reason I always thought that when a new version of SQL Server was released, it included the latest and greatest hotfixes from the previous edition; after all, you would think that a new release would have all of the most current patches included, which represents the most up-to-date repairs... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on June 11, 2010 06:15
I've been rummaging around trying to find free SQL Server goodies - hats, stickers, those posters that you get only if you're a SQL Server Magazine subscriber, etc. - and got a tip from Microsoft Certified Master and all-around cool dude Brent Ozar from Quest.com of their backstage page. If you go t... [More]

Posted in: Etc. (Off-topic)  Tags:
Sunil Agarwal, a program manager from the Storage Engine Team, from the just did another blog posting on minimal logging in SQL Server 2008 and TF-610, this one when using the MERGE statement. Run some of his code in his series on minimal logging and see if you don’t agree with me that this is reall... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on June 6, 2010 18:07
Where I am consulting we’re getting ready to set up a full-blown partitioning design for a fact table that will hold data from, roughly, 50 countries. Someone asked the other day about locking and DML so I experimented in another post on the new (LOCK_ESCALATION = AUTO) feature for SQL Server 2008.&... [More]

Posted in: SQL Server 2008 , TSQL  Tags:
Lee posted on June 3, 2010 15:46
A week ago or so I was doing some Google searches to try and find a download of cities, states, countries, etc.  I found several sources but didn’t really like any of them – most were actually difficult to download because they had no delimiters or some other funkyness to them - until I came ac... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on June 3, 2010 13:49
We officially have a decent product now. Sweet! I just got finished downloading SQL Server 2008 R2 and Visual Studio 2010 Premium Edition; very excited to try out the database tools, such as Schema Compare, Data Compare, and Data Generator. Especially the Data Generator, because I don't have a go... [More]

Posted in:   Tags:

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog