What is Graph Processing in SQL Server 2017?
There is a growing need for Graph Databases in the market. This is a type of database, which is capable...
2018-01-08
586 reads
SQLCMD Mode (Day 8)
Have you ever had a script where you needed to run parts of it on different instances of SQL Server...
2018-01-08
451 reads
Statistics Use, Extended Events and Execution Plans
Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...
2018-01-17 (first published: 2018-01-08)
2,263 reads
Python and SQL Server Administration
Some of my previous articles on Python provided insight of the basics and the usage of Python in SQL Server...
2018-01-08
823 reads
Azure SQL Database – Optimizing For Ad-hoc Workloads
Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...
2018-01-16 (first published: 2018-01-08)
1,620 reads
DataMinds.be Meetup – Biml
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and...
2018-01-08
364 reads
Patching your SQL Servers - Meltdown and Spectre
The latest security issue with the name "Meltdown and Spectre" affecting Intel processors was made public last week. This security...
2018-01-08
623 reads
Roll on 2018!
Hey everyone, hope you all had a great Christmas and New Year!
I took December off from blogging as had started...
2018-01-08
367 reads
SQL Server – TRIM() function in SQL Server 2017
Hello friends, Please check the below link of my new article on TRIM() function in SQL Server 2017 – https://social.technet.microsoft.com/wiki/contents/articles/51047.introduction-to-trim-function-in-sql-server-2017.aspx
2018-01-08
414 reads
WITH DATA_PURITY (from recent experience, the key to knowing if patching to 14.0.3015.40 was okay)
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
515 reads
Blogs
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...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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