Headless build can make you scratch your head (Part 1)

  One big advantage over recent database projects is the ability to do headless build on a build controller.   There is no straight forward definition of a headless build. In summary you can describe it that only the needed prerequisites are installed for compiling and translating the bits. While for some compilations specific applications…

0

Why the name of the service ist not the ServiceName, is not the ServiceName

  While recently writing a windows service which should be a multi-instance Service, I encountered the following challenge. As in SQL Server I wanted to use a similiar naming convention like MyServiceName$InstanceNameHere to distinguish the services from another. Within the service I needed exactly this service name in order to gather the right configuration. Fortunately,…

0

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

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 in conjunction with the…

5

Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 1

 (Update: Due to security reasons the functionality retrieving data from SSIS packages has been deprecated and is no longer available in  SQL Server 2008 R2) 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,…

2

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-level error…

2

Changing the Login / Authentication Mode programmtically via SMO

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 need to know the ServiceName your…

2

Obfuscation is not a security feature – Spoofing the APP_NAME

  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 the server. I saw that implemented in forums as denying special users the access during…

2