Latest Blog Posts
About two years ago I wrote my first blog post.
About a year ago I paused my blogging activity. That’s when I joined Microsoft.
Not that Microsoft forbids its employees to be active in any social networks, quite the contrary. There are however policies and rules to follow. And it… Read more
I’m heading to India this August for the Data Platform Summit 2017. I am honored to have been selected to deliver a pre-conference seminar called “Building a Database DevOps Process”, where I’ll walk through the way in which you can include your database alongside application code and deploy it… Read more
This post is for all you up and coming data professionals out there. Over the course of the last week we had a T-SQL Tuesday block party which I missed. The beginning of the year is a very hectic time at the shop; doesn’t negate the fact that I… Read more
A special thanks to Daniel Jones [email@example.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).
Always on\Database Mirroring Automatic Page Repair
One of the most useful as well as hottest feature in SQL Server is mirroring of database. It is helpful for numerous of… Read more
Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package… Read more
In this module you will learn how to use the Gantt Power BI Custom Visual. Using the Gantt chart you can easily visualize project timelines and deliverable completion.
Module 43 – Gantt
- Power BI Custom Visual – Gantt
- Dataset – Project Progress.xlsx
- Completed Example – Module 43 – Gantt.pbix
Any object within a database in SQL Server has what is called a four part name. Which rather implies four pieces right? Simple enough
And you can find the lists of each of those pieces in
The breakdown is nice but how about usage?… Read more
On Thursday, March 23rd, at 2pm Eastern, I will be hosting a webinar with Argenis Fernandez from Pure Storage where we will talk about infrastructure challenges as organizations start to adopt SQL Server’s in-memory features, such as In-Memory OLTP and Columnstore Indexes.
Details: The in-memory features that accompany modern… Read more
This is a quickie post to introduce the new DBCC command CLONEDATABASE.
Okay so this isn’t technically a SQL Server 2016 only feature as it’s also available in SQL 2014 SP2 onwards – but that wasn’t released until July 2016.
CLONEDATABASE allows you to do something you could only do… Read more
I’ve spent a lot of time browsing and participating in online technical forums. In my early years in the industry I asked a lot of questions, and as my skills grew I evolved to the point where I was answering more questions than I was asking. The questions and answers… Read more
In this post am going to introduce into some of the basic principles of probability – and use it in other posts going forward. Quite a number of people would have learned these things in high school math and then forgotten – I personally needed a refresher. These concepts are… Read more
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from a directory using the dbatools module. Maybe it is a good idea to look at for disaster recovery scenarios but even PowerShell is going to be useless if your backups… Read more
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This gives a folder structure like this
In my lab I had installed SQL 2016 on a server running Server 2016 TP5 which expired so I needed to… Read more
David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this post has been scheduled to coincide with his talk
If you are at SQL Saturday Iceland today go and see his session.
There will be a series of…
I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register today and come to a training day and learn something. I might just see you there, as I’m thinking to take one or two myself.
I’ll be presenting “Including Your… Read more
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This results in 32 physical cores or 64 logical cores. Therefore, this particular server should have 4 NUMA nodes available.
However, I was looking at the dashboard for… Read more