SQLDays in Rosenheim Herbst 2009

  Thank for all participants attending my sessions in Mainz. As promised, here are the slide decks and demos I used during my presentations. If you have any question to this are other SQL Server related topics, feel free to ping me. I am looking forward to hear from you ! Volltext voraus – Volltextindizierung…


Need more spare time ? Use SQLIOSimParser to interpret your IO results !

  My colleague Marvelous Jimmy (JimmyMay) and myself did a small project to parse and interpret the results of the testing tool SQLIO. It produces ready-to-interpret reports and reusable results in Excel and will save you (as of Jimmy) much time doing your performance tracing and giving your more spare time to to fun stuff…

2

Problems opening your project files in Visual Studio ?

  if you encounter the problem as follows: <PathToyourDBFile> cannot be opened because its project type (.dbproj) is not supported by this version of the application. To open it, please use a version that supports this type of project. ..then you might have a problem with the registration of your dbproj extension (Team database edition…

1

Cannot find the source of a SQL Server error ?

Ever had an error in your application and you couldn’t find the source of all evil and where the error is thrown at the end ? Well, SQL Server profiler does a great job about that, but you really need to understand which events to filter for and how to correlate the results in order…


(Log) resistance is futile – how to drop log files

At the beginning everyone is trying to tune the database by creating additional database files, spreading the data across file groups, adding additional log files for the database… But wait a minute, is there a performance benefit from having more than one log file in the database ? Not really. This is due to the…


Database Programming: Did You Know IN Can Do This?

Ward Pond, one of the marvelous SQL geeks within Microsoft published a nice thing wich we had a discussion internally on concerning the capabilities of the IN operator: http://blogs.technet.com/wardpond/archive/2009/09/04/database-programming-did-you-know-in-can-do-this.aspx Were you aware of that ? 🙂 Be also aware of the facts that NULL can change the expected results ! http://blogs.msdn.com/jenss/archive/2009/05/25/the-magic-about-trustable-relationships-with-null-and-not-in.aspx -Jens

1

List reports of a Reporting Services instance via rs.exe script

Simple and easy, no coding or direct access needed to the report server database, simply put the following script in a script file and exectue it via rs.exe e.g. rs.exe –S http://localhost/ReportServer –i TheScriptFileHere.rss Put the following lines of code in a script file: Public Sub Main()    ListReports() End Sub Public Function ListReports() As…


CU6 for SQL Server 2008 / CU3 SQL Server 2008 SP 1 are out

  Get the latest and greatest CU package for SQL Server 2008 (RTM) –> CU6: http://support.microsoft.com/kb/971490/en-us or for SQL Server 2008 SP1 –> CU3: http://support.microsoft.com/kb/971491/en-us -Jens


Light weight SQL Server procedure auditing without using SQL Server auditing

(UPDATE: Updated technical version is available through this blog post here. The basic information and background though is available in the blog post you are reading) A week ago a colleague asked for different options to do audit stored procedure calls. With his allowance I will post the question here. “The applications used at the…

6

The “magic” about trustable relationships with NULL and NOT IN

  As a follow-up to my former post “Why you shouldn’t´trust the friendship of NULL and the (NOT) IN predicate” I asked Paul Randal during our SQL Server Master training about the possible internal reason that the results can vary if you have NULL in the IN-list. The explanation is that easy that I did…

1