Latest Blog Posts
Couldn't find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted an evaluation version to developer edition.
- Obtain the key for the developer edition (in my case I had to download the .ISO from MSDN downloads, and go through the installation…
In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously individual events – the Management Summit, the Exchange, SharePoint, Lync, Project, and TechEd conferences – and then taking it to the next level, based on what customers and partners have… Read more
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows tasks to run SQL Processes. Now why would you ever want to do this? Well if you are running SQL Server Express… Read more
On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server machine in the office through his machine. I think this is generalized problem and might be faced by many of us.
So to begin with default port… Read more
Why a seemingly innocent WHERE clause can cause large amount of data missing
In the previous post, ETL #71–Your data can mysteriously disappear after a WHERE clause was added (1), I talked about how I discovered a WHERE clause was added to a main procedure that processes the raw… Read more
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