Browse by Tags

Tagged Content List
  • Blog Post: The help for “The database schema provider could not be determined…”

    Some of us might be still bound to VSDBCMD instead of using the new tools of SSDT like SQLPackage. As frustrating as it is, we need to also get around this and the limitations of the existing error Messages of VSDBCMD. The one you will encounter often is: The database schema provider could not be determined...
  • Blog Post: 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...
  • Blog Post: Getting feedback / progress from batches and stored procedures

    Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not that easy as the results such as PRINT information is send after the batch has been completed. If you want to get information back from your batches you can use the property FireInfoMessageEventOnUserErrors...
  • Blog Post: When is random “random enough” ?

    An interesting question came up in a private conversation. If you want to pick a random value from a random generated result set and want to make sure that the row is really random, is the known ORDER BY NEWID() really random enough ? The point is that once you have one value and knowing the algorithm...
  • Blog Post: Checking Failover after setting up a Database Mirroring

    If you use database mirroring, the essence is that you use an additional connection property which is called “Failover partner” to make the client aware that it can try to connect to another server. If the principal went down or you lost connection to the server you will get the error message A transport...
Page 1 of 1 (5 items)