370 reputation
211
bio website sqlserverupgrade.com
location Miami, FL
age 34
visits member for 3 years, 11 months
seen Dec 16 at 16:57

Database and Business Intelligence Practitioner


Jul
3
awarded  Commentator
Jul
3
comment Chaining SQL Server Agent Jobs
does each of your items need to be a separate job? Could they be setup into a master job with separate job steps and for each job step add t-sql or other logic which determines whether the step should run and how (e.g. if (condition = true) do work else do nothing.
Jun
25
comment SQL Agent powershell context reference
Is powershell a requirement for what you are doing?
Jun
25
comment Recovering from: A transport-level error has occurred when sending the request to the server in SSMS
I have encountered the same issue after installing SSMSToolsPack. If I have a window that is connected to multiple servers, then open a new window, there is no way to get that window to connect. I have to close the window as both the "Connect" and "Change Connection" buttons are inactive.
Jun
3
answered The smallest backup possible … with SQL Server
May
29
comment How do you cope with Database Server Inventory Management
While it does seem political, I do believe there is some value in having this information for other reasons. Among these are Ensuring Licensing Compliance as well Ensuring all Databases on Servers (considered production) have a functioning backup solution. I take inventory on servers, but not on desktops. Dealing with unsupervised installs is a side effect of this, which I think is responsible behavior.
May
23
awarded  Scholar
May
23
accepted How do you cope with Database Server Inventory Management
May
23
comment How do you cope with Database Server Inventory Management
I ended up writing a package which pulls a list of windows servers from the domain controller (ignoring desktops). I save this list of servers to the database. I subsequently wrote another SSIS package with a WMI task which queries the list of servers and pulls the services on each box. Problem is I am not a domain admin, so I know of at least 2 servers which have SQL and I cannot access.
May
22
asked How do you cope with Database Server Inventory Management
May
18
answered What would I need to do to make sure my DB policies have to pass a security audit?
Mar
30
answered Database Mirroring Failure Reasons
Mar
30
answered SQL Server DR Plan - Test Documentation
Mar
4
comment Powershell-type SQL Agent Job failing intermittently trying to get Disk Space on Server via WMI-query
@user1005 - is powershell a requirement for this or would you be equally as satisfied with the vbscript equivalent of this?
Mar
4
comment What's the most effective way to duplicate an instance on SQL 2008?
@jcolebrand - I suggested backup restore, by simply would have to consider how to move data across from your live system to your demo system when you do stuff such as adding columns. This does however have the drawback requiring a restore then data purge before another backup and restore / detach and attach.
Mar
3
awarded  Supporter
Mar
3
answered How to group a resultset by day?
Mar
3
answered What's the most effective way to duplicate an instance on SQL 2008?
Feb
22
awarded  Self-Learner
Feb
21
awarded  Editor