Latest Blog Posts
Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going to split the world. My first observations of the preview are here:
A short break in speaking, as I haven’t been on stage since Oct 11.
Now it’s two weeks to Live! 360 in Orlando and VS Live, both happening in Orlando on Dec 5-9. You can still register, and save $500 with my link.
This is my first time at… Read more
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article, I’m going to try to figure out how.
There’s a couple of approaches they could take…a direct port or some abstraction layer…A direct port would have been hard, basically any… Read more
The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics of a query to the various plans in use by that query to being able to force a plan, it’s all controlled by the data within the Query Data Store… Read more
Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. A summary table of data from the previous month, for example. It just doesn’t make sense to do an update. You delete/truncate and you re-load. Unfortunately, this leaves the table… Read more
In the previous post we looked at a one way T-Test. A one way T Test helped us determine if a selected sample was indeed truly representative of the larger population. A Two way T Test goes a step further – it helps us determine if both samples came from… Read more
No No, not my new hat, although it is rather splendid. I have received the weekly email from Learning Tree listing this week’s courses that are guaranteed to run and being offered at the fantastic price of £750 plus VAT.
|Happy New Hat|
Well there were quite a few announcements in the SQL Server world last week.
SQL Server vNext CTP was made available for download, the big news there is that that version will be available either on Windows or Linux. The Linux version of SQL has been in private preview for… Read more
Continuation from the previous 90 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the improvements and the availability of the of the programability surface for every edition (with some insignificant & logical limitations) that I have blogged about in
SQL Server 2016 SP1 – Programmability Surface for… Read more
Warning! If you have added custom indexes to the VMware vCenter database, you will need to remove them completely before you can complete a vCenter 6.5 upgrade. If they are still present in the database, the upgrade wizard throws an error.
The error file tells you specifically which indexes it… Read more
Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)
Continuation from the previous 89 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on a very important improvement to the limitation of the In-Memory Columnstore Indexes that was existing in SQL Server 2016, but was solved in the Service Pack 1 – the… Read more
SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands the amount of information that is stored inside an execution plan. Since I love using Wait Statistics as a way to identify performance bottlenecks, I was literally jumping through the… Read more
"C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log", the Event viewer under "System" gave the following error
"The SQL Server (I2016) service terminated with the following service-specific…
Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says Change is the law of the the universe. In my opinion, change will bring good to your life, always.
0 comments, 96 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 19 November 2016
Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough and I’m not good enough. Don’t get me wrong, I’ve got an ego (way too big of one really). I just know that there’s room for improvement. It’s one of… Read more
SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For those of us who spend a lot of time in ETL, change tracking is a useful tool for defining what data has changed to make the extract-transform-load process more efficient.… Read more
Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
SQL Server 2016 SP1 has been released. If you haven’t read this blog post yet, have a look at the first point when it details what new in SP1
SQL Server vNext is out… Read more
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at your plan you may have noticed that each operator has a cost. Did you know that the cost is measurable?
When you’re looking at your plan where do you start?… Read more