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...

Changing the sa Password with SSMS–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Cloud backup - MS StorSimple Applicance

In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...

Sarpedon Quality Lab presenting SQL Server 2016 In-Memory and Security Features in Arabia at SQL Gulf 3

?????

(“MARR-hah-bah”, Arabic: Hello)
This year takes me to yet another part of the world:
I have been invited to speak at THE...

SQL 2016 Temporal Tables By Example

Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...