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

Latest Blog Posts

SQL Server Diagnostic Information Queries for April 2014

I made some small improvements to a few of the queries this month. I plan to add several more SQL Server 2014 specific queries over the next couple of months, along with a lot more comments on how to interpret the results of each query in the entire set.

Rather…

Read more

0 comments, 18 reads

Posted in Glenn Berry's SQL Server Performance on 18 April 2014

Friday Followup For April 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

  • Why So Serious? – #TSQL2sDAY #53
  • Do You Need A Log Recovery Tool?
  • Cheating DBCC To Fix Index…

Read more

0 comments, 23 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 18 April 2014

MDS: A Database Error Has Occurred

I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS:

515: A database error has occurred. Please contact your system administrator

Too bad I am the system administrator on that machine…

Anyway, after some searching it came… Read more

0 comments, 31 reads

Posted in Koen Verbeeck on 18 April 2014

Bringing Power BI Q&A to your Organization Recording and Q&A

I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014.  If you weren’t you can now watch the recording here.

Traditionally following a webinar I try to post a quick Q&A session for everything I was not able… Read more

0 comments, 48 reads

Posted in Devin Knight on 17 April 2014

What is the Microsoft Analytics Platform System (APS)?

Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW).  It is not really a new product, but rather a name change due to a new feature in Appliance Update 1 (AU1) of PDW.  That new feature is the ability to have a HDInsight region… Read more

1 comments, 66 reads

Posted in James Serra's Blog on 17 April 2014

Why does my Failover Cluster Instance Keep Failing Back and Forth?

A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing multiple failovers when they performed routine Windows patching.

The client's request which generated the work ticket was this:

At some point recently this clustered node failed over from the A…

Read more

1 comments, 59 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 April 2014

oPASS Tonight! (April 17, 2014)

I’m presenting tonight at oPASS, two presentations worth! If you’re in Orlando I hope you’ll attend, details at http://orlando.sqlpass.org/.

Read more

0 comments, 57 reads

Posted in SQLAndy on 17 April 2014

SSMS Auto Recovery

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

SQL Server Management Studio will autosave your unsaved query every few minutes so if if your pc…

Read more

0 comments, 42 reads

Posted in The SQL DBA in the UK on 17 April 2014

Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!

SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM is much easier and seamless now.

This post talks about the journey of a database named “MoveMeToCloud” which is hosted on SQLServer 2014 RTM on-prem instance to a SQL Instance… Read more

0 comments, 71 reads

Posted in SQLSailor.com on 16 April 2014

FileTable–Adding a file to a folder

At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy enough, I thought, since I’d seen someone do this in .NET and was thinking this has to be simple. Turns out it’s not quite so simple.

I was assuming that… Read more

0 comments, 98 reads

Posted in The Voice of the DBA on 16 April 2014

Kevin Kline at MagicPASS Tonight (April 16, 2014)

Kevin Kline is speaking at MagicPASS tonight – on two topics! If you’re in the Orlando area I hope you’ll try to attend – Kevin is a top notch speaker, you won’t be disappointed.

Read more

0 comments, 61 reads

Posted in SQLAndy on 16 April 2014

Microsoft Azure Automation

Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it here. It’s a mechanism to create runbooks using PowerShell that you can then combine with other runbooks inside a runbook, etc. Let’s check it out. I’m doing everything you… Read more

2 comments, 97 reads

Posted in The Scary DBA on 16 April 2014

Nothing Scheduled

As of right now, my United account has no flights booked. My Hilton Honors account has no hotel rooms reserved. My National account has no car rentals to pick up.

And I have nothing scheduled for the rest of 2014.

For now. I suspect things will change soon, but… Read more

0 comments, 73 reads

Posted in The Voice of the DBA on 16 April 2014

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes up a stupid question and what… Read more

7 comments, 99 reads

Posted in SQLStudies on 16 April 2014

From where does SSMS get its database defaults?

We can create a database simply by typing in the command

create database DB1 



We don’t have to provide any other parameters for SSMS to be able to create the database

My Question is from where does SQL get the default values when we create a database without any options?

Read more

0 comments, 81 reads

Posted in The SQL DBA in the UK on 16 April 2014

From Zero to Pull Request with Git on Windows

I wrote a guide about using Git and GitHub for "Windows people".

This is the guide I wish was available when I got started with Git last year.

The guide takes you through everything you need to know to get started with Git and GitHub, and only requires a Windows… Read more

0 comments, 57 reads

Posted in New York City .NET on 16 April 2014

Top 50 .Net Framework Interview and General FAQs....


Q 1 What Is CLR? 

CLR is a runtime environment. Code that we develop with language compiler that targets the runtime is called managed code. Programmers write code in any .Net language, compile their programs into IL in a portable executable file that can then be managed and executed by…

Read more

0 comments, 101 reads

Posted in Querying Microsoft SQL Server on 16 April 2014

SQL Saturday Chicago

My company, Heraflux Technologies is proud to partner with Yucca Group to sponsor this year’s SQL Saturday Chicago, a free one-day event for SQL Server professionals. The event is being held at DeVry University in Addision, IL, on Saturday, April 26th. For more details and to get registered,… Read more

0 comments, 115 reads

Posted in Technobabble by Klee from @kleegeek on 16 April 2014

MDX # 40 – CROSS JOIN does not return Cartesian product of two hierarchies from the same dimension

Cartesian product can be illustrated by a Cartesian square

Most SQL developers are familiar with the concept of CROSS JOIN and Cartesian product. Cartesian product is the result that is produced from a CROSS JOIN.

In this Wikipedia article, Cartesian product, a Cartesian product is illustrated by a Cartesian… Read more

0 comments, 68 reads

Posted in Sherry Li's BI Corner on 15 April 2014

MDX # 39 – Find Default Measure using MDX Query

In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a hierarchy in the MDX script” to show three places where you can set up Default members for hierarchies.

For more information about how to define a default member for… Read more

0 comments, 65 reads

Posted in Sherry Li's BI Corner on 15 April 2014

Older posts