17,681 reputation
21760
bio website sqlsybase.azurewebsites.net
location New York, United States
age
visits member for 2 years, 7 months
seen 2 hours ago

I am a Sr.SQL Server and SybaseASE DBA working for a company that makes software for Investment Banks globally as well as does Hosting business. I love working on performance tuning, migration, baselining, process automation, Cloud (Azure), High availability as well as Disaster recovery technologies, etc. I firmly support SQL Server community and so being on this site is my way of gently giving back to the community of what I have earned over the years.


Dec
8
revised How do I return data from a table where the data is the max date of the previous month's data submissions (-1 of current date)?
edited tags
Dec
8
revised How can I create notification on user's connecting to database?
added 40 characters in body
Dec
8
revised CHKDB is marked RESTORING
added 1 character in body
Dec
8
comment How do I return data from a table where the data is the max date of the previous month's data submissions (-1 of current date)?
What version of sql server are you using ? In the latest versions, there are many advance functions that you can use.
Dec
8
revised How do I return data from a table where the data is the max date of the previous month's data submissions (-1 of current date)?
added 60 characters in body; edited tags
Dec
8
comment Finding Database Default Locations
FYI only ... For SQL Server 2012 and up, undocumented SERVERPROPERTY('INSTANCEDEFAULTDATAPATH') and SERVERPROPERTY('INSTANCEDEFAULTLOGPATH') can be looked into.
Dec
5
reviewed Approve Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2
Dec
5
comment Is it possible to have 2 backup plans for a single database?
@randy if you feel that your question is answered please upvote/accept as answer.
Dec
4
answered Prevent Subscription to report from running on a holiday
Dec
4
answered SQL Hard Drive Config?
Dec
4
revised SQL Hard Drive Config?
added 83 characters in body; edited tags
Dec
4
comment Removing Databases in Recovery Pending Status after AG group was removed
Are you really sure this will work in the scenario that OP is having ? Can you add more details ?
Dec
4
answered 60 minutes to shut down sql server service?
Dec
4
revised Is it possible to have 2 backup plans for a single database?
removed unnecessary tags
Dec
4
revised Is it possible to have 2 backup plans for a single database?
added 173 characters in body
Dec
4
answered Is it possible to have 2 backup plans for a single database?
Dec
4
comment Restore SQL Server 2012 backup to a SQL Server 2008 database?
@aucuparia Some SSIDs and linked servers didn't go across properly. Linked servers has to be scripted out manually. SSIDs can be trnasfered using sp_helprevlogin. SQLAgent jobs, ssis packages etc should be moved as per your needs. The point of this method is to get the data as fast as possible when you are downgrading or merging 2 databases.
Dec
4
comment How To Strip Hebrew Accent Marks
+1 nicely explained.
Dec
3
reviewed Approve convert update field second to time
Dec
3
reviewed Approve convert update field second to time