Tomas Lind

Changing the database owner

When a database is created, the logged in user is set as the database owner as … Changing the database ownerRead more

Are you managing a lot of SQL Server instances? I was setting up a standardized set … Script to configure SQL Server AlertsRead more

In SQL Server Management Studio, it is possible to execute a multi server query against several … Multi Server QueryRead more

When SQL Server evaluates if an index should be used to retrieve data in a query, … Index selectivityRead more

When you submit a query to SQL Server – before the query is executed – SQL … SQL Server Join MethodsRead more

Windows environment variables are a great way to store server specific information that may be accessed … Add and edit Windows environment variablesRead more

A XML document is hierarchical. A value gets meaning from its position in the document. Nodes … Using XQuery to insert a XML hierarchy into parent / child tablesRead more

QlikView is a data analysis tool from QlikTech. They call it Business Discovery, or self-service BI. … Get started with QlikViewRead more

Need to get data from Excel to SQL Server? Normally this can be achieved by using … Export data from Excel to SQL ServerRead more

Ever needed to generate insert statements for the data in a table? This feature is actually … Script schema and dataRead more