September 2009 - Posts
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
