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

Latest Blog Posts

DBTA – Big Data and Microsoft SQL Server HDInsight


It’s time to follow up with a discussion of Microsoft’s cloud-centric approach to big data using HDInsight.


HDInsight is a 100% Apache Hadoop service, currently at v2.2, available through Microsoft’s Windows Azure cloud offerings. HDInsight makes all of the standard… Read more

0 comments, 0 reads

Posted in Kevin E. Kline on 22 December 2014

Formatting Durations in SSAS: Caveat

I recently published an article on titled Format Durations in SQL Server Analysis Services. For those who haven’t read it I’ll summarize it quickly: it explains how to create an MDX formula that formats durations into an [hh]:mm:ss format, where [hh] can go over 24 hours. For more… Read more

0 comments, 28 reads

Posted in Koen Verbeeck on 22 December 2014

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of RPC in cluster” ?

The Remote Procedure Call (RPC) [] system service is an interprocess communication (IPC) mechanism that enables data… Read more

1 comments, 53 reads

Posted in MSSQLFUN on 22 December 2014

[OT] Blog is in maintenance mode

I’m spending part of this holiday break repaying some technical debt on my website.  Among other things, I am importing some old content that I never brought over when I did my migration to WordPress a few years ago.  Most of the content I’m bringing over is old (most of… Read more

0 comments, 59 reads

Posted in Tim Mitchell on 21 December 2014

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer.  What is it and why is it important?  The most significant thing about it is that report and dashboard users do not need to have Excel 2013 ProPlus edition or an Office 365 subscription to…

Read more

0 comments, 110 reads

Posted in SQL Server BI Blog on 20 December 2014

SQL #55 – Data Types and Storage Reference

When we design a database, we usually need to do an estimate on the size of the database based on the dimension and fact tables.

Keep the following information handy next time when you need to do so.

The lists are based on this article:

SQL Server 2012 Data Types Read more

0 comments, 73 reads

Posted in Sherry Li's BI Corner on 19 December 2014

Quick Audio Switching

I’ve got a semi complicated desktop setup, with multiple monitors, lots of USB stuff, and a few ways to record and listen to sound. I hadn’t thought of things as complex, especially with regards to audio, but between recording podcasts, having regular video conferences, and the speakers I added to… Read more

0 comments, 94 reads

Posted in The Voice of the DBA on 19 December 2014

First Ask “Why”, then Ask “How”


A common refrain we hear when presenting at technical conferences and training events is “How can I get promoted into IT management?” We hear this so often that we’ve worked out a sort of mental flowchart for the subsequent dialog. (We are IT people after all). And our exploratory… Read more

0 comments, 63 reads

Posted in Kevin E. Kline on 19 December 2014

I am joining SQLskills

I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to join an incredible team of SQL Server professionals and continue growing in my SQL career.  I am very excited to be working with some of the best in the industry… Read more

7 comments, 73 reads

Posted in Tim Radney - Database Professional on 19 December 2014

Reblog: December 12 to December 18

Photo credit – Travis

Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more

0 comments, 59 reads

Posted in StrateSQL on 19 December 2014

“Pretty Plans vs. Performance” or “Grant Gets Pwned”

If you get an execution plan that looks like this:

I wouldn’t blame you for immediately thinking about query tuning. Especially if the code that generated it looks like this:

SELECT  soh.OrderDate,
FROM    Sales.SalesOrderHeader AS soh
INNER JOIN Sales.SalesOrderDetail AS sod
        ON sod.SalesOrderID = soh.SalesOrderID
WHERE   soh.SalesOrderID IN…

Read more

2 comments, 84 reads

Posted in The Scary DBA on 19 December 2014

XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t know or need to know the attribute names. By using this axis you can access all of the attributes within the given context node. The specific scenario I had was… Read more

0 comments, 50 reads

Posted in SQL Server Rocks! on 19 December 2014

Whats New 2014

Hey all, Continue to my whats New series,  I will try to write blog a day for whats new is 2014 as well. I am going through its new features and the more I am reading it it impresses me a lot. … Continue reading

Read more

0 comments, 77 reads

Posted in Vinay Thakur on 19 December 2014

Friday Followup For December 19, 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

  • sp_BackupDatabases v1.3
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Building (for FREE)…

Read more

0 comments, 66 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 19 December 2014

Offer – Any e-book for $5

Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5 (£3.60 in British money).

This includes my book, Getting Started with SQL Server 2012 Administration 

The offer will run from Thursday 18th Dec 2014 to Tuesday 6th Jan 2015,… Read more

0 comments, 69 reads

Posted in The SQL DBA in the UK on 19 December 2014

Nominated for the 2014 Tribal Awards

Just like last year, and Simple Talk are hosting the Tribal Awards. In their words:

The Tribal Awards, co-hosted by Simple-Talk and SQLServerCentral, seek to recognize outstanding members of the SQL community. We want to highlight people who are currently leaders due to their writing, speaking, or general community…

Read more

0 comments, 72 reads

Posted in Koen Verbeeck on 18 December 2014

PASS – Connect, Share and Learn

The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what does this mean to me and the SQL Server professionals I have meet in this community (#SQLFamily)?


First, I connected. Where did that start? SQLServerCentral.Com (SSC). I started… Read more

0 comments, 73 reads

Posted in The Smiling DBA on 18 December 2014

Conferences & Presentations of 2014 in Review

Reviewing the year 2014, I can see that I have truly started improving my life by lowering the number of conferences attended & lowering the number of presentations delivered. I am also hoping that I have lowered the number of…

Read more

0 comments, 82 reads

Posted in Niko's blog on 18 December 2014

SQL Konferenz

I’ve spoken at lots of events, but all in the US and the UK. Next year I get my first talk outside of those locations, going to the SQL Server Konferenz near Frankfurt, Germany.

The agenda is up, and I’ll be talking testing and tSQLt there, and it’s cool to… Read more

0 comments, 133 reads

Posted in The Voice of the DBA on 17 December 2014

SSIS #118–Is it an OLEDB or an SMO Server Connection?

OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every task in Integration Services can use an OLEDB connection. As a matter of fact, it’s a preferable client to use if your backend is SQL Server.

However, there is one… Read more

0 comments, 93 reads

Posted in Sherry Li's BI Corner on 17 December 2014

Older posts