Latest Blog Posts
The number of Microsoft’s cloud services is growing by month, if not week, so that it’s hard to keep them all in mind and understand what exactly is each one for and when to use waht. This article is a summary of the Data Service as of April 2015. I’ll… Read more
The process itself is pretty simple
- Install SQL Code Guard at target computer. Please remember that you will need to have SCG installed on each computer on which…
It's time to start blogging again. And for my first post in a very long time, I mainly want to thank the SQL Server community for putting so much valuable information out there. Recently we had a rare deadlock appear, and it reminded me of a previous encounter I had… Read more
I finally got out to some community events last month and got to see a bunch of great speakers. Not that you don’t see great speakers at paid events, you do. It’s just that they’re usually professional speakers and I want to encourage others when I can.
The Speaker of… 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
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
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
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
This can cause a lot of problems. There are commands that can be given from T-SQL that can do a lot of damage… Read more
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