What is Power BI?
One of the “benefits” of being a chapter leader is that sometimes it means doing a presentation yourself when you...
2016-02-02 (first published: 2016-01-25)
3,019 reads
Blog Posts
Finding Your Query in Query Store
Query Store is pretty amazing. I’m loving working with it. I think it’s likely to change how query tuning will...
2016-02-01 (first published: 2016-01-25)
2,295 reads
Learning R: Happy With My Book Choice
This is just a quick update. I wrote about the two books I’m using to learn R. Well, I’m extremely...
2016-02-01
491 reads
Limitation of In-Memory OLTP in SQL Server 2016 – LOB datatypes not supported
Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...
2016-02-01
544 reads
Monday Morning SQL Break – February 1, 2016
It’s Monday and time fora round-up of last week’s blog and twitter activity – and even an on-time post for all of...
2016-02-01
470 reads
My Best Blog Posts from 2015
ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...
2016-02-01
15 reads
My Best Blog Posts from 2015
ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...
2016-02-01
9 reads
Reusing schedules in SQL Agent
I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor...
2016-02-01 (first published: 2016-01-25)
1,501 reads
SSC Editorial: Design a Better SQL Server Pricing Model
Design a Better SQL Server Pricing Model ran on January 21, 2016 and as you can guess from the title is...
2016-02-01
586 reads
TempDB Excessive Memory Usage Example
I see TempDB using more memory than I feel it should and found a way to resolve it. Previously I dove into technical details and questioning what I saw...
2016-02-01
21 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers