Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

September 2014 Las Vegas UG Meeting

Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours of PASS (Summit Preview), we have more training in store for you from the people in Las Vegas. Let’s call this a preview for next week which happens to be… Read more

0 comments, 82 reads

Posted in SQL RNNR on 10 September 2014

T-SQL Tuesday #58 – Security Phrases

Today is once again TSQL Tuesday.  This month the event and topic are being hosted by Sebastian Meine (blog | twitter).  You can read all about the topic this month on his blog inviting all to participate.

Despite Sebastian being a real cool kid, I was not too… Read more

0 comments, 4,270 reads

Posted in SQL RNNR on 9 September 2014

Effects of sp_rename on Stored Procedures

There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure.  When a mistake such as that happens, we are given a few choices.  One could either rename the stored procedure, drop and recreate the… Read more

0 comments, 6,905 reads

Posted in SQL RNNR on 14 August 2014

SQL Server UG in Vegas August 2014 Meeting

 

Another Great meeting and topic is coming to the folks in Las Vegas.  This month we have had the luck of finding Mike Fal (blog | twitter) step up and fill our speaker void.

Yes, it happens to be the second Thursday of the month already.  Being… Read more

0 comments, 87 reads

Posted in SQL RNNR on 14 August 2014

T-SQL Tuesday #57 – SQL Family and Community

Look at that, it is once again that time of the month that has come to be known as TSQL Tuesday.  TSQL Tuesday is a recurring blog party that occurs on the second Tuesday (most generally) of the month.  This event was the brainchild of Adam Machanic (Blog |… Read more

1 comments, 105 reads

Posted in SQL RNNR on 12 August 2014

Virtual Box is TOO Small

I have been working on upgrading my laptop.  Since my laptop housed a bunch of my virtual machines for various presentations and labs, that means also upgrading and/or converting my virtual machines.

The new laptop is Windows 8.1.  With the new laptop I was interested in converting a bunch of… Read more

0 comments, 332 reads

Posted in SQL RNNR on 5 August 2014

Presenting at PSSUG

 

Coming up this week, I have been given the opportunity to do something I enjoy doing.  I have been invited to present to the folks in Philadelphia.

Sebastian Meine (blog | twitter) approached me during SQL Saturday in Philadelphia and I was happy to help where I… Read more

0 comments, 116 reads

Posted in SQL RNNR on 4 August 2014

Murder in Raleigh

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it… Read more

0 comments, 6,958 reads

Posted in SQL RNNR on 4 August 2014

Please open this page in the Admin panel only

I am taking a slight deviation from the usual type of posts that I share.  This time, I just want to share a quick and easy fix that I ran across due to a broken blog site that lasted for about a day starting on July 28th.

I didn’t even… Read more

0 comments, 138 reads

Posted in SQL RNNR on 30 July 2014

Top 10 Recommended Books…

So the title says it all, right?  Well, only really partially.

Recently an article was published listing the top 10 most recommended books for SQL Server.  That’s the part the title doesn’t say.  It is really important to understand that we are talking about the top 10 recommended books for… Read more

0 comments, 190 reads

Posted in SQL RNNR on 29 July 2014

SSIS: Value does not Fall Within the Expected Range

Every now and again I find myself working with SSIS for one reason or another.  Every now and again I find myself fighting with SSIS because it provides less than useful error messages.  This is one of those error messages that can be a pain until you understand what can… Read more

0 comments, 8,037 reads

Posted in SQL RNNR on 17 July 2014

Murder In Denver

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it… Read more

1 comments, 131 reads

Posted in SQL RNNR on 14 July 2014

The SQL Sac wrap!!

Every SQL Saturday leaves a mark of some sort.  This time around, the folks in Sacramento have really helped leave a BIG mark.
That’s right, this last weekend was SQL Saturday in Sacramento Ca.  You might have seen my announcement about it here.

This event had a lot of… Read more

3 comments, 128 reads

Posted in SQL RNNR on 14 July 2014

Is your Team Willing to Take Control?

The calendar tells us that once again we have reached the second tuesday of the month.  In the SQL Community, this means a little party as many of you may already know.  This is the TSQL Tuesday Party.

This month represents the 56th installment of this party.  This institution was… Read more

0 comments, 123 reads

Posted in SQL RNNR on 8 July 2014

Free SQL Training In Sacramento

In a few short days the newest SQL Saturday event.  This one will be on the far West coast of the United States.

This marks the first time for me to present at a SQL Saturday so far West.  From where I live, I have had to travel East for… Read more

1 comments, 121 reads

Posted in SQL RNNR on 7 July 2014

Using Synonyms to Extend SSIS

There are a million and one uses for synonyms.  There are at least that many uses for SSIS.  The reality is, not all of those uses are good for you nor for your data nor for your database.

Recently I wrote an article about some good and some bad with… Read more

0 comments, 259 reads

Posted in SQL RNNR on 3 July 2014

Auditing and Event SubClasses

A recent discussion got me to thinking about Auditing.  To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields related to auditing as it stands in SQL Server.

In talking to the person who raised the valid concern about the… Read more

0 comments, 864 reads

Posted in SQL RNNR on 28 May 2014

Can you partition a temporary table?

Reading that title, you might sit and wonder why you would ever want to partition a temporary table.  I too would wonder the same thing.  That withstanding, it is an interesting question that I wanted to investigate.

The investigation started with a fairly innocuous venture into showing some features that… Read more

4 comments, 1,385 reads

Posted in SQL RNNR on 23 May 2014

Supported Compatibility Levels in SQL Server

It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in a compatibility mode.  This setting is something that can be configured on the database properties level.  You can quickly change to an older compatibility level or revert the change to… Read more

1 comments, 709 reads

Posted in SQL RNNR on 21 May 2014

Missing Indexes Script v2

Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them are good (some may stink).

Well, this may just be another one of those <items>.  Whether it stinks or not may depend on your mileage.

I had shared a similar… Read more

8 comments, 2,500 reads

Posted in SQL RNNR on 15 May 2014

Older posts