How do I rename a column?

Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...

How to Trim Characters in C#

The removing of leading and trailing characters in c# is made possible by the System namespace.
My demo is uses a windows...

My First PASS Board Meeting

Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as...

My First PASS Board Meeting

Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as...

SQL DB Details Of Multiple Servers Using PowerShell

 
One of my blog reader requested me to get the DB details(Server,DBName,Size,SpaceAvailable,LogSize,PercentUsed Log Space,compatiblilty mode, recovery model etc:-) using PowerShell...

The risks of Delayed Durability

It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about...

Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Continuation from the previous 81 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Previously, I have blogged about about the...

Community work

I have been really busy lately with articles, podcasts and so forth. Lately I have been working on 2 public...

SQL Saturday #492 Follow Up – A Window into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...

What's New in SQL Server 2016 Release Candidate 3

Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations

Benefits of SQL Server 2016 Release candidate 3:
Enhanced in-memory performance provide up...