Latest Blog Posts
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be shocked to find a number of tables using IDENTITY property on a column, a lot of times to create automatic incremental values for the surrogate keys.
What about… Read more
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like. You want to be the cool kids too, so how do you start public speaking? Here in four simple steps, is your roadmap.
The post The Public Speaking Roadmap appeared… Read more
When I agreed to host the T-SQL Tuesday site, I wasn’t sure what to do. I thought about just putting up a static page, one I’d edit, but in some conversations with Adam Machanic, he wanted to have a few people able to manage the site. That makes sense and… Read more
Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself. There are a couple of frequently touted options:
(1) SELECT @@VERSION
The most basic option, and it does return most of what we want but not in any kind of…
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage guy noted that the following has to be done to get best performance.
This command disables SSD Smart Path. You must disable the SSD Smart Path before enabling Controller caching.…
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely use SQL Server Management Studio GUI to do day-to-day tasks, I rather just load a window and start typing stuff … Continue reading
Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and useful, but you have to get all the switches set up if you want full functionality (three way merge). I found the answer on this blog post (a reminder to… Read more
Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported. https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/
SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on Linux so I think now Microsoft should able to include things which we are doing on Windows Server. on that … Continue reading
I am proud to announce that we contributed to the latest revision of the Microsoft SQL Server on VMware best practices guide, freely available at this address. This document outlines some of the common VM-level tweaks and adjustments that are made when running enterprise SQL Server VMs on VMware… Read more
This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I’ll use SQL Server with simple PowerShell script and cmdlets which generate JSON data and displays results in HTML
- Defines the objective of JSON
- Explains the PoSH…
This article will be helpful in configuring TempDB on a local Disk instead of shared storage in SQL Server 2012/2014. This will reduce the I/O requests from the shared storage and overall it can improve performance.
This is the eighth part in the series: SQL Server and Continuous Integration. This post describes the set-up required for GitLab runners to automatically build SQL Server projects after each commit. I use ReadyRoll for my SQL Server projects, but SSDT projects could also be built in the same… Read more
It’s quite easy to hit the PrintScreen key and capture the whole screen. But how do we (quickly) capture a part of the screen ? If you are using OneNote, there’s a very cool trick I want to share with you:
First, make sure that you see the “New Quick… Read more
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
In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup
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