Archives: July 2012
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
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
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
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
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
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,…
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
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
SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.
All the details are here
Filed under: SQL Server, SSC Tagged: Patches, Service Packs, SQL Server 2008(R2)
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 Function, LookupSet Function and the MultiLookup Function. My general recommendation for these function is not to use them when you have… Read more
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.
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
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
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
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?
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
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
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
3 comments, 2,399 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 26 July 2012