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

Latest Blog Posts

Make an SSIS package Delay or Wait for Data

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in a SQL table. When the table has data then the…

Read more

0 comments, 34 reads

Posted in Mike Davis SQL on 21 July 2014

Tampa Code Camp Revivial

If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you will see some of the best in the land.  Orlando started SQL Saturday since 2007 with Tampa following closely thereafter.  South Florida has hosted Code Camp for 10 years… Read more

1 comments, 36 reads

Posted in Jason Carter on 21 July 2014

Powershell Tips–Showwindow

Looking for help is a pain in Powershell. I type something like

help get-process

execute this and I’m scrolling up and down. Things scroll off the screen and I have to muddle through, meanwhile, my code is at the bottom of the window.

Even when things stop at the end… Read more

0 comments, 46 reads

Posted in The Voice of the DBA on 21 July 2014

July 2014 – SQL Server Monthly Maintenance Checklist

It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist.  Even though it hasn’t been updated, hopefully people have been continuing to look at their environments and performing the needed monthly maintenance activities.

Doing this is important because if you don’t know where you… Read more

0 comments, 41 reads

Posted in StrateSQL on 21 July 2014

Null Values in SQL Server

Walk & Talk #001 – Unknown or Null Values

Ride with us in this video as we head to Richmond, Virginia to present to their user group.

This is the first official Walk & Talk, but you’ll notice we’re not exactly walking along.

Through this video we talk about and… Read more

1 comments, 44 reads

Posted in WaterOx SQL on 21 July 2014

Last Weeks Top “Reading” Links #93

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 49 reads

Posted in StrateSQL on 21 July 2014

Victims of Success

I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how the sausage gets made. I’ve seen how actual sausage gets made and I still eat sausage.  Despite a few hiccups and communication issues, internal and external, I think the selection… Read more

3 comments, 38 reads

Posted in The Scary DBA on 21 July 2014

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-

Step 1 : First page of Service pack setup. Informatory details only.

Step 2 : Confirm EULA (End User License Agreement) to move ahead.

Step 3 : Select instance & features you want to… Read more

0 comments, 40 reads

Posted in MSSQLFUN on 21 July 2014

Add them to ALL the roles!

I seem to get a lot of permissions questions these days and one of the more frequent ones goes along these lines “I still don’t have the right permissions on database xyq.” So of course the first thing I do is use my handy dandy sp_dbpermissions stored procedure to check… Read more

0 comments, 46 reads

Posted in SQLStudies on 21 July 2014

Speaker Buddy System

SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in our community that are trying to make the jump to a SQL Saturday or any larger event. I think it's a fantastic idea. He brought on a story of a…

Read more

0 comments, 34 reads

Posted in DBA On The Go on 21 July 2014

PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline

Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all DBAs should be doing to work with developers.

Grant Fritchey – Microsoft MVP

July 23, 2014 Noon CST

How to Build a Database Deployment Pipeline.

The pace of business accelerates…

Read more

0 comments, 41 reads

Posted in The Smiling DBA on 21 July 2014

Display All SQL DateTime Conversions

If you want a quick way to determine which format, or style, to specify when converting a datetime value in SQL to a character data type, you can use this simple PowerShell script. Or you can look at the MSDN page.

0..200 | %{

Read more

0 comments, 104 reads

Posted in Eric Humphrey on 18 July 2014

SQLSaturday Orlando–A Message From Last Year Revisited

I was doing some work on the marketing for SQLSaturday Orlando and looked back at the messages we sent last year, and in one those messages I found this under the heading of “Invite a Friend”:

“New to SQL Server? Not new, but never been to one of these events…

Read more

0 comments, 90 reads

Posted in SQLAndy on 18 July 2014

SSC Editorial: What Is the Hardest Feature to Learn About SQL Server?

I wrote What Is the Hardest Feature to Learn About SQL Server? not really knowing what answer to expect. So far no one topic has risen to the top of the list in the discussion. What about you, have you found some part of SQL really hard to learn?

Read more

2 comments, 141 reads

Posted in SQLAndy on 18 July 2014

Reblog: July 11 to July 17

Photo credit – Mike Lynch

A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more

0 comments, 76 reads

Posted in StrateSQL on 18 July 2014

Friday Followup For July 18, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Which One’s Better?
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC To Fix Index Corruption
  • Building (for…

Read more

0 comments, 68 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 18 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, 82 reads

Posted in SQL RNNR on 17 July 2014

Quick Tips–SQL Prompt Aliases for Every Table

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

0 comments, 94 reads

Posted in The Voice of the DBA on 17 July 2014

SSC Editorial: Access Disdain

Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has limitations, but so do most apps that we give to “average” users and the more industrious ones build stuff because that’s the tool they have (when all you have is… Read more

2 comments, 92 reads

Posted in SQLAndy on 17 July 2014

Get SQL Server Info - Quick Tip & Script

There are a number of ways to collect basic information about SQL Server, its version, edition and other top-level properties.  What is the build, and current service pack level? What is the instance name vs. the actual server name?  Is it clustered or stand-alone and is it virtual… Read more

2 comments, 390 reads

Posted in Pearl Knows on 17 July 2014

Older posts