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

Archives: April 2012

Updated Thoughts on Antivirus on SQL Servers

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't like running standard antivirus on Exchange, SQL Server, or Active Directory domain controllers. My SharePoint admin friends have made good arguments to avoid it there, too. But a lot of… Read more

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

0 comments, 1,778 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, 12,556 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

2 comments, 551 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, 3,628 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, 1,051 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, 983 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, 1,118 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

9 comments, 7,782 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, 1,021 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, 569 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, 2,398 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,532 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, 21,784 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, 1,153 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, 629 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, 999 reads

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

Denali – Blog a Day Series : May, 2012



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


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, 592 reads

Posted in Vinay Thakur on 23 April 2012

Sysprocesses CPU and CPU Percentage - utilization

I am not sure how many of you have faced this situation? I have faced it many many times. Somebody asks you to provide currently running expensive queries or processes. You quickly look up to sys.dm_exec_requests or sys.processes and export the result in a excel and send it to requestor.Mostly…

Read more

0 comments, 385 reads

Posted in SQL and SQL Only 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, 2,826 reads

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

Newer posts

Older posts