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

Latest Blog Posts

Notes From The October 15, 2014 oPASS & MagicPASS Meeting (The Souza-Thon!)

Both groups met at a special joint meeting last night at Nova University, part of Operation Souza. Before I go into my usual notes, I want to say thank you to Mark Souza for traveling from Redmond for the meeting. He flew overnight to get here and had a 6… Read more

0 comments, 207 reads

Posted in SQLAndy on 16 October 2014

SSRS report rendered in EXCELOPENXML then something went missing

Recently I had been requested by a client to look into one of their SSRS reports issues. They had one report with a text box that contained some padding from the left side. All seems to be OK, report showed indented text values both in RPL and PDF rendering extensions;…

Read more

0 comments, 158 reads

Posted in Data Adventures on 16 October 2014

Learning Options in Seattle Next Month

The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many people attend the conference, there are some additional options for learning that you might think about in addition to the conference itself. While the conference is great, getting deeper dives… Read more

2 comments, 127 reads

Posted in The Voice of the DBA on 16 October 2014

Creating a SharePoint Server Farm on Azure from the Gallery

As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help troubleshoot an issue that was working with SharePoint Excel Services and it couldn’t be done in Office365. So, my first attempt was to grab the SharePoint Server 2013 Trial from… Read more

0 comments, 118 reads

Posted in DataOnWheels on 16 October 2014

Analytics Platform System (APS) AU2 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2), which is sort of like a service pack, except that it includes many new features.  These appliance updates are made available frequently, about every 3-4 months.… Read more

1 comments, 93 reads

Posted in James Serra's Blog on 16 October 2014

Query Performance Tuning in SQL Server

I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query Performance Tuning in SQL Server 2014″ because it seemed like a good idea to bring out the aspects of 2014, and we will. But, I need to tell you,… Read more

0 comments, 101 reads

Posted in The Scary DBA on 16 October 2014

Insufficient Space to Create Databases For SCOM 2012 R2

Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum size of 1000mb and a log of 50% of that – call it 1.5g, and the same for the second one. We made it through the first database config step,… Read more

0 comments, 151 reads

Posted in SQLAndy on 16 October 2014

UNION vs UNION ALL

You might be wondering why I’m going into such a simple subject. Well the way I see it there are four options here.

  • You already know the difference, it seems really obvious and you are probably wondering why I’m mentioning it.
  • You think you know the difference but it turns…

Read more

5 comments, 251 reads

Posted in SQLStudies on 16 October 2014

PASS SQL Saturday Events: November 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, 116 reads

Posted in Marc Beacom on 15 October 2014

Webinar Q&A: SSRS Subscriptions and Data Alerts

Updated 10-16-2014 at 11:20 AM Eastern

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone… Read more

3 comments, 104 reads

Posted in Bradley Schacht on 15 October 2014

I'm an MVP

Hello Dear Reader!  Two weeks ago I was very honored to be named a Microsoft SQL Server MVP.  Since then I've been reflecting on what it means to get this award and the massive amount of people that helped me along the way.

Family, co-workers, friends, community members, and other…

Read more

3 comments, 117 reads

Posted in SQLBalls on 15 October 2014

Networking at the PASS Summit

The 2014 PASS Summit is coming up in a few weeks and thousands of SQL Server professionals will be coming to Seattle for the event. Many will arrive early, and many will be there for the first or second time in their careers.

Many of them will be that guy Read more

1 comments, 138 reads

Posted in The Voice of the DBA on 15 October 2014

Upcoming conferences end of 2014: Microsoft Technical Server Summit, MVP Summit, PASS Summit, Microsoft Technical Summit

 

(DE)
Das Jahresende nähert sich in raschen Schritten. In den nächsten 3 Monaten stehen wieder mehrere Konferenzauftritte an.

(EN)
The end of year is approaching fast. For the next three months, several conferences are scheduled.

Nach der Vorstellung des SQL Server 2014 (SQL Server 2014 - Highlights in…

Read more

0 comments, 400 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 15 October 2014

SSIS Pivot makes you stronger

At the recent Toronto SQL Server User group meeting Michal J Swart (@MJSwart) gave a good presentation based on 10 of his blog posts. There was one (Forget About PIVOT, You Don’t Need It) that got my attention; first, I remembered that I had read…

Read more

0 comments, 112 reads

Posted in Data Adventures on 15 October 2014

PASS Election Results for 2014

The election results were just posted. Congratulations to James Rowland-Jones, Wendy Pastrick, and Grant Fritchey for earning seats on the PASS Board of Directors for the 2015-2016 term. This will be the second term for both James & Wendy, so both will be building on two years hard won experience… Read more

0 comments, 94 reads

Posted in SQLAndy on 15 October 2014

Lync 2013 Video Issues on Windows 8

Part of the reason I have a blog is to document issues and resolutions I do not want to forget. Yesterday morning I was on two calls using Lync and the video was blank or white. I had great audio and messaging worked fine. So the only part that was… Read more

0 comments, 81 reads

Posted in DataOnWheels on 15 October 2014

Thank You: #passvotes

The results are in and it seems that I’ve been elected to a place on the PASS Board.

Thank you.

I will strive to be worthy of the position you’ve placed in my hands. I will do my best to make a difference on the board. Watch this space for… Read more

8 comments, 88 reads

Posted in The Scary DBA on 15 October 2014

Tracking down CPU spikes using process explorer and DMVs

What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just shutting down the last applications when a call or a… Read more

2 comments, 3,442 reads

Posted in Ctrl-alt-geek on 15 October 2014

Can’t Create A Timeline in Excel on Multidimensional Cube

Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.

After getting excited about the Timeline object in Excel 2013, I tried to add this cool feature of Excel 2013 and got an error – “We can’t create a Timeline… Read more

0 comments, 82 reads

Posted in The Smiling DBA on 15 October 2014

Hell No, DMO - DMV is what it shall be!

So, I've finally decided to draw a line in the sand.  I've been doing some writing lately.  The radio silence will soon be broken in a big and "healthy" way.  In the meanwhile, I've got caught up in naming antics, and what we should really be calling them. There may… Read more

0 comments, 100 reads

Posted in Pearl Knows on 15 October 2014

Newer posts

Older posts