Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
Microsoft EMS Components: Azure Rights Management
While enterprises create valuable information for their customers or themselves out of their processes, data or the results of applying data to their processes, those components need to be protected. This process is called intellectual rights management. Azure Rights Management is Microsoft’s service that facilitates the protection of information. Diego Samuilov expands on the topic.
How to Script Out Indexes from SQL Server
Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in, or maybe the indexes aren’t checked into source control, and you’re working on fixing that. Kendra Little shares her solution.
How to deal with metadata lock
MySQL uses metadata locking to manage concurrent access to database objects, and to ensure data consistency when performing modifications to the schema: DDL operations. In this post, Vineet Khanna looks at common metadata locks on tables and triggers.
Understanding Hyperconverged Infrastructure Use Cases
Technology is forcing fundamental changes in business landscape, and the data center is at the core of these changes. There needs to be a better way to deploy powerful, scalable systems that are integrated and easy to manage. To address this need, a new type of platform has emerged: hyperconverged infrastructure. Bill Kleyman explains.
8 mistakes that can derail your IoT project
The Internet of Things has already begun to shape consumer electronics for the next decade. But every new capability brings new possibilities for failure: when those new capabilities require taking a straightforward product with a simple feature set and connecting it to an entire planet’s worth of digital information and input, things get complicated quickly.
How to Find Blocked Processes
Blocked processes are often a big problem for DBA’s. They're difficult to monitor - we receive desperate calls saying “Everything is slow!” and before we can do anything a second call “Oh, don’t worry, everything's OK again”. Most times it happens because an ill-behaved process is blocking other tasks for a short period. But how can we find this kind of problem? Dennes Torres explains.
In-Memory OLTP – Understanding Memory-Optimized Tables
How do you get started with In-memory OLTP? Murilo Miranda first advises on the setup of the server and the other prerequisites, and then, after explaining about the two alternative types of memory-optimised table and their stucture, provides sufficient explanation to enable you to create your first Memory-optimised table.
Automatically Creating UML Database Diagrams for SQL Server
SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell.
In-Memory OLTP - Row Structure and Indexes
There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature and usage of memory-optimised indexes. Murilo Miranda continues his series by explaining how such an index is unlike a conventional index