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

Archives: April 2014

DAX #2 – Installing AdventureWorks DW Tabular Model SQL Server 2012

OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we also have a sample tabular project.

Download sample database and projects from CodePlex

You can follow this link to CodePlex to download the following files: tinyurl/AdventureWorks2012.

  • AdventureWorksDW2012_Data.mdf
  • AdventureWorks DW Tabular…

Read more

0 comments, 2,321 reads

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

Speaking at Connections

I just got my acceptance to the DevConnections, SQLConnections in September for two sessions:

  • Continuous Integration for Databases
  • Maintaining High Performance When Using Encryption

I enjoy the Connections events, usually finding time to go check out an ASP.NET or developer session of some sort.

Now’s the time to register and… Read more

0 comments, 246 reads

Posted in The Voice of the DBA on 30 April 2014

SQL #53 – Keyboard shortcut Alt + F1 works now in SSMS 2012

Keyboard shortcut Alt + F1 works now

SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS 2008 I had one complain about the default Alt+F1 shortcut. The Alt+F1 shortcut is assigned to sp_help by default.  It worked for tables, sort of. If you are… Read more

0 comments, 630 reads

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

And I wonder, where that column is?

I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs being really persistent and careful in his attempts to write his TSQL code. It started when I heard him pressing space-bar at his keyboard too much, I came to his desk and saw him lining…

Read more

0 comments, 307 reads

Posted in Data Adventures on 30 April 2014

The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found it very interesting. To be fair, some of the "how it works" isn’t something I care about much, but I did like Joe sharing some places in… Read more

0 comments, 1,804 reads

Posted in The Voice of the DBA on 30 April 2014

Decks & Demos Live

Hello Dear Reader!  Just a quick update.  I've been traveling a lot and I'm behind in posting some Decks & Demos.  Here are my decks from the Inside the Query Optimizer talk that I did recently at the Denver SSUG and also at SQL Saturday 283 Puerto Rico.  Click here…

Read more

0 comments, 269 reads

Posted in SQLBalls on 30 April 2014

Building the SQLSaturday Orlando Marketing Plan–Part 3

Not to short change fund raising, but the toughest goal to meet for this year is registration/attendance if we’re going to hit our 20% growth target. No, it’s not all about numbers, but our stance is that we’d like to deliver as much learning as possible – both to do… Read more

2 comments, 345 reads

Posted in SQLAndy on 30 April 2014

Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” on Saturday at the PASS SQLSaturday Business Analytics edition in Dallas at 4:30pm CST (info).  The abstract for my session is below.  I hope you can make it!

Modern Data Warehousing

The traditional data warehouse has served us well… Read more

0 comments, 483 reads

Posted in James Serra's Blog on 30 April 2014

A New Stressor

I tend to be amused when I run into something that causes me stress because I like to think – foolishly – that I’ve learned to manage stress and even avoid it by dealing with the underlying source of the stress. Last week I was in a meeting for 3-1/2… Read more

0 comments, 281 reads

Posted in SQLAndy on 30 April 2014

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However would you believe that it doesn’t actually delete the data from the pages at all? Here is an example:

-- Setup code
CREATE DATABASE TruncateTest
GO
USE TruncateTest
GO
CREATE…

Read more

7 comments, 1,163 reads

Posted in SQLStudies on 30 April 2014

Colorado SQL Events for May 2014

SQL Meetings are training events 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 events are… Read more

0 comments, 302 reads

Posted in Marc Beacom on 29 April 2014

Most important feature of SQL 2014

There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and a new cardinality estimation design to name a few. But for me, one of the most important features in 2014 is the increase in memory that standard edition can use… Read more

0 comments, 416 reads

Posted in SQL Server Rocks! on 29 April 2014

Find SQL Database Owner with T-SQL

One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week is the lack of a UI to do things. I’m not one of those people who has to have a UI to perform operations. I have no problem creating databases,… Read more

0 comments, 1,808 reads

Posted in Bradley Schacht on 29 April 2014

Building the SQLSaturday Orlando Marketing Plan–Part 2

Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342. Our registration count was 343, so we’ll need to increase that by at least 20% as well to get the corresponding gain in attendees – I’m going to round that… Read more

0 comments, 261 reads

Posted in SQLAndy on 29 April 2014

Building the SQLSaturday Orlando Marketing Plan–Part 2

Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342. Our registration count was 343, so we’ll need to increase that by at least 20% as well to get the corresponding gain in attendees – I’m going to round that… Read more

0 comments, 245 reads

Posted in SQLAndy on 29 April 2014

Back to Work

After surgery Fri am, I’ve been mostly taking it easy, but now it’s back to work. Got kids to school and at the standing desk. Overall I feel good and can walk fairly normal. Other than this big brace on my leg that slows me down and makes walking funny.… Read more

0 comments, 283 reads

Posted in The Voice of the DBA on 29 April 2014

Speaking At the Pinellas SQL Group on August 18, 2014

I’ve committed to presenting but haven’t decided on the presentation yet. It will probably be a remote presentation because it’s a bit of a drive from my home to Clearwater, but then again I like Clearwater Beach so it might turn into a mid week mini vacation trip. We’ll see. Read more

0 comments, 230 reads

Posted in SQLAndy on 29 April 2014

Installing and Configuring Active Directory in Window Server 2012

Hello Friends,

Sometimes life is so uneasy that you didn’t get time for the work which you like the most. Now those days are gone so I am back.It’s been months I haven’t written anything . I have received lot of mails through blogs and LinkedIn which I tried to… Read more

0 comments, 374 reads

Posted in AshishSharePointBlog on 29 April 2014

SQL Server Quickie #13 – Hash Join Operator

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 13th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 480 reads

Posted in Klaus Aschenbrenner on 29 April 2014

What is a Non-Clustered Columnstore Index?

First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of indexes that are stored in a column-wise fashion. It is targeted for data warehouses and can improve query performance by 10 to 100x. A columnstore index stores data in a…

Read more

0 comments, 1,371 reads

Posted in Everyday SQL on 29 April 2014

Older posts