Latest Blog Posts
The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.
Those who are facing severe issues with their environment, they can plan to… Read more
Hope you all are doing good. Would like to start with praying for all those who have been affected by a deadly earthquake in Nepal. Just when it seems that life is good something like this happens, to remind us of that we are not permanent here. Death…
I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides and say thanks to the organisers, sponsors and everyone who came along to my session - I really enjoyed it and I hope you did to.
The slides are available:
Validations at end of ETL indicate missing data
At the end of each ETL job, I always run some sort of validation process to give me an indication that the data loading and processing are as expected or things have gone terribly wrong. The latter happened last Thursday when I… Read more
If you want to have faster turnaround on your forum questions, you will need to provide enough information to the forum users in order to answer your question.
In particular, talking about T-SQL questions, there are three things that your question must include:
- Table scripts
- Sample data
- Expected output
Everybody wants to be liked, to some extent. Being disliked by others feels like a deficiency, a shortcoming in oneself that must be fixed. It feels like a failure that you’ve let someone down, or even worse, it can make you feel like you’re somehow broken or deficient.
I would… Read more
In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%\Cluster folder on each node in the cluster and the name of the file is CLUSTER.LOG.
In Windows 2008, One of the major… Read more
If you experience a WSFC failover during a VMware vMotion / Hyper-V Live Migration with your virtualized SQL Servers when using Availability Groups, you might have server and/or networking hardware that takes a bit longer than usual to handle the network port failover. This can lead to short unexpected outages… Read more
It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two of you may have noticed that the SQL Saturday web site was down for a moment. Well, three days. Joking aside, this was a serious problem, but my… Read more
Today we’re going to try to extend some advice that I once heard from SQL MVP Jeff Moden, which I wrote about in my previous blog entitled “Make it Work, Make it Fast, Make it Pretty.” That advice was just as pertinent then as it is now,… Read more
I'll post more later, but after a full day of query tuning on a difficult view, I'd definitely say the cost for PRO is worth it. I'm a fan of sql sentry (free), and decided recently to push for a license at work on this tool.
Turns out it was… Read more
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them
When you know a server name but not the name of the instances or the ports that they are using this function will be of… Read more
Ever have this happen?
You (on vacation): I’ll have another piña colada please. Yes, in the coconut. Thanks! Hmm, my phone is ringing…..Hello?
Work: There are problems! The database is messing up and being really slow!
: Well, email me the latest log file from SQL… Read more
Join Jason Strate and Pragmatic Works in Minneapolis on May 7. Learn about Optimizing the Modern Data Platform with SQ Server 2014. Register here.
Here is an overview of the articles I published in the first quarter of 2015.
This will probably be my last article for Intense School for a while.
But on the other hand, I’ve doubled my efforts for… Read more
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.
At some point in time, your replication jobs will stop (some replication failure, stop for maintenance, etc..). Once that happens, will they start working again?
When you… Read more