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

Archives: July 2012

reconfigure vs reconfigure with override

You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In this blog post I describe the difference between reconfigure and reconfigure with override. I also provide an example when reconfigure will fail and give you an error message and another…

Read more

0 comments, 1,901 reads

Posted in Katie and Emil on 28 July 2012

SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint

This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing and Bill Waters. Sharepoint sessions are great for those in the BI field using Microsoft BI stack managing PerformancePoint and PowerView/SSRS integration or SQL Server DBAs having a… Read more

2 comments, 912 reads

Posted in The Smiling DBA on 28 July 2012

Learning solid SQL Server and Business Intelligence skills through online training

I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL Server and Business Intelligence. My training goal is to improve my technical knowledge and gain new industrial skills to get myself ready for opportunities now and the future.

I… Read more

5 comments, 1,581 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 28 July 2012

SQL Server 2008 R2 Service Pack 2

Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through SQL Server 2008 Service Pack 1 CU5. If you have already installed SQL Server 2008 R2 SP1 CU6 or CU7, you will want to wait until Microsoft releases SQL… Read more

0 comments, 2,247 reads

Posted in Glenn Berry's SQL Server Performance on 28 July 2012

How To Prevent SELECT * The Evil Way

SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on a few fronts. First, typically that SELECT * FROM that gets written (a lot of the times) lacks a WHERE clause. What’s the problem? Well, that pulls back every… Read more

10 comments, 1,739 reads

Posted in SQL Chicken on 27 July 2012

Color Expressions in SSAS Calculations

Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a calculation. This property can be found in the Calculations tab of the cube editor when working in BIDS. Simply select a calcuation and look for the section labeled Color Expressions… Read more

5 comments, 1,522 reads

Posted in Bradley Schacht on 27 July 2012

SQL Saturday #150 Baton Rouge 2012

Baton Rouge SQL Saturday is Saturday, August 4!

 We expect ~400 attendees at the brand new LSU Business Education Centre of the College of Business, that shiny glass facility directly next door to Taylor Hall (CEBA). We have a whopping ELEVEN tracks this year, including two.net development tracks, IT Pro,…

Read more

0 comments, 736 reads

Posted in SQL Tact on 27 July 2012

Different techniques to identify blocking in SQL Server

SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests from many customers, there is a strong possibility that conflicts arise because different processes access the same resources at the same time. A conflict in which a process waits a… Read more

0 comments, 1,481 reads

Posted in Basit's SQL Server Tips on 27 July 2012

Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario

Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server 2008 R2. You can download the Service Pack here: http://www.microsoft.com/en-us/download/details.aspx?id=30437

Because I'm currently working on a Database Mirroring Test Lab that is based on SQL Server 2008, I thought it would be a good exercise to perform… Read more

0 comments, 2,478 reads

Posted in Klaus Aschenbrenner on 27 July 2012

Licensing SQL Server Dev/Test Environments

I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and testing (they call it staging) environments.  The client said that they purchased regular licenses for their staging environment but that they had MSDN Professional (“Visual Studio Professional with MSDN”) licenses…

Read more

3 comments, 16,312 reads

Posted in Nebraska SQL from @DBA_ANDY on 27 July 2012

SQL Server 2008 R2 – Service Pack 2 now available

SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.

All the details are here 

Stay Tuned…!

Filed under: SQL Server, SSC Tagged: Patches, Service Packs, SQL Server 2008(R2)

Read more

0 comments, 1,348 reads

Posted in Dukagjin Maloku - Dugi'DBA on 27 July 2012

SSRS – Using Lookup Function for Multiple Column Join

When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple datasets together.  Those functions were the Lookup FunctionLookupSet Function and the MultiLookup Function.  My general recommendation for these function is not to use them when you have… Read more

0 comments, 4,214 reads

Posted in Devin Knight on 27 July 2012

Retrieving Deadlock Graphs with Event Notification

Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps to capture deadlock graphs using Service Broker and Event Notification object and then sending them over to intended recipients using Database Mail.

Read more

0 comments, 2,817 reads

Posted in Basit's SQL Server Tips on 26 July 2012

Capacity considerations while moving SQL workloads to a Virtual world !

One of the most basic capacity considerations involved while planning to move SQL workloads to a virtual environment is to understand the maximum capacity of a single Virtual Machine (VM.

Many times questions arises in mind like “what is the max memory which a VM supports?”

Look at what one… Read more

0 comments, 771 reads

Posted in SQLSailor.com on 26 July 2012

A Quick Guide to Expanding Database Files and IFI

This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very quick note on instant file initialization (IFI) and database files. (As always, you should read the fine print – meaning Microsoft’s documentation – before you do anything on a production… Read more

3 comments, 1,001 reads

Posted in SQL Awesomesauce on 26 July 2012

High-Availability White Papers and Resources for SQL Server

In foreground, attendee makes dreaded “shoot myself” hand sign to the speaker.

I was just telling the good people of Charlotte about how they (and how YOU) need to read all things by Paul Randal (blog | twitter), except for all of his cheesy romance novels like Caress… Read more

0 comments, 921 reads

Posted in Kevin E. Kline on 26 July 2012

Last Call For Speakers for SQLSaturday Orlando

Our call for speakers for SQLSaturday #151 in Orlando closes on July 31, 2012. We’ve got room for a handful more of speakers. I just saw Eddie Wuerch send in some abstracts, who else will come to Orlando?

Read more

0 comments, 566 reads

Posted in SQLAndy on 26 July 2012

SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas

In the last 2 blog postings you have learned how to setup your first Availability Group with SQL Server 2012. Today I want to show you how you can join an additional Replica to an existing Availability Group. When you have followed the last 3 blog postings, you should have… Read more

0 comments, 4,650 reads

Posted in Klaus Aschenbrenner on 26 July 2012

Joining on NULLs

A problem I see on a fairly regular basis is that of dealing with NULL values.  Specifically here, where we are joining two tables on two columns, one of which is ‘optional’ ie is nullable.  So something like this:

i.e. Lookup where all the columns are equal, even when NULL.  … Read more

5 comments, 1,647 reads

Posted in Dave Ballantynes blog on 26 July 2012

Stop Storing Unencrypted Passwords!

I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a big deal and something that's a regular job task for a database administrator. But then he did something that totally floored me.

He went into the registry and copied the password (in… Read more

Newer posts

Older posts