SQL Feeds - All your SQL feeds in one place.

Sponsors

Feed: The Penton-izer

Site: http://pentonizer.com/ Link: http://pentonizer.com/feed/

Wednesday, April 22, 2009

SSWUG.ORG Spring vConference

by David L. Penton via The Penton-izer on 4/22/2009 2:06:56 PM

Yes, I am speaking at the SSWUG.ORG Spring vConference.  I am in the .NET Development vConference and have 3 talks - Microsoft "Velocity", A New Approach to HttpRuntime.Cache, and finally Thread Safety Through Self-Loading Collections.  If you want to register for the vConference, all of the talks will re-run this evening.  Go to the site and use my VIP code SPVDPESP09 for $10 off the conference. There are many great talks, from .Net and Sharepoint to SQL and BI.  ...

[ read more ]

Wednesday, April 01, 2009

Cloud Computing With Pat Helland

by David L. Penton via The Penton-izer on 4/1/2009 10:01:53 PM

I recently had a conversation with Pat Helland on the ASPNETPodcast (link here).  It was a real treat for me for the simple fact that Pat is very easy to talk with.  But, he has been involved in some really interesting projects over his career which gives him [in my opinion] a unique perspective to discuss cloud computing and other related technologies. One of the big questions that I think people have is "How will I use this 'cloud' in my day to day programming?" - perhaps o ...

[ read more ]

Tuesday, March 31, 2009

Microsoft Tech Days virtual conference 1 April 2009

by David L. Penton via The Penton-izer on 3/31/2009 2:22:05 PM

I'm presenting at Microsoft Tech Days virtual event on April 1st at 11:30 AM Central. Come join in on the session! All that you need is LiveMeeting and you can register here. Microsoft "Velocity" There are several external caching engines that are available. Now Microsoft is busy developing their own caching engine called "Velocity". This promises to provide the ability for application developers to horizontally scale their applications across numerous servers by providing u ...

[ read more ]

Monday, March 30, 2009

Deep Dive into Microsoft “Velocity” on 1 Apr 2009

by David L. Penton via The Penton-izer on 3/30/2009 2:09:34 AM

I am speaking at the North Dallas .Net User Group (NDDNUG) on 1 Apr 2009. The topic: Deep Dive into Microsoft “Velocity”.  I am going to talk about requirements, configuration and do several live demos.  If you are in the areas, it would be great if you could stop by. Posted to Speaking Similar Posts NorthDallas.Net Users Group - 5 Nov 2008 Introduction to SQL Profiler Shreveport .Net User Group - 19 Jan 2009 ...

[ read more ]

Thursday, March 19, 2009

Microsoft Velocity

by David L. Penton via The Penton-izer on 3/19/2009 3:16:06 PM

Yes...another Microsoft Velocity post :)  I've done several videos and talks about Velocity and I wanted to have a place to be able to put a good bit of that information here: Video on Installation & Configuration Video on Code Samples Sample Code Sample Application Posted to Articles and tagged as velocity Similar Posts Microsoft Velocity Introduction to SQL Profiler Event Calendar for GraffitiCMS ...

[ read more ]

Microsoft Velocity

by David L. Penton via The Penton-izer on 3/19/2009 2:23:43 PM

Microsoft has been working on a great venture: "Velocity".  I have a great interest in that, since over the past couple of years I have been looking at ways to make cache be more effective for applications.  I've started giving talks and demonstrations with Microsoft Velocity.  Here are some basics (from a console app perspective): using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.Caching; namespace Velocity1 {   ...

[ read more ]

Tuesday, March 10, 2009

To NOLOCK Or Not?

by David L. Penton via The Penton-izer on 3/10/2009 3:05:00 AM

I was having a discussion with another DBA the other day about a particular stored procedure. It was a paging stored procedure with a number of other tasks to do. He was adamant about me including the NOLOCK hint for the SELECT statements. He ranted a bit about how it was "best practice" to use the NOLOCK hint on all SELECT statements.  I retorted with a different general statement of "let's optimize first and then see where we are."  I added that I felt it was a la ...

[ read more ]

Monday, February 23, 2009

Rachel Appel on Dynamic Data

by David L. Penton via The Penton-izer on 2/23/2009 7:23:13 PM

One of the recent interviews for the ASPNETPodcast was with Rachel Appel on Dynamic Data.  Rachel has been speaking on the ease of creating websites with Dynamic Data.  Check out the podcast, but of course, check out Dynamic Data as well. Posted to ASPNETPodcast Similar Posts ASP.NET MVP Award for 2009 Introduction to SQL Profiler CodeCampRDU 15 Nov 2008 - My Thoughts ...

[ read more ]

Sunday, December 21, 2008

Rate Mix Math Problem - An SQL Solution

by David L. Penton via The Penton-izer on 12/21/2008 10:42:00 PM

Periodically people send me emails or some other form of a message asking me for help with problems that are facing.  Since I have some proficiencies in mathematics, in some cases the problems tend to be very related to mathematics.  One such problem came to me from someone I have never met, but know on Twitter.  He called it his "Rate Mix Math Problem".  What I want to do with this post is to describe what my thought processes were to analyze this problem and help ...

[ read more ]

Sunday, November 30, 2008

SQL Profiler Command Line Options

by David L. Penton via The Penton-izer on 11/30/2008 10:13:53 PM

I find it very helpful that when I am developing applications that use a database to see what is being sent to the database. Now, let’s be clear – I think anyone that does any development against a SQL Server database should be aware of SQL Profiler and can use its basic functionality. So, to help speed some of that up (devs are always looking for shortcuts) here are the command line options, one of my samples and descriptions of the options. Very simply put, you can begin a trace with trusted ...

[ read more ]

Introduction to SQL Profiler

by David L. Penton via The Penton-izer on 11/30/2008 10:04:25 PM

Many times I see web developers using many tools to help them with their day to day duties. WebDevs use VS.Net, stripped down text editors, CSS tools, JavaScript tools, browser plug-ins…the list is never-ending. Not to mention the languages (ASP.NET, PHP, Ruby, etc.) One thing typically in common with all of the WebDevs is the usage of database technologies. In the Microsoft world, this more often means SQL Server. One of the most underrated (and perhaps underused) tools that WebDevs shoul ...

[ read more ]

Tuesday, November 11, 2008

SSMS Custom Keyboard Shortcuts

by David L. Penton via The Penton-izer on 11/11/2008 6:55:00 PM

There has been some discussion about shortcuts to SQL Server metadata on some of the mailing lists I am on.  I thought I'd share the shortcuts I use on a daily basis with people.  Now for my listing.  I'll include the defaults from SQL Server already.  To get to the shortcut menu, click on Tools...Options...Keyboard.  You may need to close out all instances of SSMS and restart it for changes to take effect. Shortcuts Selected Objectname Stored Procedure Alt+F1 Y/N ...

[ read more ]

Wednesday, October 15, 2008

Trim custom characters in a SQL string

by David L. Penton via The Penton-izer on 10/15/2008 11:04:00 PM

Someone on one of the SQL Server lists I subscribe to proposed a question earlier today - How do you trim leading and trailing characters?  In this case, the desired string was a numerical string, and the character to trim was a period.  There were several responses to that question.   I felt compelled to write a blog post afterwards. declare @s varchar(20) set @s = '...1234.56...' select     substring( @s         /* w ...

[ read more ]

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us