Reputation
Badges
0 0 0
Impact
0 people reached

1d
revised Headers and footers for Crystal Reports
Attached images and also the consolidated report generated so far.
2d
revised How to export an image column to files in SQL Server?
You will get a BCP error and the file will not be extracted correctly if you do not use the fully qualified table name
Feb
3
revised connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host
added more details
Jan
26
revised Permission error when executing a 5.6 GB sqlcmd file
Added the error thrown
Jan
22
revised How can I tell if a SQL Server database is still being used?
fixed query so it works
Jan
13
revised When will PostgreSQL execute archive_command to archive wal files?
improved formatting
Dec
29
revised List the database privileges using psql
Update to be code based
Nov
9
revised How to atomically replace table data in PostgreSQL
Corrected the code, there is no RENAME TABLE command in PostgreSQL, you use ALTER TABLE ... RENAME TO
Nov
4
revised Get multiple columns from a select subquery
reformatted sample code
Oct
29
revised Backup sql database directly to FTP server
Improved the code formatting
Oct
28
revised SQL Server permissions to create, restore, delete only some databases
Clarification - I wasn't sure how to read the sentence
Oct
16
revised How do I find PostgreSQL's data directory?
Typo in command
Sep
27
revised SIMPLE or FULL recovery model for databases?
This result is coming up top on Google for RECOVERY MODE SIMPLE and the command is wrong
Sep
9
revised Why does UPDLOCK cause SELECTs to hang (lock)?
Improve wording and grammar
Sep
8
revised Dedicated Resources on VMs hosting SQL Server
fix spelling in title
Aug
28
revised PostgreSQL 9.3 is not returning existing rows with Ruby on Rails or Squirrel
I brought some improvements thanks to Horse_with_no_name remarks
Aug
27
revised MongoDB - Change primary shard only for a certain database
changes db.getSiblingDb('admin').runCommand to the equivalent and shorter adminCommand
Aug
20
revised MySQL ssl setup failed
Typo in the command restorecon
Aug
17
revised How to disable ldf file or limit its size
Fixed image ordering for steps 2 and 3, and added dialog locations
Aug
11
revised query that does functionality of listagg without use of it
change the tags