Jul 20, 2011 | DavidP, Scripts |
Written by David POstlethwaite A non SQL blog for a change Ever needed to create a batch file that wrote a time stamped log file that ensures the day and month number always have two digits? Try this: SET Now=%Time: =0%Set...
Oct 28, 2010 | Permissions, Scripts, Security, SQLServerPedia Syndication |
In order to be able to execute bulk operations you need to certain level of privilege both on the database (table) you are performing the operation against and the instance you are performing the operation on.If you don’t have the necessary permissions you will...
Apr 29, 2010 | Scripts, SQL Server 2005, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication, System Databases |
How do you tell when your SQL instance was lasted restarted? I was reading a post by Joe Webb (Blog|Twitter) about a query he uses to to gather information about his clients SQL Server instance including how he find out when an instance of SQL Server was last...
Apr 12, 2010 | Scripts, Security, SQL Server 2005, SQL Server 2008 |
The process of creating a db_executor might not be granular enough for some but there is a nice simple way of creating a database role in a SQL Server database (called db_executor) and granting the db_executor role execute permissions on all stored...
Apr 1, 2010 | Powershell, Scipts, Scripts |
One of my aims at the start of the year was to improve my Powershell and scripting skills. I run a few Google searches looking for resources and had plenty of results returned, but finding the ‘wheat from the chaff’ proved difficult. So I turned to twitter and asked...
Mar 29, 2010 | Backup, Scipts, Scripts |
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always have similar responses that go something like: “There is no SQL agent in Express…the only way to backup databases on a schedule is to write a script and...
