Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software

Month: December 2013

Posted in
  • QlikView

Get started with QlikView

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

by Tomas Lind•2013/12/302013/12/25•0
Posted in
  • Excel

Export data from Excel to SQL Server

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

by Tomas Lind•2013/12/262017/07/18•106
Posted in
  • Management Studio

Script schema and data

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

by Tomas Lind•2013/12/232013/12/20•0
Posted in
  • System Stored Procedures

xp_logininfo

This system stored procedure returns information on windows accounts or groups in SQL Server. One of … xp_logininfoRead more

by Tomas Lind•2013/12/20•2
Posted in
  • Log Shipping
  • System Stored Procedures

sp_validatelogins

The system stored procedure sp_validatelogins returns a list of logins in an SQL Server instance that … sp_validateloginsRead more

by Tomas Lind•2013/12/19•1
Posted in
  • Blocking
  • Concurrency
  • Deadlocks
  • SQL Profiler
  • Traceflags

Deadlock Basics

Deadlocks in SQL Server can be difficult to avoid completely, but there are some basic rules … Deadlock BasicsRead more

by Tomas Lind•2013/12/052013/12/05•0
Posted in
  • DBCC
  • Transaction Log

Virtual Log File Basics

The SQL Server transaction log files are managed as singe files in SQL Server. But internally … Virtual Log File BasicsRead more

by Tomas Lind•2013/12/032013/12/02•2

confided data manager

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • Export data from Excel to SQL Server
  • Table Valued Parameters in Stored Procedures
  • Tables larger than tempdb
  • Create XML with T-SQL function FOR XML
  • How to align columns in Notepad++

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 Tomas Lind.
Powered by WordPress and HybridMag.
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software