The SQL Swiss Army Knife #5 – Checking Autogrow times

Hello all, Here is another one focusing on SQL scripts that may help DBAs, following the series “SQL Swiss Army Knife”. This time we are exploring an alternative way of verifying autogrow times besides checking the ErrorLog for any recorded information, and that is when an error 5144 or 5145 occurs.

5

SQL Server vNext – Codename “Denali” and much more …

Hello all, This week it was announced the first CTP of the next version of SQL Server (Codename “Denali”) and the 1st Release of SQL Server Parallel Data Warehousing (PDW) at SQLPASS, Seattle. On the following table you can find a resume of the new features/topics that were announced: SQL Server Denali SQL Server –…


Can log files growth affect DML?

Hello all, A while back I blogged here about how a good strategy of log file growth could potentially impact ongoing operations with your SQL Server. It’s known that VLFs (number and size) impact on the performance of such actions as scanning all VLFs for transactions that are marked for replication or log backup operations….


SQL Server 2008 SP2 is out!

The SQL Server 2008 SP2 has major improvements that include integration of reporting services with SharePoint products and several management improvements. This final version of the Service Pack 2 includes new compatibility features with SQL Server 2008 R2 and hotfix solutions provided in SQL Server 2008 SP1 Cumulative Updates 1 thru 8. For example, with…

0

SQL Swiss Army Knife #2.1 – Scripting Logins – Updated

EDIT (20-09-2012) – Added several scripting options; does not use SQL Server 2000 system tables anymore.EDIT (11-01-2013) – Fixed issue with permission syntax depending on version (2005 vs. 2008/2012).EDIT (18-03-2013) – Fixed issue with undeclared variable in cursor; Added options for access. Hello all, Here is another posting focusing on SQL scripts that may help…


SQL Server and Log File usage

Hello all, I decided to talk about an issue I’ve recently dug a little deeper, and so i will talk about how and why Log files (and their growth strategy) affect recovery times, mirroring, replication, large data changes (batches), leads to disk fragmentation, and ultimately adds stress factors to SQL Server I/O. First of all,…


SQLPort – 1st Event – Summary

Hi, First of all, I would like to say thanks to everyone that had attend this 1st Event. It was a great demonstration of your interest in SQL Server and at the same time in the SQLPort initiative! Please, if you aren’t part of the community yet, go and register yourself at SQLPort website. Last…


SQL Server Setup Portal–Released Today!

Hello, I would like to inform you that a specialized site about the SQL Server Setup was released today: http://technet.microsoft.com/en-us/sqlserver/ff625277.aspx Including information about SQL Server 2008 and SQL Server 2008 R2. Enjoy and let us know if you have any questions about the SQL Server 2008/2008 R2 Setup. Cheers,


SQLPort – 1st Event – May 11th @Microsoft, Taguspark

Hi all, Next week, 11th of May, the Portuguese SQL Community – www.sqlport.com – will present the 1st Event @Microsoft, Taguspark, 18:30. SQLPort Community and Blog Ezequiel Members would like to invite you, firstly to register at SQLPort web site: To create a new Account And then register yourself also for this event: Register for…