Archive for month: January, 2012

Battlefield 3 “Game disconnected: you were kicked by Punkbuster errors”

24 Jan
January 24, 2012

Ah Battlefield 3, an awesome game, but geez it is buggy.

This evening PC users are being greeted with the following notice on the Battlefield 3 Battlelog page:

“NOTICE: The “Game disconnected: you were kicked by Punkbuster errors” are being looked into right now.”

Read more →

SSRS on Mobile Phones (Mobile BI)

24 Jan
January 24, 2012

Mobile is a growing platform for BI integration, there are many out of the box BI solutions that offer some (sometimes limited) BI integration, I have yet to trial a full BI platform that has mobile OS compatibility natively integrated in its rendering engine

Read more →

The World, but Zipped!

24 Jan
January 24, 2012

This is more of a rant rather than anything useful, although I do give a link to an awesome JQuery library for zipping and unzipping files, so stick around!

Read more →

Create On-The-Fly SQL Tables

24 Jan
January 24, 2012

In this post I will show you a quick example of how to write an on-the-fly table in SQL Server.

Read more →

Convert SSRS Charts to Highcharts (Dynamic) Graphs

21 Jan
January 21, 2012

SSRS is an awesome framework as part of a whole BI solution for report authoring, delivery and interaction. One problem though is that the reports produced through Visual Studio or Report Builder are too static, there is no hover-over effect in SSRS reports, and you cannot do dynamic filtering once the report finished rendering.

This posts goes through building a converter that takes the ATOM output of an SSRS chart (1 y-axis Line Graph), and returns a dynamic Highcharts graph the represent the same data points.

Read more →

SQL Server Execution Completion Estimation

16 Jan
January 16, 2012

A simple T-SQL command that checks the progress of a particular SQL request, such as the progress of DBCC SHRINKDATABASE.

Read more →

SQL Server Table Variable vs Temporary Table vs CTE

12 Jan
January 12, 2012

Breaking SQL queries up into temporary physical or virtual “units” is done for many reasons, including performing complex SQL logic, re-using data for multiple DML/ETL operations (for example, multiple INSERTs), or simply just for better SQL code readability/maintainability.

This posts discusses the 3 available options in SQL Server for holding temporary data, these are SQL Table Variable, SQL Temporary Table and the CTE (Common Table Expression) SQL Syntax

Read more →

SQL Saturday in Dublin for March 2012!

11 Jan
January 11, 2012

SQL Saturday Logo

Exciting news, as this is the closest SQLSaturday has even been to home (Edinburgh – UK), so am very excited.

Read more →

SQL Server CXPACKET Wait Type

07 Jan
January 7, 2012

In this post I will go through the SQL Server Wait Type CXPACKET, what is this wait type a symptom of, and how you could go about diagnosing and optimizing the CXPACKET wait type.

Read more →