Analytic Function — Lag

Starting with SQL Server 2012, Microsoft has included analytic functions within the database.  A couple that I use often, Lag and Lead, are very handy when you need to reference a previous or next row in a table without having to use self-joins or having to create a complicated sql statement.

Continue reading Analytic Function — Lag

How to find information about your instance using SERVERPROPERTY.

Here is a way to find out information about your SQL Server instance using TSQL.  You can query  all kinds of properties, for example, what edition are you running, what server is it on, etc.

Continue reading How to find information about your instance using SERVERPROPERTY.

SSIS Create extract file with Date and Time for a filename

In last weeks posting, we created our first SSIS package which queried a database and saved the information to a file so we could send the information to a user.  This week we are going to modify that same package to save the file with the date and time included in the filename.

Continue reading SSIS Create extract file with Date and Time for a filename

Creating Your First SSIS Project

What is SSIS?  It stands for SQL Server Integration Services which may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.  Today I am going to show you a simple solution on how to extract data and save it to a file.  This exercise will show some commonly used elements to creating a lot of different solutions.

Continue reading Creating Your First SSIS Project

Move User Database file to another drive

Have you ever received an email like below and then got a big pain in your stomach?  Disk E: is running out of room and you need to move one of your user database files before you totally fill the disk.  Yes, your VM admin might be able to add disk space but they are out sick or this is a physical machine and you need to order bigger disks and you need to make this change right now.

Continue reading Move User Database file to another drive

Query Timeout Expired

If you ever use linked servers to run queries on a remote database server, you may run into this issue if your queries take longer than 10 minutes:  OLE DB provider “SQLNCLI11” for linked server xxxxx returned message “Query timeout expired” [SQLSTATE 01000] (Message 7412)

Continue reading Query Timeout Expired

SQLSaturday #595 Cleveland 2017

On 2/4/2017 I went to my third SQLSaturday hosted at Hyland Software in Westlake, OH.  What is SQLSaturday? From their site:  “SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.”

Continue reading SQLSaturday #595 Cleveland 2017