Search  
Sunday, May 20, 2012 ..:: Start ::.. Register  Login
 Register Now. Minimize

Registered users have
access to Current and
Previous meeting agendas
Discussions, Cool Websites,
Job Opportunities,
and Snippets. 

Register today, it's Free!


      

 Sponsors Minimize

Our newest sponsor:
Intertech .NET and Java Training
Intertech .NET, Java,
and SQL Training


IderaLogo.gif
Idera
Tools for Sql Server

Thank you Idera,
For your wonderful
Sponsorship.

logo.gif
Las Vegas Chapter
Professional
Association for
Sql Server

TrainingSpot.gif

Can't find the training you want
locally? Try one of our new
sponsors - TrainingSpot.com
or LearnVisualStudio.net!
LearnVisualStudioLogo.gif

Wrox.GIF
The nice folks at
Wrox Press are
sending us some
books.

SqlServer2005.gif
Sql Server 2005

aspnet.gif
ASP.NET 2.0

DiscountASPNet.gif
Hosting by
DiscountASP.Net

SolvStuff.gif
Geek Stuff
Available online.
S3olvShirt.jpg

General donation to SSSOLV Pizza Fund
Donate to the
Pizza Fund
A couple bucks helps
 Total to date: $10.00


      

 SELECT TOP 1 * FROM WelcomeMessage ORDER BY UpdateDate DESC Minimize
Next Meeting

May 10, 2012 6:00-8:00pm PDT

We are desparately working to get a speaker for the next event.
Please email admin@sssolv.com if you can present up to hour on any SQL topic.
Microphone, Video, and PC required if presenting over LiveMeeting.

Meeting location is still:
M Staff And Training
2620 Regata Dr Suite 102
Las Vegas, NV

      

 Select * from AboutThisSite Minimize

logo.gif tagline.gif 
We're now the local Las Vegas PASS Chapter!!!
PASS is the premier organization for Sql Server Professionals.
Lots of great benifits, including free basic PASS membership for all our members! 

dotnetnukelogo.gif

aspnet.gif

sql2005.jpg

Conent Management System by:
DotNetNuke Version 4.0.1

Written in
Microsoft ASP.NET 2.0

Running on:
SQL SERVER 2005


      

 S3OLV in the Blogs Minimize

SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months.  Nothing like the present to reverse that trend.  I do have a good excuse for why I haven’t posted many blogs for the past month or so.  That is a good reason to get my queue [...]

Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored.  Then a hiccup comes along – the transaction log on the primary server grows to a point where the transaction log on the secondary server fills the [...]

Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then possibly a manager or client.  Usually this comes up when evaluating for missing indexes or better indexes. SQL Server provides a means to find the information we seek.  We can [...]

Another Interesting Sort
In October of 2011, I shared an example of a peculiar set of sort requirements.  Today, I am going to share another similar set of requirements.  Based on prior experience, when I saw this request on a sort order, I was sure I could find a simpler solution.  Today, I [...]

Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those cases where you are consulting or you have taken on a new job. Suppose you want/need to find out what SQL Agent jobs are running SSIS packages.  This script will [...]

T-SQL Tuesday #028 – Jack of All Trades, Master of None?
Another month and another opportunity to write about an interesting topic.  This month hosting TSQL Tuesday is Argenis Fernandez (Blog | Twitter). This month, Argenis has invited us to talk about demons from our past.  Ok, not necessarily demons but at least share why you might be a Jack of [...]

Physical or Virtual
Today I get to share something that has been on my someday list for quite some time.  I have planned on getting a solution that involves TSQL to help determine if you are running SQL Server on a physical machine or if it happens to be a virtual machine.  Now, [...]

Views in Use?
Today, I am following up on a topic I mentioned in an earlier post.  In case you haven’t read the post on finding your linked servers, you can read it here. It is in that post that I spoke of altering a script I had just written for another client [...]

Linked Servers
Do you have linked servers that have been created in your environment?  Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means to be able to find the linked servers on each installed instance.  I will show two simple means (that don’t involve [...]

S3OLV – Get your Merge On
We are rapidly closing in on the February meeting for S3OLV.  You might remember reading about the upcoming meeting here. We are looking to have an excellent meeting this month.  We have had a good run on superb presentations, and Troy aims to keep us going in the right direction. [...]

    

Copyright 2005 by SSSOLV.Com   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2012 by Perpetual Motion Interactive Systems Inc.