Viewing 15 posts - 2,041 through 2,055 (of 3,658 total)
Anyone who was in employment when SQL Slammer hit is unlikely to leave servers unpatched.
SQL Slammer caused so many problems because it attacked all editions of SQL Server so the...
June 20, 2009 at 9:34 am
The one critique I would have is this:
The article mentions quite heavily the editing process, so it would have been nice to have some kind of appendix where the reader...
June 19, 2009 at 2:44 pm
Personally my favourite was "The losers"
June 19, 2009 at 4:04 am
A wise boss once told me that he was interested in assigning responsibility rather than blame. By assigning responsibility there was an expectation of some positive action such as...
June 11, 2009 at 3:05 pm
For SQL2008 there is a web edition that is licensed to 4 CPUs. It sits somewhere between SQL Express and Standard Edition but with considerably cheaper licensing.
Having just gone...
June 8, 2009 at 3:18 pm
I.m using SQL2008 so the exact option may differ to mine.
In SQL Management Studio from the tools/options menu look for the "query results" branch on the left hand side.
In results...
June 7, 2009 at 10:24 am
One of Scott Adam's Dilbert cartoons is about an employees "numbing". This is when the employee realises that he/she is not appreciated, he/she is simply expected to be a...
May 19, 2009 at 9:36 am
I haven't got a degree.
I fell into becoming a DBA through an interest in statistics in relation to predicting future customer behaviour from past behaviour.
May 5, 2009 at 1:34 am
Personally I would set up an explicit Domain SQLAdmin group with very tightly controlled membership.
Make this group a sysadmin and get rid of NTAuthority/System.
You need to make sure that the...
April 26, 2009 at 1:50 pm
How many people have you got trying to connect to your instance?
What edition of SQL Server are you running?
What is the licensing model for your SQL Server. Is it per...
April 24, 2009 at 12:13 pm
17187 means that SQL Server cannot accept anymore client connections. There was a fix in SP2 as SQL Server was sometimes overzealous in issuing this command.
18456 is a "login...
April 23, 2009 at 1:51 pm
Because of my auditing needs I have a structure that is something like the following
UserID
VersionNumber
UserName
... additional fields to identify who did what and when.
The primary key is across the first...
April 23, 2009 at 6:49 am
Even bog standard Visio Professional will reverse engineer. It is the enterprise architect edition that forward engineers.
You could look at Sparx Data Architect as a possible tool or Erwin.
April 23, 2009 at 6:43 am
In data warehousing solutions the recommendation (Ralph Kimball) is to have a single field surrogate key.
In OLTP solutions I think it depends on how static the data is.
In my case...
April 23, 2009 at 6:40 am
As a matter of interest why do you allow the tblUsers table to have NULL values.
Why not put a DEFAULT constraint with an empty string on them. It would...
April 3, 2009 at 11:44 am
Viewing 15 posts - 2,041 through 2,055 (of 3,658 total)