New job, new challenges?
Written by: Mr.ML
I left my old employer after 6 months and started a new one yesterday. The old one had potential to be a great except that the projects kept getting sided line leaving with not very much to do. And without doing, you start to forget what you know, which then weakens you.
When I took my old job, I was very excited. This new job, I will withhold judgement until I get to know the team, workload, and environment. There won’t be any more posts from me for a while until I either learn or...
Bad query
Written by: Mr.ML
Last week, I was putting together some reports for SSRS and at the end of the day, I wasn’t thinking straight as I just copied and pasted some previouly used code to generate the desire report.
The code I had used in the past collects data from all the databases and then store it into a table. This table would then provide me with some historical information. The new report I was working on, I wanted it to give me real time data. So instead of modifing the code to give me data from a...
SSRS: location to save rdl as template
Written by: Mr.ML
I’ve been playing with SSRS 2008 R2 recently and I made a template of what I want all my SSRS report to look like from the get-go. The book I’m using suggested a path but it wasn’t correct. Maybe it is a different verion or something.
My version of VS 2008 is: 9.0.30729.4462 QFE. After some trail and error, I found the location to be:
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
Store your .rdl file in thi...
This is WHY you don’t have spaces in database name!!!
Written by: Mr.ML
Today, I was working on a new script that would collect database’s file size and store them in a central repository, I have to use linked servers, some dynamic sql, and while loops. After spending time breaking down and going thru some trails and errors, it worked nicely until I encountered an error:
Msg 7313, Level 16, State 1, Line 2
An invalid schema or catalog was specified for the provider “SQLNCLI10″ for linked server “VipA\InstanceA”.
So after spending 20 ...
SQLMag: What are the seconds per read and seconds per write counters for?
Written by: Mr.ML
A blog post by Denny Cherry. I had the opportunity to meet and talk with Denny at the SQL In The City 2011 in LA. Haven’t heard the last name Cherry since high school, where one of my attractive counselor, also had the last name Cherry. Oddly enough, the only thing that I really remember about her was that she doesn’t have the ability to sweat…. That and she was nice to me. Okay a few things I remembered about her.
SQLMag blog post: What are the seconds per read and sec...
Error Applying SP1 to SQL 2008 R2
Written by: Mr.ML
In my time working as a SQL DBA, I have been forunate enough to have never counter any type of error while installing or upgrading SQL servers from one version to the next. Last month, one of the sysadmins were applying SP1 to our new SQL 2008 R2 clusters and ran into failures. The attempted was made on the passive nodes. However, all four instances failed to upgrade to SP1, including the active node.
First thing anyone do is basically to look at the error log and look for anything with t...
Tomorrow is 11-11-11
Written by: Mr.ML
Yahoo’s Who Knew segment gave an interesting view on 11-11-11. I never thought much of it until now.
I personally don’t have a lucky number but it seem that 6 is always following me around. I see enough of it to think it is stalking me.
In Buddhism, which I was when I was a kid, living in Thailand, but now, not so much, except that I’m into the wheel of life and not wanting to be reborn idea. It said that 6 is:
The six means of perfection or transcendent Virtues of the Bu...
Shrinking a log file that doesn’t want to shrink
Written by: Mr.ML
Yesterday, I was approached by two of the system admins, stating that one of the database they are connecting to is having issue. They are attempting to connect via a perl script, which I could care less about, not because perl suck or anything, because it doesn’t. My goal is to keep SQL instances and databases humming along smoothly.
First thing I did was to look at the dataase via SSMS to see if it was in any kind of suspected or recovery mode. When I opened SSMS, it showed (in re...
Problem with exec msforeachdb
Written by: Mr.ML
While attempting to come up with a way to gather index information and store it in my newly created warehouse, I am using the sys.dm_db_index_physical_stats dmv. At first, I was had plan to call this DMV via linked server such as: [serverA].master.sys.dm_db_index_physical_stats except that SQL won’t let me do that.
Other DMV’s I’ve used recently allowed me to make calls via linked server. Live and learn I suppose. Anyways, msforeachdb is an undocumented procedure that...
Problem with dm_os_performance_counters
Written by: Mr.ML
Last week, I was collecting data using dm_os_performance_counters and storing it into a warehouse so that I can generate reports, except that my script failed with ‘Divide by zero error encountered.’ I started to think … none of the databases on this SQL instance can possible have a 0 size database! Due to the nature of these databases, it was just impossible. I had to figure out a way to get around the error, I wanted to use the function isnull() but instead I went with ...