Latest Blog Posts
With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it on Ubuntu you need to upgrade your SQL Server to CTP 1.4. On Ubuntu you do this with
sudo apt-get update sudo apt-get install mssql-server
Once you have CTP 1.4… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
One of the things I’ve been working on is trying to get my DevOps, continuous delivery pipeline working with Azure. Part of that is a test deployment… Read more
I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost records on a page with DBCC DBTABLE… and it also mentioned that you need to be sure that you enable Trace Flag 3604 in order to see the results.… Read more
Today I thought I would take it a little further and show you how PowerShell can be used to transmit or store this information in the manner you require
Test-DBALastBackup returns an object of… Read more
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly an uncommon task, but it’s not as easy as it would seem. The random number function RAND() has a few inherent flaws. And from what I can remember the random… Read more
It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory issues and other bugs and I personally miss the days of Query Analyzer.
I discovered this issue while working in SSMS on my Surface and I’m wondering if it’s just… Read more
Speaking at PowerShell + DevOps Global Summit 2017!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2017 on the conference runs from April 9th 2017 through April 12th 2017. This is an incredible event packed with fantastic content and speakers. Check out the…
On Saturday, March 18, 2017, I spoke at my very first SQL Saturday. I have been an attendee, involved in organizing and volunteered at many over the years, but this was the very first time I was a speaker. My session, What is Power BI?
I have presented this session… Read more
The 2nd cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release or servicing model, please visit:
- CU#2 KB Article: https://support.microsoft.com/en-us/help/4013106
- Understanding Incremental Servicing…
I was just reading The PASS Board Guidance Policy . Overall a reasonable document and absolutely worth reading if you’re thinking about running for the Board. It is missing what I consider a key point about the Executive Committee, so I wanted to write a quick note on that.
The… Read more
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