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

Archives: June 2011

Arggghhhhh

I have a new tune stuck in my head now.  It got stuck there this afternoon shortly after my computer was forced into a reboot.  I was in the middle of writing a blog post, working on some stored procs and some general queries.  All of the sudden my system… Read more

0 comments, 575 reads

Posted in SQL RNNR on 30 June 2011

70-450 Study Guide

In my last post concerning my certification journey I said I may post a study guide.  I have thought it over and a sweetened condensed version of some of the topics covered would prove helpful.  Based on the Skills Measured page for the exam, one can determine topics to study… Read more

2 comments, 2,993 reads

Posted in SQL RNNR on 30 June 2011

SSIS OLEDB Command and procedure output params

While designing a package last week with our consultant, Latha Chandri (twitter), I came across a need to call a stored procedure drom within a Data Flow Task.  I have never needed to do this before and while the call is simple there are a few quirks… Read more

0 comments, 4,497 reads

Posted in SQLRunner on 30 June 2011

Performance Benefits of Adding RAM to a Laptop

I have a pretty nice Dell Latitude E6420 that I am using as a loaner laptop while I wait for my much nicer Dell Precision M4600 laptop to arrive. The E6420 has a Core i7-2720QM processor, but only had a single 4GB stick of DDR3 RAM installed.

The problem with… Read more

0 comments, 817 reads

Posted in Glenn Berry's SQL Server Performance on 30 June 2011

July 2011 Version of SQL Server 2008 Diagnostic Queries

Since July is only one day away, its time for the updated version of my SQL Server 2008 Diagnostic Information Queries. There is also an updated version of the results spreadsheet, with an additional tab for the latest new query in the set.

This new query lets you… Read more

2 comments, 762 reads

Posted in Glenn Berry's SQL Server Performance on 30 June 2011

Tobias Ternstrom’s Great Denali Preview

Tobias Ternstrom from Microsoft gave a great talk at Tech Ed regarding upcoming features of SQL Server Denali.  His presentation was engaging, funny, and informative!

You can check it out on the Channel 9 site here (72 minutes):

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI318

I have to say that I am very excited about all… Read more

0 comments, 1,135 reads

Posted in New York City .NET on 30 June 2011

The Austin Fall Classic, SQLSaturday is Coming To Austin, TX

Come Get Your Learn On!

You heard right, on October 1st 2011 you need to be in Austin, TX. We have finalized our location and spot on the SQLSaturday list. After a rough start to the year I’ve managed to get my core team together and in action, settle my… Read more

0 comments, 591 reads

Posted in SQL Man of Mystery on 30 June 2011

The Austin Fall Classic, SQLSaturday is Comming To Austin, TX

Come Get Your Learn On!

You heard right, on October 1st 2011 you need to be in Austin, TX. We have finalized our location and spot on the SQLSaturday list. After a rough start to the year I’ve managed to get my core team together and in action, settle my… Read more

0 comments, 539 reads

Posted in SQL Man of Mystery on 30 June 2011

Google Correlate

My friend Rob Hatton pointed me to Google Correlate, a new service that lets you explore data trends in a few different ways. The theory is that the history of searches should expose both some interesting trends and correlations, often faster than than the way ‘official’ approaches work.

On… Read more

0 comments, 730 reads

Posted in SQLAndy on 30 June 2011

Protected: Google Correlate

This post is password protected. To view it please enter your password below:


Read more

0 comments, 589 reads

Posted in SQLAndy on 30 June 2011

Minnesota SQL Server Study Group (July)

Study Group

For the past few months, I’ve been openly working towards the SQL Server MCM.  I failed a couple times (written exam and lab) and passed one time (written exam).  As part of working towards the MCM, I’ve been getting together to study with… Read more

0 comments, 655 reads

Posted in StrateSQL on 30 June 2011

The difference between REVOKE and DENY

There was confusion recently with a poster that was moving permissions around and asked why I said they should revoke permissions and not deny them. I decided this was worth a post to explain.

If I GRANT SELECT (or UPDATE/INSERT/DELETE) permissions to a user, then they can use those permissions… Read more

2 comments, 3,756 reads

Posted in The Voice of the DBA on 30 June 2011

Belt and braces

A moment ago, I was deep in some coding. What it was is not entirely relevant, With a page-full of carefully crafted code, I hit 'preview'.  Bang. The IDE died. Normally, the programmer will say at that point something like "Aiee! I wish I'd hit 'save' first!", Probably, the temporary… Read more

0 comments, 1,244 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 30 June 2011

Awesome Reports Webinar Tomorrow at 11AM

 

 

Here at Pragmatic Works, we enjoy putting on a show for the community. As can be seen by Training on the T’s (Tuesday’s and Thursday’s that is)! Tomorrow should be one of the most enjoyable Reporting Services webinars that you can learn some good tips using SQL Server Reporting Services… Read more

0 comments, 583 reads

Posted in BrianKMcDonald on 30 June 2011

Watermarking

 

Someone asked me a long time ago how to do watermarking in Reporting Services and I meant to write a blog about it. Then I was asked again just yesterday. So, I figured it was worth a quick blog. In this quick blog, I will show you how to use… Read more

4 comments, 1,318 reads

Posted in BrianKMcDonald on 30 June 2011

No way.

No way.


Read more

0 comments, 686 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 29 June 2011

The mystery of the NULL bitmap mask

In today's weblog post I want to talk about the NULL bitmap mask and some mysteries that you can encounter with it. The NULL bitmap mask encodes at the Storage Engine level which column stores a NULL value and which not. It's a simple bitmap mask, where a set bit… Read more

3 comments, 2,146 reads

Posted in Klaus Aschenbrenner on 29 June 2011

Why I’m raising my son to be a nerd

A good read, from ESPN and CNN columnist, LZ Granderson: Why I’m raising my son to be a nerd.

We need more STEM (science, technology, engineering, and mathematics) education in this country, and probably in all countries.


Filed under: Blog Tagged: career, syndicated

Read more

0 comments, 722 reads

Posted in The Voice of the DBA on 29 June 2011

Can you query a SSAS cube while it is processing?

I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the entire time the cube is processing, or just for a few minutes?  Or would the query bomb out?  Surprisingly, I found little information on the internet about this.  Fortunately, with… Read more

0 comments, 1,126 reads

Posted in James Serra's Blog on 29 June 2011

SQLDIY: Tracking Space Usage At the Index Level

I am a fan of information, the more the merrier. Anytime I’m tasked with tracking a production server over the long haul I try and gather as many data points as I can. You can capture database sizes but when your database blows up in size its nice to be… Read more

1 comments, 626 reads

Posted in SQL Man of Mystery on 29 June 2011

Older posts