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

Latest Blog Posts

Understanding Analysis Services Relationships using Dimension Usage

As a part of designing an Analysis Services cube you must define how each dimension is related to each measure group in your cube through the Dimension Usage tab.  The Dimension Usage tab is found when editing the cube in the cube designer.  The screenshot below shows dimensions on rows… Read more

0 comments, 193 reads

Posted in Devin Knight on 15 July 2014

PASS SQL Saturday Events: August 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most… Read more

0 comments, 131 reads

Posted in Marc Beacom on 15 July 2014

Execution Plan Details

I wouldn’t say it’s common knowledge that you should look at execution plans when tuning queries, but it’s not exactly uncommon knowledge either. But, people tend to get focused on just looking at the graphical part of the plan and there’s just not enough information there. Let’s take a look… Read more

1 comments, 8,997 reads

Posted in The Scary DBA on 15 July 2014

Building the SQLSaturday Orlando Marketing Plan-Part 22

  • Had our second planning meeting, still trying to complete the email template and realized we had not clearly defined two tasks for this week; finish the template and send out the first promo for the seminars. Easy to get it jumbled on a call, should have caught it in the…

Read more

0 comments, 98 reads

Posted in SQLAndy on 15 July 2014

Merge csv files – quick PowerShell snippet

During a bit of work I’ve been doing this evening for SQLRelay 2014 I used something I have in my arsenal of PowerShell scripts which I thought I’d share because I love it’s simplicity :) It’s nothing big and fancy but something that is extremely useful. Tasked with merging a… Read more

0 comments, 176 reads

Posted in Chris's SQL Blog on 14 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

0 comments, 100 reads

Posted in SQL RNNR on 14 July 2014

SSC Editorial: Infect Your Colleagues with the Learning Bug

If you work with colleagues that aren’t as interested in growing and learning as you are, I hope you’ll read Infect Your Colleagues with the Learning Bug. It’s both a how-to and a caution against pushing too hard. It’s an interesting topic, I’ll be curious to see the tone… Read more

0 comments, 105 reads

Posted in SQLAndy 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, 98 reads

Posted in SQL RNNR on 14 July 2014

Whitelist a Set of IP Addresses in SQL Server

Blacklist vs Whitelist

Are you on the Whitelist?

I think just about everyone is familiar to some degree with the concepts of a blacklist and whitelist.

If not, the easiest way I can summarize them is as follows:

A blacklist is a list of what can not access something you… Read more

1 comments, 139 reads

Posted in WaterOx SQL on 14 July 2014

Last Weeks Top “Reading” Links #92

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, 19 reads

Posted in StrateSQL on 14 July 2014

Some Ideas for Meeting Sponsors

Most PASS Chapter meetings are supported by sponsors who either provide money which is often used for food and drink, or sometimes bringing the food, or picking up the check at a nearby restaurant for the “after” event. In return sponsors get a mention in the meeting opening and if… Read more

0 comments, 91 reads

Posted in SQLAndy on 14 July 2014

End of Mainstream Support for Microsoft SQL Server 2008 and 2008 R2



@DBA_ANDY: A reminder to all #sqlserver peeps out there and *especially* to our clients: #sql2008 #sql20008R2 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/09/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2.aspx#Ntirety


--

What does this mean?

The key takeaway comes from this section of the MSDN blog:

For both SQL Server 2008 and SQL Server 2008 R2, Microsoft will continue…

Read more

0 comments, 134 reads

Posted in Nebraska SQL from @DBA_ANDY on 14 July 2014

What does it mean that a value is NULL?

Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be going over that in some detail in a future post. However Microsoft tells us that ANSI_NULLS will always be ON in the near future. So we are not going to… Read more

9 comments, 9,496 reads

Posted in SQLStudies on 14 July 2014

My upcoming speaking schedule

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Over the next weeks and months I have an incredible speaking schedule around the whole world. You… Read more

0 comments, 112 reads

Posted in Klaus Aschenbrenner on 14 July 2014

Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2

Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result no enchantment or no future release of SPs. Somehow, Critical bug fixes may be release as QFE etc.

This sequence stop with SQL Server 2008 Service Pack 3 CU16 and… Read more

0 comments, 108 reads

Posted in MSSQLFUN on 14 July 2014

How to restore MSDB & MODEL database – SQL Server System Databases?

The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. Issues in MSDB restore that may result loss of all scheduling information, as well as the backup and restore history. You… Read more

0 comments, 232 reads

Posted in MSSQLFUN on 14 July 2014

Reblog: July 4 to July 10

Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more

0 comments, 18 reads

Posted in StrateSQL on 11 July 2014

Free Ebooks From Microsoft

2 comments, 257 reads

Posted in SQLAndy on 11 July 2014

Notes from the July 2014 ONETUG Meeting

  • Rained as I left (early) for the meeting, confirming again why I always leave early – stuff happens (in Orlando, rain = commute time * 1.5 or more)
  • New location for ONETUG in the Orlando Public Library downtown, public parking garage directly across the street ($2/hour)
  • Meeting was on the…

Read more

2 comments, 101 reads

Posted in SQLAndy on 11 July 2014

Speaker of the Month, July 2014

Another month another bunch of great presentations. I almost don’t want to do this any more. It’s hard. I sit through a presentation and I think, “Well, here’s the winner this month.” Then I go to another presentation and I think, “Well, fudge, now one of these people loses.” Then… Read more

0 comments, 114 reads

Posted in The Scary DBA on 11 July 2014

Newer posts

Older posts