Changing Default Logs Directory – Back to Basics
In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used...
2018-01-05
53 reads
Blog Posts
Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
As a logical continuation from the blog...
2018-01-05
873 reads
Converting a Datarow to a JSON object with PowerShell
This is just a quick post. As is frequent with these they are as much for me to refer to...
2018-01-05 (first published: 2017-12-18)
1,713 reads
Meltdown and Spectre exploits, they can affect your SQL Server instances
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
71 reads
Reference architecture for enterprise reporting in Azure
As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many...
2018-01-05
717 reads
Reference architecture for enterprise reporting in Azure
As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many...
2018-01-05
101 reads
SQL Puzzle 5: Prime Magic
Quite a few of you have read or attempted the previous puzzle SQL Puzzle 1: Magic Squares
As a quick reminder, when...
2018-01-05 (first published: 2017-12-19)
1,688 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
426 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
584 reads
Working with Query Files (Day 5)
So you’re working with a query that you have loaded from a saved file. And now you want to open...
2018-01-05
383 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor Bank BCA KCU PEKALONGAN Telp:0821°8200°203
Telp&Wa 628218200203 Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa Tengah 51116
Kantor Resmi BCA KCU MAGELANG Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers