Viewing 15 posts - 181 through 195 (of 814 total)
volker.osterlitz (12/5/2013)
Americans tend to microcontrol and log too much by default already.How much of data gathered is really used productively?
American logging is often not meant to be used productively,...
December 5, 2013 at 8:24 am
patrickmcginnis59 10839 (12/5/2013)
"... Ideally, the audit information should be sent to a location that cannot be modified or tampered with, even by a sysadmin."http://technet.microsoft.com/en-us/library/dd392015(v=sql.100).aspx
Windows in general, and SQL Server in...
December 5, 2013 at 8:08 am
Paul Randal (11/26/2013)
December 4, 2013 at 10:00 am
adrian.facio (11/27/2013)
Hi, thank you. Doing some math i figured out that 3 million rows of 1 decade of time span with minutes granularity will need 15 768 000 million rows...
December 4, 2013 at 9:11 am
Make sure you have a separate sysadmin account you use.
Graphically, via SSMS:
Server Properties (right-click on the servername in Object Explorer, Properties), Security, then audit both failed and successful logins.
Restart the...
November 26, 2013 at 12:15 pm
This is an interesting take on temporal constraints, but have you tested it with large sets, i.e. perhaps millions of rows of data where the time ranges are measured in...
November 26, 2013 at 12:07 pm
Jeff Moden (11/25/2013)
November 26, 2013 at 8:09 am
http://technet.microsoft.com/en-us/library/ms188388.aspx
I agree - do one at a time, and just let it run to completion, however long it takes - if you do an OFFLINE rebuild, it's faster, but it...
November 25, 2013 at 9:31 am
Jim Youmans-439383 (11/25/2013)
November 25, 2013 at 9:23 am
Jeff Moden (11/22/2013)
Shifting gears a bit, why do so many people assume that where there's a database, there's a client application? And when there is an application available, why...
November 25, 2013 at 8:28 am
Take a look at the RESTORE HEADERONLY information on the differential and both fulls.
Compare the differential's DatabaseBackupLSN to the FirstLSN of the Full backups - it goes with whichever one...
November 22, 2013 at 9:16 am
A basic start:
Download SQL Express 2012 SP1 with Advanced Tools. Install, and experiment with it.
A cheap start:
Buy SQL Developer edition, install and experiment.
An expensive start:
Become an MSDN subscriber and...
November 22, 2013 at 9:12 am
If you have the budget, do some sort of drive image/bare metal restore capable backup after each major step - Acronis TrueImage, Paragon Disk Manager, Clonezilla, FSArchiver, or even a...
November 22, 2013 at 9:06 am
Alternately, you could create a stored procedure that creates users with whatever restrictions you like, create a certificate, sign the stored procedure with the certificate, create a user based on...
November 22, 2013 at 8:55 am
For pure minimums, I like to stay a little simpler:
Set based solution design
Transactionalization (ACID compliance)
Data types
Normal Form based database design
Learn new programming syntax
Benchmarking
Testing for correctness.
T-SQL when used as a procedural...
November 22, 2013 at 8:52 am
Viewing 15 posts - 181 through 195 (of 814 total)