QlikView is a data analysis tool from QlikTech. They call it Business Discovery, or self-service BI. … Get started with QlikViewRead more
Year: 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
sp_describe_first_result_set
The system stored procedure sp_describe_first_result_set was introduced in SQL Server 2012 and it returns meta data … sp_describe_first_result_setRead more
Configuring SSRS
I was configuring SSRS (SQL Server Reporting Services) to run locally on my new developement machine, … Configuring SSRSRead more
Introduction to SQL Server Data Tools – SSDT
SQL Server Data Tools, SSDT, is a plugin to Visual Studio 2010 and later, with the … Introduction to SQL Server Data Tools – SSDTRead more