Reputation
8,056
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 21 56
Newest
 Nice Answer
Impact
~523k people reached

1d
answered SSIS OLEDB Command not firing triggers
Feb
3
comment Is it important to make transaction log backups?
If that owner accepts the risk, best to have it documented in clear language, then all is well and good. Being in simple recovery mode simplifies your life as you don't need to backup two different entities as well as test the restores (you are doing this, right?). If they don't accept losing up to 3 hours worth of data, then you need to have a discussion about what is an acceptable data loss window looks like
Feb
3
comment Is it important to make transaction log backups?
It is 2 hours and 45 minutes since the last backup and "something bad" happens - a table's dropped, hacker trashes the table values, office admin sits on the keyboard, whatever - Does the business process owner that the database represents accept that they can only get their data back to 2 hours and 45 minutes ago?
Feb
3
revised Enforce NOT NULL for set of columns with a CHECK constraint only for new rows
killed the scrollbar
Feb
3
comment SQL Server Import Export Wizard Error - Server throw Exception
Since you are targeting execution in a SQL Server 2014 installation, you can install SSDT-BI edition for SQL Server 2014 and then generate your packages proper. In fact, you can automate the creation of the packages quite nicely.
Feb
2
comment Why does time zone have such a crazy offset-from-UTC on year 0001 in Postgres?
Also, a fine video about the insanity of time zones
Feb
1
comment Grant access only to System databases
I think your question will be greatly improved by being very specific. Since this is a security related topic, I feel it'd be poor form for us to assume we understand precisely what "anything to a user database" means in your mind.
Jan
26
comment Database: One table or many
Do you need to collect different attributes for a tablet listing compared to a scooter listing? If you don't, then as the fine answers below indicate, it's the value of your categorization that determines whether "Samsung. good shape, $500" is applied to a television or a mobile phone.
Jan
22
reviewed Close Innodb full table Scan
Jan
22
reviewed Close Extract ID String - PostgreSQL 9.2
Jan
22
reviewed No Action Needed Problem with INSERT INTO
Jan
21
accepted CPU Schedulers Offline
Jan
21
comment SQL Agent Job Edit Step: An entry with the same key already exists. (System)
Whenever I talk about devops for SSIS, I make the mistake of clicking the OK button in the GUI. I then ask people how I can migrate a set of environment variables from one server to another or apply all the same configurations from an environment to a project? The silence is usually deafening. I'l have to try Joost's script at some point but always click the Script button and save that off somewhere. Your future self thanks you.
Jan
21
asked CPU Schedulers Offline
Jan
21
comment SQL Agent Job Edit Step: An entry with the same key already exists. (System)
Instead of clicking OK, click the Script drop down and then script to new window. Never trust the gui. Now you can use that script to see what change the GUI is attempting to make for you. You'll probably want to script the job as it stands now and either edit your question to include that information and we can help or ... we're pretty much just guessing
Jan
21
reviewed Close Dynamic columns or many columns?
Jan
21
reviewed Close How to execute system command in mysql stored procedure?
Jan
21
reviewed Reviewed Postgres tablespace size is bigger than database size
Jan
19
awarded  Nice Answer
Jan
15
revised Error at line 1, column 25: ORA-00923: FROM keyword not found where expected
No thanks needed