Nov 4, 2010 | Backup, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it runs for say 30 minutes what happens to the transactions that occur during the 30 minutes that the backup is running? The short answer: All committed transactions that...
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...
Sep 15, 2010 | Policy Based Management, SQL Server 2008, SQL Server 2008 R2, SQLServerPedia Syndication |
I posted recently about my run-in with autoclose and my online friend Jorge Segarra (Blog|@SQLCHICKEN) left a great comment on my syndicated post on SSC where he said “Yeah Auto_Close came straight from the devil. One cool thing you could do on 2008 is use...
Sep 10, 2010 | Powershell, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals, SQLServerPedia Syndication |
Someone who I follow on twitter posted a tweet recently with a link to a free eBook on PowerShell. I have forgotten who posted the link, sorry. I followed the link and downloaded the book. I have been ‘learning’ PowerShell for a little while, from various...
Sep 7, 2010 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerPedia Syndication |
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn’t work out why they would use such a setting but I could think of a couple of reasons not to including: Resources used to maintain the state of the open database...
Jul 12, 2010 | SQL Server 2005, SQL Server 2008, SQLServerPedia Syndication, SSIS |
Have you ever had a scheduled run of one of your SSIS packages fail? Have you ever wished you had a little more information available to you when troubleshooting? SSIS has a neat little feature that you can enable called ‘Logging’ and it does pretty much...
