RegEx: Capturing data such as: [blah]
Written by: Mr.ML
This afternoon, I executed a SQL script that generated code that look like this:
alter index [master] IX_VS_DateTimeStamp on dbo.Vehicle_Statistics REORGANIZE
The error is that the word ‘[master]‘ is present and shouldn’t be there. There were 300 of these issues in the output of my SQL script. [master] is only one of the 300s. Anyways, instead of fixing the script, which would of been easier by the way, I decided to use my rusty RegEx skilled I’ve acquired last s...
Granting permission to query DMVs
Written by: Mr.ML
In the past, when I use a DMV, I’ve always just run it and note it in an excel file; however, recently, I’ve been saving them to a table so that I can use it to generate reports. In other environments, all my SQL servers would run under one domain user and the password are enforced to be reset every 90 days. In my current role, this is not the case. Every SQL server has their own domain service account due to government contracts and such.Therefore, when saving results from DMV...
Battlefield 3
Written by: Mr.ML
Recently, I purchased Battlefield 3 on the Xbox 360. I haven’t played a battlefield series since BF2, way back when I was a hardcore gamer on the PC. The single player campaign was crap. The ending was bullshit and was a waste of time. I played the single player so that I can get used to the movement of this game. If they are planning to make an expanded single player as DLC, I think they wasted their time.
Multiplayer, is different. It is fun with the occasional bugs such as:
...Bulkloading and parallelism
Written by: Mr.ML
Today, I’m configuring a SQL server that will house the company’s data warehouse. The developers are going to be injecting data using the ETL process via SSIS and this got me thinking whether or not the bulk loading process will generate any type of parallelism. I wanted to know this so that I can configured the maxdop setting in SQL or maybe suggest the maxdop hint in the query.
I looked around the web and didn’t really find an answer based on my keywords so I asked #sql...
Login failure (Error 18456)
Written by: Mr.ML
In one of my sql instance, in the errorlog, I’m seeing a lot of connection coming from a user. I have asked around why this user is attempting to make a connection. I have submitted a ticket to prevent this user from connecting. Nothing was done about it 
.
So I was able to identify the IP address from the xp_readerrorlog’s output and identified the IP address of the host attempting to connect. It turns out to be the sharepoint servers. I still don’t know what resourc...
SQL In The City (LA) … Here I come
Written by: Mr.ML
Woo, I just got a confirmation email from the company’s travel agent. It look like I’m all set for SQL In The City hosted by RedGate on October 28th 2011. I’ll be attending the Database Admin Track and maybe jump into the T-SQL Horror session.
I hope it is going to be a good because I didn’t get to go to SqlPass. I was excited for the last Az SQL group meeting last month, but it was a fail. The topic was suppose to be about ‘denali: deep dive’ and t...
Date warehouse query performance
Written by: Mr.ML
Since working with SQL back in 2006, I was never one of those that got involved in building new databases from scratch. I have built my own operations database where it store information such as data I have gathered from SQLIO or wait and queue stats and anything else I want. They are usually for my own usage; however there are times when what I’ve created become a bit popular among the group and it become critical.
When I go about designing my tables, I put a lot of thoughts into it and t...
Changing SQL Service Password
Written by: Mr.ML
A long time ago, I wrote a powershell script that will change the SQL service password automatically. But it never worked right and since I don’t work in an environment with a large amount of SQL servers anymore, I never gotten around to fixing it.
Today, Aaron Nelson on twitter, posted a link to the Scripting Guys! website in which Ed Wislon responded with his own version of the powershell script; however, since I wrote my own defunct version back then, it has been noted in many article...
Random and sequential IO
Written by: Mr.ML
I got to thinking about random and sequential IO a few days ago and how it work when it came to reading execution plan. Such as, if I see an index seek, what type of io operations is happening in the back end? Is index seek a random or sequential operation? Why did I even care to think about this stuff?
About 3 weeks ago, I ran SQLIO on a new SQL server to get a benchmark of the disk subsystem. The drives are suppose to be sitting on a Compellent SAN and utilize the Dynamic Block Archit...
Steve Jobs passed
Written by: Mr.ML
It was announced today, October 5th 2011, that one of the greatest minds in my life time has passed….Steve Jobs.
Source: http://tinyurl.com/3jdlr4x
It was back in 1997 when I learn about Steve Jobs and Bill Gates. In 1999, I watched the movie Pirates of Silicon Valley because a coworker told me about it. I watched and I was mesmerized by these two individuals, how they single handledly changed the world through technology.
Today is a sad day. The world lost one of its greatest innov...