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

Latest Blog Posts

PASS Summit 2014 Speaker Idol

For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015 Summit. This competition was organized and run by Denny Cherry. You can read all about what he thought of the event right here. I was asked to take part… Read more

3 comments, 97 reads

Posted in The Scary DBA on 13 November 2014

Power Testing ETL with Power BI – Creating the Tests with Power Pivot

This is the second deep dive into Power Testing ETL with Power BI. At this point, we have created the source table which will be used in our testing. The next step is to bring in the destination table and create the tests that will be “run” against the… Read more

0 comments, 104 reads

Posted in DataOnWheels on 13 November 2014

Just an idea: Bare Bones SQL

I’m reading Andy Warren’s excellent essay “Thoughts on raising funds and spending funds for PASS chapters”, and it’s bringing together a bunch of long-stewed thoughts. Simply: What if there’s room for “Bare Bones” SQL user groups? The bare bones basics of Bare Bones SQL For those who don’t want to…

Read more

11 comments, 274 reads

Posted in SQL Awesomesauce on 13 November 2014

We’re at War – Cyberwar

In case you’ve not been following the news with regards to *government* breaches:

All three of these news articles released within the past few weeks. The reality is that our networks… Read more

1 comments, 217 reads

Posted in Databases – Infrastructure – Security on 13 November 2014

Adding a column to the primary key.

Every now and again you realize that the primary key for a table does not uniquely describe a row. Not really a big deal right? Just add an additional column in order to make it unique and move on. Easy enough if the column already exists and does not allow… Read more

2 comments, 384 reads

Posted in SQLStudies on 13 November 2014

Script to Monitor SQL Server Database Mirroring Status

SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database Mirroring send logs to mirror from principle. We need to monitor Database Mirroring status continuously to ensure that everything is working fine. We can use MSDB.SYS.SP_DBMMONITORRESULTS system store procedure to… Read more

2 comments, 107 reads

Posted in MSSQLFUN on 13 November 2014

MDX #44–How to find all the calculated measures

Calculated measures are visually identifiable

If you have access to a cube, it’s quite easy to find all the calculated measures.

The following is a screenshot from SSMS MDX query editor. The icon next to each measure can visually tell you if it’s a regular measure or a calculated measure.… Read more

0 comments, 165 reads

Posted in Sherry Li's BI Corner on 13 November 2014

Outlier Detection with SQL Server, part 2.2: Modified Z-Scores

By Steve Bolton

…………There are apparently many subtle variations on Z-Scores, a ubiquitous measure that is practically a cornerstone in the foundation of statistics. The popularity and ease of implementation of Z-Scores are what made me decide to tackle them early on in this series of amateur self-tutorials, on… Read more

0 comments, 271 reads

Posted in Multidimensional Mayhem on 13 November 2014

Updated blog Site

This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for the non-SQL nature of it.

Finally after promising myself to do so since late 2013, I've actually got around to updating my blog site to the latest version of Orchard.… Read more

0 comments, 93 reads

Posted in SQL Server Rocks! on 12 November 2014

Busy times

It has been a pretty long time since my last blog post but with good reason!

The last month and a half I have been spending time on some great SQL Server events like SQLSaturday Holland and SQLSaturday Bulgaria.
It was great to see so many people willing to… Read more

0 comments, 89 reads

Posted in DotNine SQL Server and more on 12 November 2014

Power Testing ETL with Power BI – Shaping The Data with Power Query and Power Pivot

This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to build out the test cases. In the previous post, you were able to get a sense of the bigger picture and how the pieces work together. This post will… Read more

1 comments, 5,468 reads

Posted in DataOnWheels on 12 November 2014

T-SQL Tricks – Templates in SSMS

There are lots of little tricks that you can use to become more proficient, and efficient, at writing T-SQL. Here’s a short one that might be more for administrators, but I think for developers it’s very handy as well.

SQL Server tools have included templates for years. I first started… Read more

0 comments, 229 reads

Posted in The Voice of the DBA on 12 November 2014

Should you move your data to the cloud?

Should you move your data to the cloud?  That is the question.  The answer is not simple.  While moving data to the cloud is all the rage, the fact is a large majority of the Fortune 500 companies are not keeping any data in the cloud at all.  At least… Read more

1 comments, 176 reads

Posted in James Serra's Blog on 12 November 2014

Speaking at SQL Saturday #354 – Charleston, SC

If you’re looking to warm up for the winter, come on down to Charleston, SC, on December 13, 2014. Charleston will be hosting its second SQL Saturday. Why Charleston?

Read more

0 comments, 189 reads

Posted in Databases – Infrastructure – Security on 12 November 2014

PASS BI VC: How to (not) torment your fellow SSIS developer?

On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS developer? for the PASS BI virtual chapter. This is great news for the people who couldn’t attend my session at the SQL Server Days and who still want to… Read more

4 comments, 126 reads

Posted in Koen Verbeeck on 12 November 2014

PASS DBA Virtual Chapter Webcast 20141112

Today I have the honour of presenting a session for the PASS Database Administration Virtual Chapter. The great thing about the PASS Virtual Chapters are that they are completely free, you just need to be a member of PASS in order to register. That’s right, free SQL Server training… Read more

0 comments, 94 reads

Posted in Richard Douglas on 12 November 2014

Introduction to SQL Server Functions With Example

SQL Server have functions which can be defined simply as database object or set of SQL statements which accept only input parameters, perform actions like calculations, and return value as a result. This result can be a single value and is scalar. Functions cannot be used to Update, Delete or…

Read more

0 comments, 6,550 reads

Posted in Zora's SQL Tips on 12 November 2014

MDX #43–Find a MDX Calculation Script

Finding out MDX calculation scripts is a common task

A co-worker recently asked me what the calculation for a calculated measure is in our reporting cube.

If you have the Analysis Services project in Visual Studio locally, it is easy to find what the calculation script is from the Calculations… Read more

0 comments, 170 reads

Posted in Sherry Li's BI Corner on 12 November 2014

MDX #42–IsEmpty? or = 0 ? or IS NULL?

In SQL, NULL means undefined value

Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and NULL is not even equal to NULL either, because NULL means undefined. One undefined value cannot be equal to another undefined value.

In MDX, NULL means an empty…

Read more

1 comments, 5,130 reads

Posted in Sherry Li's BI Corner on 12 November 2014

SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates

Drill-down report is a common design

In SSRS, it’s a common design to allow users to drill down to more granular data in a same report.

In the following snapshot, users will see a summary line that shows the Call Handled 130. The two days, 11/4 and 11/5 will not… Read more

0 comments, 5,383 reads

Posted in Sherry Li's BI Corner on 11 November 2014

Newer posts

Older posts