Archives: June 2011
There was confusion recently with a poster that was moving permissions around and asked why I said they should revoke permissions and not deny them. I decided this was worth a post to explain.
If I GRANT SELECT (or UPDATE/INSERT/DELETE) permissions to a user, then they can use those permissions… Read more
A good read, from ESPN and CNN columnist, LZ Granderson: Why I’m raising my son to be a nerd.
We need more STEM (science, technology, engineering, and mathematics) education in this country, and probably in all countries.
Filed under: Blog Tagged: career, syndicated
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
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
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
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
An interesting story on how a database speeds up by changing some application code. Worth the read for sure.
Can you set a unique index on a bit field? Well, you can, but you’d end up with a very short table of two (or three) rows. I defined this table:
CREATE TABLE [dbo].[BitTest]( [MyBit] [bit] NULL, [MyName] [varchar](50) NULL ) ON [PRIMARY] GO…
Do you know much about data compression? It seems that quite a few people I meet don’t really understand how it works, or what the benefits are. I heard about compression first hand from Sunil Agarwal a few years back at TechEd. I visited one of his sessions and then… Read more
I have seen more than a few posts about feedback that speakers get from sessions in the last couple months. Last week Buck Woody made an attempt to build a better form that could be used for feedback, which I like, but I think it’s a little too long for… Read more
I came up with a short acronym for my Preparation for Disaster presentation: BCPs. It describes what I think you need to do in order to be prepared for issues with your database server. The initials stand for:
- Practice and Preparation
- Script and Schedule
With a utility in… Read more
It’s nice to be accepted, especially as there is always a lot of competition for people to speak and there are tons of submissions… Read more
In case you hadn’t heard, the 2012 SQL Rally will be in Dallas. Andy Warren talks about the process for picking the city, and some of the challenges involved. There was supposed to be an open submission process and then votes from the community, but that didn’t work out. For… Read more
If you want to host, contact Adam. If you want to participate, read Allen’s post and write… Read more
In working on my Preparation for Disaster presentation and doing research, one of the questions that came up early for me was “what is a disaster?” After all, if you can’t answer that question, how do you prepare for it.
I’ve got a list of stuff here, which ones of… Read more
A mini debate on Twitter the other day got me thinking about cars. People that know me know I like cars. I’ve owned (or my wife has owned with me) 26 cars since I started driving. I used to write a car update, but found that there are a lot… Read more
Someone asked me in a webinar how to change the default backup directory. I knew, but realized that I didn’t have a reference and ended up with more explanation than needed if I’d had a post. So here it is:
If you right click on a server in Management studio… Read more
I woke up to this very cool photo from my employer.
I was checking my Twitter feed, and noticed quite a few #runwithsteve hash tags, from various people already knocking out mileage for the goal of 1,000 miles today. The tally survey is here: Running With Steve. I… Read more
This past weekend I went down to Pensacola, FL for SQL Saturday #77. This was the third event in Pensacola, and my third time going down there. It was also the second time that I brought my daughter along for the trip. She had a great time the first time,… Read more
I ran into an interesting question from someone asking for all combinations of numbers. The thread was here, and it was confusing at first. However we started to understand what was being asked and eventually the person stopped, realizing that there were too many combinations.
However at one point there… Read more