Viewing 15 posts - 61 through 75 (of 191 total)
I'm a one-man-band here myself, but I would suggest that you start off small, maybe with a policy that requires at least the documentation of all things done in that...
October 9, 2012 at 2:26 pm
Try this little script I wrote to get the column names of a table in comma-delimited form. Code can be changed to do other formats. Check the Messages...
October 3, 2012 at 9:55 am
If it helps any, here is the latest version of my script to do an Instance Security Audit. It isn't pretty, and probably isn't the most efficient it could...
September 19, 2012 at 11:13 am
I agree. Checks should be done before you even get to the insert or update stage. If you are using SPROCs to do the insert or update, the...
August 29, 2012 at 9:55 am
See this post for my notes on SQL Server column-level encryption.
http://www.sqlservercentral.com/Forums/Topic1152176-391-1.aspx
The Database Master Key is a symmetric key that is secured by the Service Master Key. A database...
August 27, 2012 at 12:22 pm
Also, here is some code that I use to do error trapping in scripts. It allows the printing of the message, the RAISEERROR, and the sending of the information...
August 24, 2012 at 7:18 am
Here is an example of a SQLCMD call from a batch file. It uses a separate .sql file (after the -i), and sends all output to a log file...
August 24, 2012 at 7:11 am
Here is a great article explaining how to interpret the results and best practices on running SQLIO.
http://technet.microsoft.com/en-us/library/cc966412.aspx
And another interesting article:
Troubleshooting Slow Disk I/O in SQL Server
http://blogs.msdn.com/b/askjay/archive/2011/07/08/troubleshooting-slow-disk-i-o-in-sql-server.aspx
August 24, 2012 at 7:00 am
Sorry, I was looking at my SQL 2008 RS Config. Guess it has different tabs.
You say that you go to http://localhost/Reports and it says you don't have permissions. ...
August 23, 2012 at 11:48 am
You are using SQL Server 2005. It required IIS for Reporting Services. Is IIS service running? Is it configured correctly?
Is the Virtual Directory "ReportServer"?
Is the RS database...
August 23, 2012 at 10:21 am
Don't remove it just yet. Try to figure out what is wrong first. Removing it may cause problems well beyond what is going on now.
Go to your SQL...
August 23, 2012 at 9:42 am
If you are a local admin on the box, you should have access to the admin website (and the reports home page, for that matter). Also, just to make...
August 23, 2012 at 8:45 am
Nothing but troublemakers, if you ask me...........
August 15, 2012 at 12:52 pm
I agree with opc.three. You could just reset all the express services to manual and stop them. That way, you could restart them if they are ever needed...
August 15, 2012 at 12:19 pm
While it works for my situation, it may need tweeking to work in someone else's environment. I never claimed it was professional :). I made it available...
August 3, 2012 at 6:28 am
Viewing 15 posts - 61 through 75 (of 191 total)