Archives: June 2011
That Means What?Vizzini: HE DIDN’T FALL? INCONCEIVABLE.
Inigo Montoya: You keep using that word. I do not think it means what you think it means. - Princess Bride
If you are like me, you are constantly reading up on the latest hardware. Each site has it’s own… Read more
I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation was nicely done, and as part of that they put in some effort to make it energy efficient. Compact fluorescent bulbs in the hallways, some new windows for natural light,… Read more
Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the expiration date for certificates is not checked for TDE restores. So if your certificate expires, you can still restore the TDE backup.
However the documentation doesn’t mention this, and I… Read more
Table Value Constructors were introduced in SQL Server 2008 and enables you to (not only) insert more records with one INSERT statement.
“Standard” option to insert more records is following:
INSERT INTO Continents (Name) VALUES ('Asia') INSERT INTO Continents (Name) VALUES ('Africa')
With Table Value Constructors… Read more
I’m not sure what happened, but I had some sort of stomach bug yesterday. I was up throughout the night in the wee hours of Monday with cramps in my stomach or intestines and feeling miserable. Slightly better at 7:30am, I got up and tried to work. Even made some… Read more
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question “Where do I start learning more about SQL” will come up where someone has just taken on the role of DBA within his or her organization. Or possibly it is… Read more
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday, I’ll be presenting at Quest’s Pain of the Week webcast. The session will be Understanding Your Indexes: Operational Stats.
There’s a lot that goes on under the covers of…
OK, since this conference in is England, it’s a little harder to get to compared to TechEd. No matter, all the videos for this conference are online (65 of them). Take a look at the recorded sessions at http://sqlbits.com/content/Event8. All are free to watch! Included are some excellent sessions… Read more
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure compiles both data and log file usage. This is a fundamental aspect of tracking growth over time and being proactive about growing your databases yourself instead of letting the auto… Read more
Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into the fun and chaos setting up the schedule. As always we’re going to try to give everyone one presentation and we’re friendly to first time speakers too!
Reasons to speak… Read more
The PASS Summit is only a few short months away. But before that happens there is an important deadline fast approaching… the end of the pre-June 30th discount. For the last few months, you could save $600 off the cost of the regular entry fee. But on Thursday it all… Read more
Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.. I wish I had a good reference for the function, but the best one I had on SQLServerCentral was this piece on using it to load a data warehouse.… Read more
It is known that you cannot get inserted identity values using OUTPUT clause when inserting to view which has instead of trigger on it. I would like to offer another workaround I was used recently.
I am talking about fact that you will not succeed with this:
-- inserting records…
We all know how easy it is to see how much CPU power is consumed by the SQL Server process, tools like Performance Monitor or Task Manager will give you this information very easy.
But have you, like I have, ever wondered which one of your many databases is consuming… Read more
It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management topics for last couple of months (just a side effect of my new project lead position).
In parallel, I have started giving session on Performance tuning and Storage internals for my Organization… Read more
This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought I’d put together a post.
In June 2009, Microsoft released an update to SQL Server licensing which can significantly lower TCO for SQL Server instances running under VMs for not… Read more
I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and a laptop. The iPad doesn’t double as a backup, but it does let me do things like take notes at events or conferences with an extremely long battery life. My… Read more
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in SQL 2008, other things came up that have slowed me down considerably. It was only today that I realized that it has been one month since the last exam that… Read more
Version 1.58 of the very useful utility CPU-Z was released on June 24, 2011. Originally (and still) popular for bragging rights in the PC hardware enthusiast community for proving how much you had been able to overclock a particular processor, it is actually very relevant in a professional I.T.… Read more
Reprinted from my editorial in Database Weekly.
In early 2000, I started a new DBA job with a large organization, as their first full-time SQL Server DBA. My first job was to clean up the mess left by several accidental DBAs who had gone before me, and who had… Read more