Latest Blog Posts
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes according to one’s financial reality, like whether you are going to be married, to have a baby soon, to have a new house or to change your career etc, so… Read more
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed by the improvements that the dev team releases. In fact, I’m also impressed by the rate at which they produce changes, with updates happening every week or two.
At this… Read more
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the last 7 years, I am just now finding out about this feature?! What feature is that, you ask? Let me tell you…
When using VS for database projects I typically… Read more
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable an integration of JSON data into a relational schema.
The idea behind this article is to list as many examples of JSON nested elements, an inclusion of sample data,…
If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great information. I’ve talked about the data available there and how important it is in this older post. Checking out the properties of a plan you’re working on is… Read more
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent job step, I am getting below error: –
The job script encountered the following errors. These errors did not stop the script: A job step received an error at line… Read more
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets up at 5am, works a 12 hour day and then (somehow) works out in the evening. They also ran 18km before 10am last Saturday. You know what I was doing… Read more
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and perhaps the most common of those is the use of the Datediff function for retrieving the rows from the last x minutes/hours/days and so on.
Let’s look at the following… Read more
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out
select customer from dbo.customers where id = 2 instead of a much simpler syntax like
dbo.Customers | Customer like Powershell might offer. As I considered the disappointing verbosity of sql server,… Read more
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session known as telemetry_xevents that is shipped with SQL Server 2016. This is not the same as the system_health session that … Continue reading
This was a good meeting. About 50 attendees showed up at Nova (we use their space for joint meetings) to see Grant and Denny speak. Grant did an hour, then we had a 30 minute demo/pitch from ScaleArc, then an hour by Denny. That feels like a better investment of… Read more
This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports. Each of the posts is a condensed version of the material covered in a corresponding chapter…
Continuation from the previous 95 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on a very important feature in the modern times of the real time operations – the online operations. The first online rebuild operation for indexes in the Microsoft Data Platform… Read more
I have been working on SQL Server Consulting assignment, a SQL Server 2014 migration for a new client over the past few weeks. When I’m undertaking such tasks I’m often asked additional questions that make my day a little interesting.
I got a question last week How to Count the…
Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community in 2016!!!. This is an honor I have dreamt of for long needless to say that the award motivates me to contribute more for the…
It’s been a while
I thought that I’d make a quick blog post about an incident that I encountered today that I had not come across before.
I was working on my laptop when I tried doing a really basic task – creating a database.
So I keyed… Read more
By Steve Bolton
…………In the world of fuzzy sets and imprecision modeling, the concept of cardinality takes on new shades of meaning that are not applicable to ordinary “crisp” sets, i.e. those without membership grades. In the last article in this series of amateur-self-tutorials, I mentioned one type of… Read more
I would like to write a blog post about by far the most underrated online show about Data Platform – SQL Unplugged.
Leaded by Scott Klein (One of the best tech evangelist that Microsoft has), this show focuses on talking about the Microsoft Data Platform development future, while hosting… Read more
I’m proud and humbled to announce that my company, Heraflux Technologies, is hiring for a Data Platform Solutions Architect!
We are looking for a highly qualified technologist who is comfortable with database technologies, such as Microsoft SQL Server and other DBMS platforms, and infrastructure technologies, such as virtualization,… Read more