A quick one, again (haven't been blogging for a while, I have like a ton of blogs on my mind, lack the time, though): I think most of the DBAs have stumbled upon "how to fix orphaned users in SQL Server", right? Well, a quick overview of the script: SET NOCOUNT ON SET QUOTED_IDENTIFIER OFF … Continue reading Fix orphaned users in SQL Server 2005 – not
Category: Uncategorized
DTS package runs from command line, but fails from SQL Server Agent
Yet another quick one for you. One of my colleagues was trying to set up a job to run a DTS package (yeap, I know, a bit of a last century stuff). Whenever he ran the package from the command line, everything was running fine. However, when he ran the same package from within a … Continue reading DTS package runs from command line, but fails from SQL Server Agent
How can I tell if my restore process is actually doing something
Just stumbled into this: if you have a large DB to be restored, it might take forever to actually see the progress moving to 10%, 20%, and so on. Yeah, I know, you should never do a restore from the SSMS, but don't try to tell me thatJ. Anyway, coming back to our scenario: if … Continue reading How can I tell if my restore process is actually doing something
Is the primary key always clustered in SQL Server?
As I was playing in SSMS (SQL Server Management Studio), I created a table using the plain-old T-SQL, and then I decided to create a primary key, the "wizard" way, so to speak. Let's have a repro here: CREATE TABLE [dbo].[Employees] ( [empID] [int] NOT NULL , [firstname] [varchar](30) NOT NULL , [lastname] [varchar](30) NOT … Continue reading Is the primary key always clustered in SQL Server?
How to Disable NetBIOS on the SQL Server Box
Today I'll post a quick one, since a simple Google search (yeah, Bing, sorry) did not yield too many useful results. Just as a quick note, make sure you have a chat with your sys admins; they can tell you whether the protocols are needed or not anymore. Okay, on with the tip: Go to … Continue reading How to Disable NetBIOS on the SQL Server Box
To 32 or not to 32 on Windows 7
Finally I got 8 GB of RAM on my laptop. That's a great thing, especially that I have free licenses to pretty much whatever Microsoft has as x64, except that I'm married and this is not quite my laptop, but my wife's. If you ask anyone on the planet, you are to find out that … Continue reading To 32 or not to 32 on Windows 7
SQL Server installation tips… NOT
I have to admit that I shamelessly "steal" any info available on the net when it comes to SQL Server. Just to give you a quick example: Brent Ozar and Jonathan Kehayas both have some neat articles about installing SQL Server. Of course, I use the Next > Next > Finish feature, just as anybody … Continue reading SQL Server installation tips… NOT
Strange error in SQL Server 2005… when aplying SP3
Before going any further, let's get this straight: I'm not sure whether it's a bug or not, whether can be reproduced or not, but I care to have this documented.A machine was re-installed (Win 2003, SQL 2005), having 3 named instances (no default, just named instances). SP3 was applied... and nothing was like before:-). You … Continue reading Strange error in SQL Server 2005… when aplying SP3
SQL 2008 DBA now
I made myself an early Christmas present: since I had a free exam voucher from Microsoft, I said to myself heck, since I'm not paying for the exam, it's kinda time to upgrade my DBA skills from 2005 to 2008. That is, 70-453.OK, I passed, but I want to tell you some impressions:tough examdifficult examnot … Continue reading SQL 2008 DBA now
talking about customer care:-)
I just received (as an MCT I get all kinds of goodies) a free licence of PerfectDisk 11. So far, so good... but: "the official release isn't until tomorow, but I wanted to make sure our MCTs had it in their hands a little early".This is what I call "yes, they care about me".best regards,io
SQL-PLAY 