SQL Server Filtered Indexes By Example
What Are Filtered Indexes
Filtered indexes are essentially an index with a predicate on them filtering the data that gets stored...
2017-05-30
61 reads
Blog Posts
SQL Server on Linux Series: Operating System Differences
SQL Server administration, once installed and running, doesn’t vary too much based on your operating system, but the differences in...
2017-05-30
1,030 reads
SQLSaturday Pensacola 2017
It's the start of a SQLSat summer for me, with Pensacola this weekend on Saturday June 3, then Houston two...
2017-05-30
540 reads
Implementing Buffer Pool Extension
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but...
2017-05-29 (first published: 2017-05-18)
1,412 reads
Monday Coffee 2017-05-29
I’ve always said that this blog is my way of giving back to the SQL Server community but there is...
2017-05-29
337 reads
Quitting VIM
I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM....
2017-05-29
572 reads
Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-05-29 (first published: 2017-05-17)
4,086 reads
Upgrading to Modern SQL Server eBook with ScaleArc
Recently I contributed my thoughts in a new ebook from ScaleArccalled “Industry Perspectives: Upgrading to Modern SQL“. Modernizing the datacenter...
2017-05-29
414 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
6 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...
2017-05-28
435 reads
Blogs
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...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers