Archives: April 2015
Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...
I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the "MAIN" proc which… Read more
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not… Read more
Have you been to Atlanta, Georgia ? Nope? Well it’s time you plan that trip and come see me speak May 16th, there at SQL Saturday #392. This will be my first time presenting at their SQL Saturday and I’m really looking forward this great event. According to… Read more
This past week I had the pleasure of being part of the second SQL Server virtualization workshop held by VMware. The first workshop, held last year, was a tremendous success and we all wanted to keep the momentum going with more SQL Server gurus. Over the last few months,… Read more
Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace…
I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the “MAIN” proc which… Read more
Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we were delighted to have a world exclusive keynote video by Phil Factor about Spinach and Database Development. With many thanks to those that made it possible and particularly to Phil… Read more
In SQL Server Records (Data) and log information is not stored in one file. There are three types of individual files used by SQL server to store its information. These files are Primary data file and secondary data file. These two individual files are used by one SQL server. These… Read more
I had to do this recently and needed to look up the syntax as I couldn’t remember it. I don’t do this often, but I was working on a particular item and wanted to test this.
I had a table, something like this:
CREATE TABLE SimpleTable ( MyID INT NOT
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of tasks it can perform. Currently I’m working on a task to run SSIS packages remotely by using Invoke-Command to run DTEXEC on a remote machine. I’ll be posting the final… Read more
The run-time metric gets all the love, and for good reason. It’s easily witnessed by end users and the one management cares about. When DBAs have the task of cutting down the run time of a query, this typically starts in a non production environment, consisting of different server architecture… Read more
Outlier Detection with SQL Server, part 6.2: Finding Outliers Visually with Reporting Services Box Plots
By Steve Bolton
…………Throughout this series of amateur mistutorials in using SQL Server to identify outliers, we have repeatedly seen that the existing tried-and-true methods of detection long used for such purposes as hypothesis testing are actually poorly suited for finding aberrant values in large databases. The same problem… Read more
When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the issues are related with handling of certain data types such as “TinyInt”.
A particular issue I recently came upon was the fact that TinyInt(1) is treated by default… Read more
This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
- Part 1: Networking
- Part 2: Domain Controller
Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of two datasets: input columns from a data source and columns in a reference dataset – a table, view or a result of a query. Lookup can be used in… Read more