Latest Blog Posts
The 11th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 11 contains all the hotfixes released since the initial release of SQL Server 2008 SP3.
Those who are facing severe issues with their environment, they can plan to test CU11 in test environment… Read more
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was “does SQL Server use an index if you have a wildcard in the search predicate?”
My initial thought was it would if the wildcard was not the first character but… Read more
As discussed in my previous blog the new architecture of Service Application in 2010. Let’s today discuss about connecting two different farms:
Connecting a service between Publishing and Consuming SharePoint farm
There are some service applications which have the capability to Publish and which can be used by… Read more
Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically around SSIS. In our research on weak points along said pipeline, we've come up with an interesting question right off the bat:
Do you check whether… Read more
0 comments, 170 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 22 May 2013
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For example, we can define a ‘Year to Date’ calculation in a calculation dimension and it will work for any measure. Alternatively, we could define a new ‘Year to Date’ calculated… Read more
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else. This is especially true when you’re doing something rediculously simple and SQL Server just sits there thinking. Symptoms of blocking problems include a trace of SQL:BatchCompleted and RPC:Completed with durations… Read more
I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well, but a couple of times I have had an issue where I wasn’t able to overwrite a previous backup file and received an error:
Msg 3202, Level 16, State 1,… Read more
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you can use exec sys.sp_MSforeachdb to loop through databases, and even filter. It will save some coding. However, my research indicates it is probably a bad practice to rely on this… Read more
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s. A video of the session is available at the Pragmatic Works website. As a part of that session, I received a couple dozen questions about security that we didn’t… Read more
Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid Office365 account do you? So, you click the link, figure it’ll open a web browser and off you go, right?
Instead it opens up a Lync app that you… Read more
0 comments, 117 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 21 May 2013
One of my pet peeves is seeing a top-notch BI architect/developer working as a salaried/perm employee of a consulting company where they are making a good salary but are being billed out to the client at a rate that is 3-4 times what they are making. Are they getting taken… Read more
This past Saturday I was fortunate enough to present a session at the largest SQL Saturday EVER in Alpharetta GA. This was a special event for me – I grew up just three hours south of Atlanta, and it was great to be back in my old stomping grounds. Read more
Development and demo environments can be hard to come by. Over the course of this series you will learn how to setup all the necessary components to create your own SharePoint 2013 demo environment. We will start with a blank Windows Server 2012 VM and conclude with a fully functional… Read more
For me, one of the most rewarding things about blogging are the conversations we have together.
The opportunity to connect, share and grow with passionate people from all over the world is a great privilege. I’ve met so many wonderful people through our community, learning something from each of… Read more
sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of for every server you care about. This DMV will tell you the cumulative amount of time you waited for each wait type since SQL Server services started, which is nice… Read more
That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds and learned something new.
I ran across someone that was building a restore script to automated their restores. This person wanted their script to work with any instance, and that means they’d need to find the path for the database files, if the database already existed.
It was interesting to me, and I decided… Read more
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first use I ever saw, and certainly the one I see the most commonly, CROSS APPLY is used to run a function for each row of the query. This is… Read more