De-normalize database schema using JSON
Jovan Popovic talks about transforming complex relational structures into simpler tables using JSON format.
IT Data Governance and the Insider Job
Good IT data governance is about crime-prevention as well as crime-detection. Legal action runs war a close second as being one of the more futile and debilitating of human activities, so prevention is always better.
The Office
Would you be more productive outside of an office? Would you take a pay cut to work outside of an office? Steve Jones notes that a number of IT professionals said they would.
The SQL of the Feast Days of Western Christendom
Phil Factor's newest SQL expression calculates when all the feasts and saints days are, giving you plenty of potential causes for celebration.
Copy a database between servers with one command
This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.
Gratitude
Today we have a guest editorial from Erin Stellato that reminds us that we have had support from many, and it's important to thank them from time to time.
The SQL Server 2016 Query Store: Overview and Architecture
SQL Server's Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be the most significant enhancement of SQL Server 2016 - Enrico van de Laar explores.
What is DevOps?
The DevOps moniker seems to bring together good practices that some companies have followed for years. However lots don't, and today Steve Jones tries to get inspire a few of you to give it a try.
Converting and Formatting Numbers Using the M Language
Power BI designer is based upon the Power Query formula language informally known as "M". Unfortunately, the advanced editor inside the Power BI designer does not support syntax highlighting, meaning it can be easy to make mistakes. Matt Mason shows how you can extend the Notepad++ editor to support this feature.
Rethinking Hiring
Today Steve Jones looks at the problems we have with hiring staff and the troubles we go through. Perhaps we can do better with an investment in our people.
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Troubleshooting WQL in custom PBM conditions?
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers