Latest Blog Posts
The one absolute promise I made about serving on the PASS Board is that I would let you know what I was doing there. Well, we’re two weeks in and I figured now was a good time for a report.
Next week is my first board meeting (and I will… Read more
I’ve got a question for you. Where did you learn how to listen?
Of all the coaching and consulting clients I have asked that question to, not one has had formal training to become a better listener.
Some have pointed to the works of Stephen Covey and others like him… Read more
There are probably a common number of apps you pull up when you pull up your system. For example, I pull up my Trello board, outlook, XYplorer, Sublime text 3, Sql server management studio, and ketarin (app updater).
Found that you can easily setup a simply alias and launch a… Read more
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL Skills insiders video on OFFSET and FETCH by Jonathan Kehayias (b/t) and remembered fondly an interview I did many, many years ago. As part of the… Read more
The page came at a reasonable hour. All of the overnight ETL and processing jobs were just winding up before the business started in earnest for the day. One of the final jobs of the morning failed, a job that called an SSIS package that transferred some email logging to… Read more
Just a short mid-week update, David Postlethwaite has been selected to speak at SQL Saturday Vienna which is being held in Vienna at the end of February(28th Feb). David’s talk is titled Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure.
There have a been couple of…
We had a great conversation and covered a lot of issues. Among… Read more
Different ways to find the weekend between two given dates. The SQL requires @begindate and @endate paramteters to be entered in the below SQL
Download T-SQL WeekendBetweenTwoValidDates
DECLARE @beginDate Date='20150101', @endDate Date='20150131' DECLARE @Calendar Table (CalendarDate Date Primary key, IsWeekend Bit) WHILE @beginDate <= @endDate BEGIN INSERT INTO @Calendar SELECT…
This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for the management of a large number of SQL Server instances.
Originally posted on JamesDataTechQ:
This blog post is about adding a new CheckBox to the SQL Tool…
Long has the question been asked “Which Microsoft tool do I use for dashboards?”. SSRS, Excel, PowerView, Report Builder and PerformancePoint are all candidates. But that has all changed, and the future of dashboarding is here: Power BI Designer.
The Power BI Designer is a new companion application for Power… Read more
VMware has recently announced an online event for February 2nd that you don’t want to miss! Whatever it is, it’s going to be big! It also kicks off the 28 days of February event, whatever that is. You don’t want to miss this!
Date: February 2, 2015
Time:… Read more
This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which comes about from pressing Shift+F5. Whatever statement the cursor is on, whether it’s a single line or multi-line, the statement will execute.
It can be on the first line: Read more
There’s power in naming things. Supposedly some types of magic are even based on knowing the correct names for things. The name for the T-SQL clause Common Table Expression (CTE) is actually pretty accurate. It’s an expression that looks like a table and can be used in common across the… Read more
Our starting point – we want Grape to be highlighted because it is not the same as Cherry.
Select all of column…
Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.
I have to say it is probably my best decision in 2014 to write for MSSQLTips.com as I am not only paid decently for writing about what I… Read more
One of the things that DBAs love to do is keep their servers running and healthy. A healthy server, after all, is your ticket to a stress free day and a full night’s sleep. Granted this not a guarantee but it sure helps make life easier.
We are always looking… Read more
Mike and I have been extremely busy over the Xmas period and we’ve finally sorted dates for our 2015 instalment of the SQLNorthEast SQL Server UserGroup (@SQLNE) in Newcastle. The great news is that after much negotiation we have managed to get agreement in principal to use the same venue… Read more
SQL Server 2014 is a great release with high performance features like In Memory OLTP, Updatable Column Store Indexes etc.
These features still remains as the top favorite and the most compelling reasons for organizations to do an upgrade, However SQL Server 2014 also includes very small but very relevant… Read more
This is a follow up blog post based on the Intro to Data Factory session I gave on the Training on the T’s with Pragmatic Works. Find more free training from the past and upcoming here. I did my session on January 13, 2015.
Intro To Data Factory
In… Read more