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

Latest Blog Posts

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, 237 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, 97 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, 125 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, 352 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, 729 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, 140 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, 133 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, 86 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, 562 reads

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

PASS SQLSaturday Events: May 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, 74 reads

Posted in Marc Beacom on 15 April 2014

Farewell Brook Ranne

For members of the SQL community in Orlando and Chicago you’ve probably heard that Brook Ranne died on March 29, 2014. Brook was part of our group here in Orlando, someone growing into SQL Server and always ready to volunteer, especially at SQLSaturday Orlando and Tampa where she was almost… Read more

3 comments, 97 reads

Posted in SQLAndy on 15 April 2014

Why a Boot Camp?

As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of weeks since I announced this I’ve had a few questions as to why I am offering a boot camp Read more

1 comments, 111 reads

Posted in WaterOx SQL on 15 April 2014

Parallel Data Warehouse (PDW) AU1 released

Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason is due to frequent upgrades to the hardware and software.  About every six months there is an appliance update, which is sort of like a service pack, except that in… Read more

1 comments, 170 reads

Posted in James Serra's Blog on 15 April 2014

SQLServerCentral Editorial: Doing What It Takes To Get The Job Done

I wrote Doing What It Takes To Get The Job Done about a conversation with my nephew working late to finish up some work. The comments so far are interesting and reflect the challenge of phrases like “get the job done” that can all to easily be abused into excuses… Read more

0 comments, 76 reads

Posted in SQLAndy on 15 April 2014

Writing a Question Of The Day–More Notes

Today I wrote another question based on an error message. I included the error message in the question this time and it’s reasonably helpful, but the question text will, depending on how you read it, point you to the one good answer or convince you the answer must be somewhere… Read more

0 comments, 64 reads

Posted in SQLAndy on 15 April 2014

SQL Server First Aid

If you take basic first aid, say a CPR course, you’ll learn a handy mnemonic for the primary assessment you have to make, A-B-C. That breaks down as Airway, Breathing, Circulation. Is there an open airway so they can breathe? Are they breathing? Do they have circulation, a pulse, are… Read more

11 comments, 108 reads

Posted in The Scary DBA on 15 April 2014

[SQL Snacks Video] SQL Server Table Partitioning 102

Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first video, I would highly encourage you to do so. In this second video I will discuss the following: Creating a new Range in our Partition for new data (SPLIT RANGE)…

Read more

0 comments, 126 reads

Posted in - Ayman El-Ghazali on 15 April 2014

Overview of Published Articles – 2014Q1

Since I write at different places – this blog, Intense School and - someone recently asked me if I could provide an overview from time to time to keep track of all the published material. It makes it easier to follow and it’s also a chance for me to… Read more

0 comments, 59 reads

Posted in Koen Verbeeck on 15 April 2014

A ever-increasing Clustered Key value doesn’t scale!

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

You know all the best practices how to choose a Clustered Key value? A good… Read more

13 comments, 97 reads

Posted in Klaus Aschenbrenner on 15 April 2014

SQL Server 2000 || Disable sa login

Question : How to disable sa user in SQL Server 2000?

Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2.

Answer : We can disable sa user from SQL Server 2005 onwards… Read more

0 comments, 65 reads

Posted in MSSQLFUN on 15 April 2014

Newer posts

Older posts