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

SQL Table Columns Disappear in Access

A couple weeks ago a user complained that on one of our development databases, one of the views he was linking to via Access was missing some of the columns.  There were no permissions issues and the columns all showed up properly if they looked at the view via SSMS;… Read more

0 comments, 710 reads

Posted in Never Say Never on 28 September 2011

Replication DDL Triggers

Because this was a problem that Google was zero help on and I did find a couple other people afflicted with it, I figured I’d write a post about it. 

The issue was this.  I add a table to replication (SQL Server 2005).  The option to replicate DDL changes is… Read more

1 comments, 769 reads

Posted in Never Say Never on 21 September 2011

Normalize your Linked Server Names

This is a technique I’m sure many people are already using in their environments.  Instead of using the actual name of your SQL Server as the name of the linked server that you call, use a generic name.  For instance.  If you have a couple of servers named SQLSales02 and… Read more

10 comments, 1,379 reads

Posted in Never Say Never on 14 September 2011

SSMS Tips & Tricks – Registered Server Groups

Here are a couple more SSMS tricks I’ve stumbled upon recently.  Both involve the functionality of registered servers.  If you really only deal with 1 or 2 servers in your environment, these probably won’t help you out much.  But for those of us who have to deal with a large… Read more

1 comments, 887 reads

Posted in Never Say Never on 17 April 2011

SSMS Tips & Tricks – Scripting Multiple Objects

This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office, I was surprised to find that many people had never seen this before.  If you just click on objects in the object explorer, you can’t hold shift to select multiple… Read more

2 comments, 599 reads

Posted in Never Say Never on 2 April 2011

SSMS Tools Pack – Script Grid Results

Most of us like things that make our lives easier.  When they’re free, it’s just that much sweeter.  I would have sworn I’d done a post or two on SSMS Tools Pack before, but apparently this one has slipped through the cracks.  No Longer!

SSMS Tools Pack is a free…

Read more

3 comments, 527 reads

Posted in Never Say Never on 13 February 2011

SSMS Tips and Tricks – ALTernative Highlighting

This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share this as I haven’t seen it written about in many places and I find it quite handy on a regular basis.  If you hold down the ALT key in SSMS… Read more

7 comments, 576 reads

Posted in Never Say Never on 7 February 2011

2011 Goals

Last year I posted professional goals along with quite a few other bloggers and it helped to keep me somewhat focused on them (for at least the beginning of the year).  I am going to do so again in the hopes that I do even better this year.  My goals… Read more

1 comments, 294 reads

Posted in Never Say Never on 23 January 2011

2010 Goals Review

So… this is late.  And I missed my q3 goals review all together.  Oh well, not much I can do to fix that now other than push on and try to do better next time.  For the first two quarters, I was looking pretty good for completing my goals, but… Read more

2 comments, 280 reads

Posted in Never Say Never on 23 January 2011

Going to SQL Saturday #46 in Raleigh, NC

So, after a rather hectic few months, I’m finally crawling back out of the hole I’ve been occupying and getting back to blogging. This Saturday (September 18th, 2010), I’ll be headed to the SQL Saturday here and am very excited about getting to put a face to the names of… Read more

0 comments, 295 reads

Posted in Never Say Never on 16 September 2010

July SCSUG Meeting

First, I wanted to post a reminder that the July SCSUG meeting has been moved to this coming Monday, July 12th in order to accommodate the schedule of our speaker, David Pless.  As normal, the meeting will take place at the SCCU HQ on Wickham Road.  This will be David’s… Read more

0 comments, 222 reads

Posted in Never Say Never on 8 July 2010

SQL Spatial data for State/County shapes

I saw a Blog post by Grant Fritchey (Blog | Twitter) a couple days ago on using Geospatial data in SSRS 2008 R2.  I think this is incredibly cool and it reminded me of something I wanted to share about my own recent experiences with geospatial data.  My… Read more

1 comments, 759 reads

Posted in Never Say Never on 18 June 2010

June SCSUG Meeting Follow-up

This is a bit later than usual as the meeting was a week ago now, but I wanted to post it anyways to thank SCSUG member Don King for stepping in on short notice to fill a hole in our speaker schedule.  Even though he didn't have a lot of… Read more

0 comments, 258 reads

Posted in Never Say Never on 18 June 2010

2010 Goals – Q2 Review

Another quarter gone, and unfortunately I’m still looking about the same on goal progress.  Still looking good on Blog posts and networking, still a bit behind on forum posts and still abysmally behind on the Learning goals. 

On the bright side, the learning goals are something that I can knock… Read more

7 comments, 341 reads

Posted in Never Say Never on 10 June 2010

T-SQL Tuesday #7: T-SQL Enhancements in SQL 2008.


In this edition of T-SQL Tuesday, Jorge Segarra (Blog | Twitter) asks us what our favorite new feature of SQL 2008 or 2008 R2 is.  I've decided to focus on the T-SQL and query writing enhancements of 2008.  Before I do so though, let me preface… Read more

0 comments, 380 reads

Posted in Never Say Never on 8 June 2010

Calculating ROI on Performance Tuning

Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they have saved the company with their performance tuning.  I've often struggled with this myself, and so I started thinking about it a bit deeper.  I started to respond in the… Read more

1 comments, 282 reads

Posted in Never Say Never on 2 June 2010

Create Indexes from the Missing Indexes DMV

Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s.  One of them in particular I found extremely helpful in fixing some of the issues in my system.  I took his query (the CTE at the top) and added some text manipulation to… Read more

6 comments, 779 reads

Posted in Never Say Never on 24 May 2010

Upcoming May SCSUG Meeting

This coming Thursday is the SCSUG meeting.  This is no normal meeting.  Instead of the standard format of pizza/socialization followed by a single speaker who will cover a topic for 1.5-2 hours, we are going to have not 1… not 2… but 6 speakers.  Each speaker will cover a topic… Read more

1 comments, 310 reads

Posted in Never Say Never on 10 May 2010

2008 Upgrade Completed

Whew!  So I've been super busy the past week and a half upgrading our production server from SQL 2000 to SQL 2008 and haven't had time for any new posts.  Finally starting to see everything calm down again though and running smoother than ever before.  I had hoped to do… Read more

1 comments, 313 reads

Posted in Never Say Never on 26 April 2010

T-SQL Tuesday #005: Monitoring Reports with SSRS

This post is a T-SQL Tuesday Entry, hosted this week by Aaron Nelson on the topic of “Reporting”.  (It got a little long.  Ordinarily I’d have broken this up into a series and fleshed out individual pieces a bit better, but this touches on most of the general points) Read more

4 comments, 379 reads

Posted in Never Say Never on 13 April 2010

Older posts