(Robert Sheldon) An SSIS 2012 feature guaranteed to make the developer’s life easier is the ability to turn off a connection manager. By default, when you open a package, SSIS checks all the data sources to ensure that the external metadata is valid.

(Ben Snaidero) Everyone knows it’s best not to use function calls in your WHERE clause as it will affect your performance (if you did not know this already, this article will convince you not to), but what about using them say in the SELECT list. This tip will look at how removing function calls fro

(Pinal Dave) Earlier I had one conversation with reader where I almost got a headache. I suggest all of you to read it before continuing this blog post SQL SERVER – Reseting Identity Values for All Tables.

(Marcin Policht) In our most recent article published on this forum, we described the way to leverage the dtexec.exe utility to execute SQL Server 2012 Integration Services (SSIS) packages stored in the traditional .dtsx file system format.

(Evan Basalik) Along with the expected challenges of the services world (rapidly changing features and quick adoption of new services), there are some unexpected ones. One of the most recent ones I have dealt with involved some unexpected ALTER DATABASE operations coming through on customer’s SQL A

Recently, one of our DBA restored a database on live server, but with old backup accidently. Later on, we have found that it was hard to detect which backup was actually restored. To check, which backups we have created for database we have a perfect script, which you can find over here and here. Bu

(Donabel Santos) There are new rendering extensions supported in SSRS 2012. Welcome extensions are the OPENXML rendering formats, to be used with Word 2007/2010 (.docx) and Excel 2007/2010 (.xlsx).

(Brady Upton) Ever get tired of assigning server level permissions by adding a login to a predefined server fixed role and then assigning multiple permissions to that login? In SQL Server 2012 you now have the ability to create a User Defined Server Level Role.

(Pinal Dave) Yesterday I had a headache answering questions to one of the DBA on the subject of Reseting Identity Values for All Tables. After talking to the DBA I realized that he has no clue about how the identity column behaves when there is DELETE, TRUNCATE or RESEED Identity is used.

(Ashish Mehta) Securing SQL Server is one of the primary responsibilities of a database administrator. However, there are scenarios when a DBA will have to manage SQL Servers for which he doesn’t have a valid system administrator login.