|
|
Register Now.
|
 |
|
Registered users have access to Current and Previous meeting agendas Discussions, Cool Websites, Job Opportunities, and Snippets.
Register today, it's Free!
|
|
|
|
Sponsors
|
 |
|
|
|
|
|
|
SELECT TOP 1 * FROM WelcomeMessage ORDER BY UpdateDate DESC
|
 |
|
Next Meeting
May 10, 2012 6:00-8:00pm PDTWe 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
|
 |
|
|
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! |
|

|

|

|
|
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
|
 |
|
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. [...]
|
|
|