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

Archives: January 2012

DevConnections Offers DBAs Many Options for Training

As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections (a part of the greater DevConnections event) in Las Vegas, NV, on March 26-29, at the MGM Grand Hotel. This is in addition to the SQL Server tracks that are… Read more

0 comments, 1,372 reads

Posted in SQL Aloha on 31 January 2012

Your Road to Becoming a DBA: Laying a Strong Foundation

Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of you, identifying what is the best way to move forward for you is vital.

Last week I received an email from a reader who was looking for some advice on… Read more

15 comments, 983 reads

Posted in John Sansom - SQL Server DBA in the UK on 31 January 2012

Setting the DAC port….

G’day,

I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port.

The main reason that I wanted it on a specific port was so I could use the connection remotely (if needed) and because the connection was on… Read more

5 comments, 2,166 reads

Posted in measure twice, cut once. on 31 January 2012

Review: ICE-21 Ice Cream Maker

I’ve had making home made ice cream on my list of things to try for a while, since watching an episode of Good Eats. Just never got to it as kid, seemed like a good thing to do now with my own children. I spent all of 5 minutes browsing… Read more

1 comments, 635 reads

Posted in SQLAndy on 31 January 2012

Tech on Tap v1.1 Wrap-up

The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in Appleton, WI. If you weren’t there, well, you missed it. Notice that keyword in that earlier sentence, Brewpub. Yes, the Tech on Tap events (and there will be more) are… Read more

0 comments, 1,084 reads

Posted in The Scary DBA on 31 January 2012

SQL Server – Send email using Powershell

This article explains how to send an email through Powershell. 

 Very useful if you have a requirement to automate your scripts and send notifications .

 The example is calling the SmtpClient Class , which is part of the .Net Framework.

You can call a Function –  which makes your scripting  … Read more

0 comments, 896 reads

Posted in SQLServer-DBA on 31 January 2012

Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget

Charts present summary data in a visually appealing format. Following is a chart for sales over month:


Before

I frequently use a few options along with charts to get most out of them.

Show data labels:

It’ll be easier for the users to quickly read, if the chart shows… Read more

4 comments, 2,138 reads

Posted in Sam Vanga on 31 January 2012

Meet the Geniiius Family

Over the next few weeks / months there will be plenty of opportunities to meet the Geniiius family, since we started the company we have not done many public presentations. This is something that we will start to do more of in the following months, and hopefully after the summer… Read more

0 comments, 678 reads

Posted in SQL Server Notes from the Field on 31 January 2012

Important SQL Notes collection by Jose Barreto

I have come accross below link while checking options to find top painful mirroring enabled databases.

Looks like there is no single query/DMV to get this info.

back to this link.

Excellect collection of key notes for almost all key SQL topics. Great work Jose Barreto.

http://blogs.technet.com/b/josebda/archive/2009/04/12/sql-server-2008-summary-of-training-sessions.aspx

Good source for Senior… Read more

0 comments, 1,195 reads

Posted in LivingForSqlServer on 31 January 2012

Detect Worst Performing SQL Queries – Part 2

This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL Server, after this session you should be able to achieve below objectives… How to use SQL Server DMO’s to gather what resources are the bottlenecks and which queries are causing…

Read more

0 comments, 604 reads

Posted in SQLFeatures on 31 January 2012

Tabular Model

One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model along with the multidimensional model comprise the Business Intelligence Symantec Model (BISM).

To be honest when the Tabular Model and the BISM where introduced along with DAX I… Read more

0 comments, 1,802 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 31 January 2012

Orlando IT Pro Camp 2012 Presentation

Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.

Read more

0 comments, 851 reads

Posted in Chad Miller on 31 January 2012

SQL Server 2012 Express RC

The new version of the lovely SQL Server edition, Express Edition!

Take a look the new link for the download and you have many possibilities for the download - (32/64 bit, multilingual etc).


SQL Server 2012 Express RC


Stay Tuned! Read more

0 comments, 1,564 reads

Posted in Dukagjin Maloku - Dugi'DBA on 31 January 2012

When DBCC INPUTBUFFER disappoints

Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement

 
SELECT * FROM
MASTER..SYSPROCESSES
WHERE BLOCKED != 0 
Yes, I’ve found the culprit SPID that is occupying more resources, using DBCC INPUTBUFFER(SPID). so, instead of seeing what…

Read more

Breaking Down TempDB Contention (part 2)

Breaking Down TempDB Contention (part 2)

Tempdb Contention via Idera Diagnostic Manager

I wrote a somewhat popular script and blog post a while back called Breaking Down TempDB Contention. This post explains how to identify tempdb contention. This past Friday, Jonathan Kehayias (blog|@SQLPoolboy) contacted me… Read more

Returning Results from an Insert – OUTPUT clause

I needed to return an identity value recently from an insert for use in another piece of code. For a client front end, you can easily encapsulate your insert in a stored procedure and then SELECT scope_identity() to get the last identity. However there’s an easier way: the output clause. Read more

2 comments, 2,300 reads

Posted in The Voice of the DBA on 30 January 2012

The affordable self-service BI revolution has started.

I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been my dream and I have now decided to follow that dream. I believe it is the right time to do it for my family and myself. It’s time to soar! Read more

10 comments, 824 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 30 January 2012

Complex reporting off a SSAS cube

While using a cube in SSAS is usually a great source for reporting, it is not always the best choice.  Sometimes it is better to report off of the data warehouse that the cube is built from.

For example, say you want to create a P&L statement using a financial… Read more

10 comments, 1,168 reads

Posted in James Serra's Blog on 30 January 2012

The Idera ACE Program, So Far

The Idera ACE program is something I’ve been involved with for over a year now. I’ll share a bit of the back story, and some thoughts on how the idea has grown and morphed since then.

Back in late 2010 I had a couple conversations with David Fargo and Heather… Read more

0 comments, 763 reads

Posted in SQLAndy on 30 January 2012

RYO Maintenance Plan – Database Backups, Part 2

Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups. Today we’ll get into the meat of the database backup procedure itself. If you’ll recall, this procedure has to meet some specific criteria:

  1. It will need a minimum of…

Read more

4 comments, 933 reads

Posted in Cleveland DBA on 30 January 2012

Older posts