Browse by Tags
(Download the dbo.fndblog2 function here ) Update and word of caution: Be aware that the mentioned function is undocumented and subject to change in any release of SQL Server. You should only use that for investigational purposes and in case you
Read More...
(Sample code included at the end of the post) The initiator for this post was Dan Atkins who wanted to create a feed from relational data to consume it directly from a created gadget. Where can I find that in the toolbox ? First of all, you won’t
Read More...
Someone pinged me according the article I wrote about SSIS as a data source in Reporting Services. In general this is easy to implement and configure. One problem though occurs if you already had SQL Server 2005 on the machine first and updated
Read More...
After skipping some internal version the 0.3.3.0 is available now , these are the new features: Version 0.3.1.0 <Internal Bugfixing> Version 0.3.3.0 -Moved settings to a separate settings page and save them for later use (Suggested by me) -Added
Read More...
These are the new functionalities comparing the 0.2.3.1 version: -Added n-m mapping for different test iterations (Suggestion to Jimmy) -Included output to CSV (Suggestion to Jimmy) -Being able to specify a delimiter for the CSV output (Suggestion
Read More...
The first version (0.3.0.0) of a small project I did was published to Codeplex ( http://rsparamlogcache.codeplex.com/ ). It enables you to log and cache user parameter values for further usage and statistics. Here is short extract from the project
Read More...
Running SQL Server Traces on SQL Server Express SQL Server Express does not come with a SQL Server Profiler GUI. (Period) Though can still use SQL Server Profiler tools from other editions to connect to the SQL Server Express edition. (But make sure that
Read More...
Head up, the new CU is ready ! This one is CU (Cumulative Update) 4 for SQL Server 2008 SP1 (means that you will need to have SP1 installed in order to install the update) See the information of the release services team here: http://blogs.msdn.com/sqlreleaseservices/archive/2009/09/22/cumulative-update-4-for-sql-server-2008-sp1.aspx
Read More...
As it was hard to find the cause of this error and the answer, I wanted to share some searchable information on the internet for that. The following problem occurs while doing an upgrade of “older” VSDB project to the new GDR releases. As you have seen,
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 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...
