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

Archives: May 2013

Power View for Multidimensional Models Released

As a followup to my blog Power View for Multidimensional Models – Preview Available, the final version is now available via SQL Server 2012 Service Pack 1 Cumulative Update 4.

So you can now create Power View reports against multidimensional models (the initial release only worked against tabular… Read more

0 comments, 854 reads

Posted in James Serra's Blog on 31 May 2013

PC Sales Declining

About 3 or 4 years ago I was talking with my wife and a colleague of hers that worked in the mobile industry. This person and my wife thought that the mobile industry would explode, and it’s impact and expansion would dwarf the PC revolution that had most of our… Read more

2 comments, 389 reads

Posted in The Voice of the DBA on 31 May 2013

Hear the SQL Server 2012 story on DotNetRocks

I was privileged to have a chat with my buddies over at www.dotnetrocks.com, Carl Franklin and Richard Campbell, episode number 876 (876!). Listen to the most popular internet audio talk show for .NET developers!  Here’s the abstract:

Carl and Richard talk to Kevin Kline about the latest features in SQL… Read more

0 comments, 286 reads

Posted in Kevin E. Kline on 31 May 2013

Thoughts About The Nail

The other day Grant Fritchey (Blog | @GFritchey) linked out the video below.  It’s a quick little video, that isn’t about the nail.  As I watched it, it spoke volumes to me from both personal and professional experiences.  Check it out quick and then I’ll continue this blog… Read more

5 comments, 303 reads

Posted in StrateSQL on 31 May 2013

Reblog: May 24 to May 30

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 279 reads

Posted in StrateSQL on 31 May 2013

TSQL Snippet for viewing basic info on database principals and their permissions

Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a role.

/*******************************************************
Some Basic Info on Database principals, permissions, 
explicit permissions, and if role, who is in this role currently
*******************************************************/
;
with
	roleMembers
	as (
			select
				drm.role_principal_id
				,dp.principal_id
				,dp.name…

Read more

0 comments, 433 reads

Posted in BIT Barbarian on 31 May 2013

SQL and Relational Theory

Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the Microsoft label, T-SQL is a Microsoft flavour of the more standard ANSI and ISO version of SQL which is based on a branch of mathematics called Relational Model. Relational Model…

Read more

0 comments, 87 reads

Posted in Terry's Business Intelligence on 31 May 2013

Building a SharePoint 2013 BI Demo Environment Part 2 – Building the VM

In this blog post I’ll explain how I build the VM and VHD for my virtual demo environment. I use Hyper-V locally on my Windows 8 OS to run my virtual environment. If you have Windows 8 Enterprise, Hyper-V is a feature you can simply enable in the control panel. Read more

0 comments, 485 reads

Posted in Koen Verbeeck on 31 May 2013

Exploring a Database in Azure

After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied my attention: a public Adventureworks database.

As we noted, Red Gate and SQLServerCentral agreed to host the database and cover costs. Once Jamie Thomson transferred the database to my subscription,… Read more

2 comments, 593 reads

Posted in The Voice of the DBA on 30 May 2013

SQL- Setup and Configure Backup Report – Step by Step Approach – All listed SQL Instances

One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying to give more information with this post also including Step by Step procedure to setup and configure backup report.

This is going to be a continuation of my previous post… Read more

0 comments, 372 reads

Posted in PowerSQL By Prashanth Jayaram on 30 May 2013

Security Questions: TRUNCATE TABLE Permissions

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I’ve opted… Read more

5 comments, 369 reads

Posted in StrateSQL on 30 May 2013

Ralph Kimball Books

If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading:

The Data Warehouse Lifecycle Toolkit: Practical Techniques for Building Data Warehouse and Business Intelligence Systems, Second Edition, 2008, 636 pages (Amazon).  Subject: Implementation guide.  Primary Audience: Good overview for all project… Read more

6 comments, 770 reads

Posted in James Serra's Blog on 30 May 2013

A moment of void in the cranium reveals a recursive computed column with an esoteric message

Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add operator.
I came across this error today when I accidentally used a computed column in a temp table, that referenced itself. This very unhelpful message was caused by referring to… Read more

0 comments, 359 reads

Posted in BIT Barbarian on 30 May 2013

I am Speaking at 2013 PASS Member Summit!

Speaking at PASS Summit 2013

Every single year I look forward to the PASS Member Summit. In a nutshell it is the SuperBowl for SQL Server Professionals. It is so vital to my career I have paid my own way.  It is the best place to connect, share… Read more

2 comments, 332 reads

Posted in John Sterrett on 30 May 2013

Saving Grace

According to Merriam-Webster the definition of grace is:

1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a virtue coming from God; c : a state of sanctification enjoyed through divine grace; 2a : approval, favor <stayed in his good graces>; b archaic : mercy,…

Read more

0 comments, 297 reads

Posted in SQL Swimmer on 30 May 2013

Backup a password, change it, then restore it.

A couple of months ago I talked about moving a login from one server to another without the password. The basis behind this is creating the login using the hashed version of the password. Using the same idea we can also “back up” a password.

The first thing to… Read more

0 comments, 1,300 reads

Posted in SQLStudies on 30 May 2013

SQL Saturday Charleston!

Finally.... SQL Saturday has come back to... South Carolina!  (with apologies to The Rock)

 

After the last SQL Saturday in Columbia, Bobby Dimmick (blog | twitter) and I decided to step back and see if somewhere else near us wanted to host a SQL Saturday. Charleston,… Read more

SQL Server security webinar series is coming soon!

I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All that I've traded emails on DMs on Twitter are interested, it's just a matter of putting together some details. In addition, several folks who do talks on SQL Server… Read more

Building a SharePoint 2013 BI Demo Environment Part 1 – Introduction

Recently I had to give a Power View demo for a client. Giving a demonstration means of course you have a demo environment available. I could’ve simply given a demo on Power View using Office 2013 and call it a day, but I really wanted to show the “convert Power… Read more

7 comments, 1,226 reads

Posted in Koen Verbeeck on 30 May 2013

Hangouts Session with Boris Hristov

I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter).

Boris wants to start using the Google Hangouts video calls in the SQL Server community, and we had a nice chat about where and how this platform can fit between the… Read more

1 comments, 269 reads

Posted in Matan Yungman on 29 May 2013

Older posts