SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2011

Displaying blank sub report

Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two date parameters , a data set displayed in a tablix,  NoRowsMessage was enabled on the tablix to display a message when the data set returns empty row.

This report feature,… Read more

0 comments, 985 reads

Posted in What I Learnt @ Work on 28 October 2011

Play the Bob Ross Game

I was in a meeting a few weeks ago, deadlines looming and everyone feeling the stress some. We hit a couple minute pause and one of the guys in the room (a serious type most of the time) out of nowhere mentions that he finds watching Bob Ross on TV… Read more

0 comments, 747 reads

Posted in SQLAndy on 28 October 2011

Convert comma separated string to table and vice versa

I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of shredding a comma separated string to a table that I come up with today, albeit with help from the very clever Itzik Ban-Gan cross join nested CTE that many of… Read more

1 comments, 6,649 reads

Posted in SQL Server Rocks! on 28 October 2011

I/O Error On TempDB

I was running a DBCC CHECKDB on a database when I got an error that says:

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.

I was like “Oh crap!”  So I went to the SQL… Read more

0 comments, 1,551 reads

Posted in James' SQL Blog on 28 October 2011

Webinar on SQL Server Security on November 3, 2011

I have the privilege of being able to give a webinar next Thursday, November 3, at 11 AM EDT. It will be through Quest's Experts' Perspective series. You can register here:

Experts' Perspective Webcast: Building a Bulletproof Security Strategy for SQL Server

In this webinar I'll be discussing how to… Read more

Save a step: Using Computed Columns in a Table Variable (or Temp Table)

One of the databases that I support reports all money values in both the local currency and US Dollars.  Very often we will do all of our calculations in a table variable using the local currency and then calculate USD equivalents at the very end.

With this methodology, adding a… Read more

1 comments, 13,676 reads

Posted in New York City .NET on 28 October 2011

Understanding Kerberos, Part III

Welcome back to both our Kerberos coverage and to another topic for SQL University's Security and Auditing Week. In today's lesson we're going to cast some light on what is likely the most used tool in managing Service Principal Names (SPNs) for Kerberos: SETSPN. If you're not familiar with… Read more

0 comments, 10,373 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 October 2011

A Thought on Career Decisions

One of the many conversations I had at the PASS Summit was about whether to pursue Direction A or Direction B. Those kinds of decisions tend to come along because of an opening in the organization or because someone makes you an interesting offer? How do you decide?

Money, benefits,… Read more

0 comments, 591 reads

Posted in SQLAndy on 28 October 2011

Refresh QA Database with Manual Scripts

Couple of week back Megha Sharma send me an email with a document attached, this document is all about how to refresh QA database with manual script. Here is the preview of the document, and the reason why we should follow the method in her own words:

QA environment frequently…

Read more

Simplifying CSV Data Loads

Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database.  When it comes to loading CSV data into the database, many options exist, however, few make it as simple as CSVexpress, powered by expressor software.… Read more

0 comments, 799 reads

Posted in Kevin E. Kline on 27 October 2011

Presenting at SQL Saturday #87

On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL Saturday #87 in Louisville, KY. Come out and join me in this code filled session, where we’ll discover the differences and similarities of Temporary Tables and… Read more

1 comments, 653 reads

Posted in A Discussion of SQL Server-Related Topics on 27 October 2011

SQL University: SQL Agent Jobs That Run at SQL Agent Start

Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some related reading from last week, take a look at the Kerberos series I started:

The reason I point out the Kerberos… Read more

0 comments, 2,734 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 October 2011

Buckets for Disaster Recovery

Disaster recovery can be a huge project at any company. Considering the ways in which you build a plan that covers all the infrastructure, and it can quickly become a full time job for someone. The details, and the scope of the project can be overwhelming when you try to… Read more

1 comments, 1,252 reads

Posted in The Voice of the DBA on 26 October 2011

Dimensional Modeling Financial Data in SSAS

Part 1 – Parent Child Hierarchies and Pseudo GL Accounts

This post is born out of some real life  lessons that I learned while putting together a Financial Data Warehouse based on General Ledger (GL) data i.e. all the GL’s in the foundational financial statements from Net Income and  Balance… Read more

10 comments, 4,453 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 26 October 2011

Watch those VARCHAR(MAX) columns, and ONLINE index rebuilds


I’ve noted a few instances lately of cases where VARCHAR(MAX) columns have been used unnecessarily, when a small value (for a VARCHAR) would have been fine.

Apart from the storage implications of a VARCHAR(MAX) column there is also the issue that in SQL SERVER 2008, having a column of… Read more

2 comments, 12,419 reads

Posted in measure twice, cut once. on 26 October 2011

Miss TechEd Australia 2011? No problem, all videos are online

As you may know, the TechEd in the U.S. is not the only one.  There have been many all over the world, and it 2011 there have been one’s in New Zealand, Australia, and next month in Russia.  The Australia and New Zealand TechEd ended a couple of months ago,… Read more

2 comments, 802 reads

Posted in James Serra's Blog on 26 October 2011

Applied SQL: Demonstrate Simple Backup and Restore

Let’s apply a little backup and restore knowledge, eh wot?

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.

Prerequisites: basic T-SQL, create objects/data, basic understanding of recovery models and backup types.

Reading – SQL Server Books… Read more

0 comments, 728 reads

Posted in SQL Awesomesauce on 26 October 2011

A Bit of a SQL Saturday 99 Update…

I’ve been a bit busy while planning this year’s SQL Saturday in Minnesota.  Unfortunately, that hasn’t led to a lot of updates on our upcoming event.  On the plus side, I got married, had a honeymoon, and attended the best PASS Summit ever.  If you haven’t started thinking about it,… Read more

0 comments, 701 reads

Posted in StrateSQL on 26 October 2011

SSAS – Deployment Wizard

The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your environment. Often I see developers deploy directly from BIDS to all Development, QA, and Production environment by changing the project properties to the different instances. For multiple reasons this is… Read more

2 comments, 6,588 reads

Posted in Devin Knight on 26 October 2011

SQLInspireNYC - You can still REGISTER for FREE! - Embarcadero Give-a-way

You may have missed the big announcement yesterday on SQLServerCentral.com, that thanks to one of our great event sponsors, Red Gate , we were giving away (20) Twenty FREE registrations, for the lucky folks who grabbed the 100% discount code, and registered immediately.  It was a limited special offer, and… Read more

0 comments, 905 reads

Posted in Pearl Knows on 26 October 2011

Newer posts

Older posts