Display Median Values
DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this
Managerial Moneyball
Steve Jones notes that the Moneyball phenomenon has come to managers and perhaps a little training and data can help find us better managers.
Be Careful with Key Order in SQL Server Missing Index Recommendations
In this tip we look at the missing index recommendations that SQL Server automatically provides and why you should pay close attention to what is recommended and how you actually implement the new index.
Introduction to Azure Cosmos DB Emulator for Creating Applications
Azure Cosmos DB is Microsoft’s NoSQL database platform running in the cloud. In this article, Suhas Pande explains many of the core concepts in Cosmos DB. Additionally, he goes over how to set up a local Cosmos DB emulator to create collections and documents. Using a local emulator is free and allows development with Cosmos DB without being connected to Azure.
Stairway to SSAS Tabular Level 2: Installing the Components
In this level of the Stairway to SSAS Tabular you will learn how to install the platform and tools.
How to migrate a SQL Server database to a lower version
A tip looking at a one time procedure which we can follow to downgrade the database from a higher version (SQL Server 2012) of SQL Server to a lower version (SQL Server 2008 R2) of SQL Server.
Always Canary
One way to make deployments smoother is to use a second system, but that's a challenge for databases, as Steve Jones notes.
Placing a Mark in SQL Server's Transaction Log for Fall Back
How many times have you had a programmer come to you and say they want you (the DBA) to restore their database to sometime prior to when they accidentally corrupted it? If you are doing FULL transaction logging you can do a point in time recovery to restore the database to just prior to when the corruption occurred. But in order to do that you need to know exactly when the programmer corrupted the data, which in a lot of cases is not known down to the second.
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
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