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

Archives: April 2012

Call for Mentors for The Mentoring Experiment

We’re about to start our second experiment over at The Mentoring Experiment and we need mentors. Last time we picked a handful of people as mentors so that we could control that portion of the experiment. This time we’re just asking people that are interested to apply to be a… Read more

7 comments, 1,271 reads

Posted in SQLAndy on 24 April 2012

Change Package Properties Using Parameters–SSIS 2012

In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced in 2005 solved most of the problems. In 2012, SQL Server Integration Services introduces parameters to make this process even easier. Parameters allow you to change package properties without the… Read more

5 comments, 5,800 reads

Posted in Sam Vanga on 24 April 2012

SQL Server 2005 backups in a hung state because of full text search process

I came across an issue today where a backup process was in a blocked state with a wait type of MSSEARCH. The issue boiled down to an issue with communication/contention between the SQL Server engine service and the SQL Server Full Text Search service.

An attempt to kill the backup… Read more

1 comments, 297 reads

Posted in Ctrl-alt-geek on 24 April 2012

UF Dissolves Computer Science Program, Increases Funding for “Future Jobs”

In a bold and decisive move earlier today, the University of Florida has decided to dissolve their computer science education program.  In a statement to the media, university administrator Angus Pyle defended the groundbreaking but controversial decision.  In his remarks, he praised the staff and students involved in the Computer… Read more

7 comments, 2,726 reads

Posted in Tim Mitchell on 24 April 2012

OPASS April Meeting Recap

Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting.  I spoke on Extending SSRS with Custom Code and you can find the presentation material here.

What I’d really like to share with you about the event is what a fantastic group this… Read more

0 comments, 373 reads

Posted in Devin Knight on 24 April 2012

Quick Roundup of Intel Ivy Bridge Reviews

The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically 5-20% compared to the 32nmSandy Bridge, depending on the task), a pretty significant boost to integrated graphics performance (typically 40-65% compared to Sandy Bridge), and reduced power consumption under load… Read more

0 comments, 641 reads

Posted in Glenn Berry's SQL Server Performance on 23 April 2012

Turning 40

I turned 40 a few years back, and it wasn’t that big a deal for me. In some ways my wife thinks I’m a little old for my age, and when I hit 40, it wasn’t the milestone it is for some people. I think the night I turned 40… Read more

2 comments, 534 reads

Posted in The Voice of the DBA on 23 April 2012

Windows 2008 Server : Moving Cluster Quorum Disk to New SAN


In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we will go through the procedure to move the quorum drive to the new SAN. Follow the steps mentioned in the earlier post to add the new disk to the…

Read more

1 comments, 3,109 reads

Posted in PracticalSQLDba on 23 April 2012

Pragmatic Works Software for MVPs

This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses of its software! This NFR offer includes:

  • BIxPress – Audit, Notify, Deploy and Manage SSIS Packages
  • BIDocumenter – One Stop Documentation Solution for SQL Server, SSAS, SSRS and…

Read more

0 comments, 544 reads

Posted in SQL Chicken on 23 April 2012

SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th

One last reminder –  If you’re interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I’ll be giving this Friday.  Full details are here: http://sqlperftuning.eventbrite.com/.  We’ll be working some exercises, so bring your laptop with an instance of SQL Server… Read more

0 comments, 327 reads

Posted in Kevin E. Kline on 23 April 2012

The Importance of a SQL Server Inventory

Pop quiz!

  1. It’s time to true-up with Microsoft, what are your current license counts?
  2. Operations needs to schedule maintenance on ServerY, what applications will be impacted?
  3. A developer wants to change the password for a certain login, what linked servers will be affected?
  4. Are there any databases that haven’t been…

Read more

5 comments, 1,537 reads

Posted in Cleveland DBA on 23 April 2012

Comments on Acceptable Behavior

Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but I’m talking to the guys.

This blog post has been percolating in my mind for quite some time, but a few new stories have brought it to the fore. The… Read more

10 comments, 2,050 reads

Posted in The Scary DBA on 23 April 2012

Who are the sysadmins in this sql server?

Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a complete control of your server. So, it is very important to know who these people are.

Just to give you an example on why it is very important to… Read more

5 comments, 7,361 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 23 April 2012

Run SSMS as different Windows user

When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used to log on to Windows. For example, if you login using User1 on Windows and launch SSMS, you can only use User1 to connect to a server from SSMS as… Read more

1 comments, 629 reads

Posted in SQL and Me on 23 April 2012

Do You Know These Free Events?

I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may be you are interested too. These are all cool people sharing information for free to the community.

Go get'em!

Read more

2 comments, 371 reads

Posted in Sam Vanga on 23 April 2012

Intel Ivy Bridge Release Coverage

Web sites, blogs and media outlets in Europe and the U.K. are starting to post some early Ivy Bridge stories, which means that the Intel information embargo about the Ivy Bridge processor must be nearly about to expire. From what I have been able to determine, the information embargo is… Read more

1 comments, 626 reads

Posted in Glenn Berry's SQL Server Performance on 23 April 2012

Denali – Blog a Day Series : May, 2012

Denali

 

Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is also available now.

http://www.microsoft.com/sqlserver/en/us/default.aspx

After Sql server 2008 (compatibility 10) and sql server 2010 /sql server 2008 R2 (compatibility 10.5) another major release from Microsoft sql server is… Read more

0 comments, 301 reads

Posted in Vinay Thakur on 23 April 2012

SQL Server 2012 Core Factor Table for AMD Processors

As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can download it here (PDF warning). The complete SQL Server 2012 Licensing Overview is here. The most relevant part of this table regards the newer AMD 31XX, 32XX, 41XX, 42XX,… Read more

3 comments, 1,674 reads

Posted in Glenn Berry's SQL Server Performance on 23 April 2012

2012 DDL for Roles

G’day,

I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored procedures.

The particular case that I came across today was regarding roles and the ALTER ROLE syntax.

Prior to SQL SERVER 2012, it has… Read more

0 comments, 818 reads

Posted in measure twice, cut once. on 22 April 2012

SQLSaturday in Houston Presentation

Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.

Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes

Scaling SQL Server to HUNDREDS of Terabytes

Learn how SQL Server 2008 can scale to HUNDREDS of terabytes for BI… Read more

3 comments, 471 reads

Posted in James Serra's Blog on 22 April 2012

Newer posts

Older posts