Browse by Tags
All Tags »
.Net (RSS)
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...
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
Read More...
There are several scenarios where you want to extract data from different data sources and combine them within a report. Unfortunately if you have structure like a Table or Tablix, you can only bind the objects data source to only one dataset.
Read More...
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
Read More...
Here are some instructions how to change the Login / authentication mode via Code. It just uses plain SMO capabilites: After this you will have to make sure that the Service is restarted, if you want this to do via SMO look at the following sample. You
Read More...
SQL Server 2005 introduced an interesting and long demanded feature, the LOGON triggers. First only defined via server event triggers, it has become more and more popular in same scenarios to prevent users with a certain machine environment accessing
Read More...
