393 reputation
116
bio website
location Toronto, Canada
age
visits member for 3 years, 1 month
seen 13 hours ago

SQL Server 2005/2008/2012


Jul
29
comment Missing the pg_ctl package in Postgres 9.3 installation
yes, this worked.
Jul
29
accepted Missing the pg_ctl package in Postgres 9.3 installation
Jul
28
revised Missing the pg_ctl package in Postgres 9.3 installation
added 2 characters in body; edited title
Jul
28
comment Missing the pg_ctl package in Postgres 9.3 installation
"The program 'pg_ctl' is currently not installed. To run 'pg_ctl' please ask your administrator to install the package 'postgres-xc'"
Jul
28
asked Missing the pg_ctl package in Postgres 9.3 installation
Jul
2
awarded  Curious
May
27
awarded  Popular Question
Apr
22
awarded  Popular Question
Apr
16
awarded  Popular Question
Mar
11
comment How to deny database acess to windows autentication users
Can you remove windows authentication from your SQL server, and just have 1 local account on it? (not 'sa', anything but that)
Feb
26
awarded  Popular Question
Feb
5
comment Should I pause Mirroring and stop SQL Server services before running windows updates?
Right, I'm confusing myself with this scenario: sqlblog.com/blogs/tibor_karaszi/archive/2010/04/16/…
Feb
5
accepted Should I pause Mirroring and stop SQL Server services before running windows updates?
Feb
5
comment Should I pause Mirroring and stop SQL Server services before running windows updates?
I thought if Witness and Mirror are unavailable, Principal will refuse all transactions?
Feb
4
asked Should I pause Mirroring and stop SQL Server services before running windows updates?
Jan
3
awarded  Popular Question
Jul
15
awarded  Popular Question
Jun
10
comment Missing or lost transaction and no errors to show what went wrong
Quick update: We were able to review log using Apex software, however, because we do nightly Full Backup and then afterwards t-log backup, the log was empty. I am investigating ways of preventing this issue. There was a similar t-log truncation question on DBA exchange for anyone interested: dba.stackexchange.com/questions/40666/…
Jun
10
comment Preferred Methods of copying a new database from Development to Production
Thank you! (Just a side note: RedGate prepares scripts and it does the version control for me as well--though I am still fine tuning that).
Jun
10
asked Preferred Methods of copying a new database from Development to Production