QlikView is a data analysis tool from QlikTech. They call it Business Discovery, or self-service BI. … Get started with QlikViewRead more
Month: December 2013
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
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
xp_logininfo
This system stored procedure returns information on windows accounts or groups in SQL Server. One of … xp_logininfoRead more
sp_validatelogins
The system stored procedure sp_validatelogins returns a list of logins in an SQL Server instance that … sp_validateloginsRead more
Deadlock Basics
Deadlocks in SQL Server can be difficult to avoid completely, but there are some basic rules … Deadlock BasicsRead more
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