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
DLM Automation Suite add-ons
Many software teams are already integrating their application code but haven’t yet brought the continuous integration discipline to their database development. The DLM Automation Suite helps you extend that process by plugging into third party tools commonly used for application development. It’s now even easier to find the add-on you need for your build or release system.
DBmaestro Unveils TeamWork Version 5.0
New version includes a first of its kind Pipeline Builder, for a significantly easier automated database deployment pipeline, enabling users to visually describe the database environment and the deployment flow.
Sparse Columns in SQL Server : Impact on Time & Space
SQL Server 2008 introduced sparse columns as a method to reduce storage for null values and provide more extensible schemas. The trade-off is that there is additional overhead when you store and retrieve non-NULL values. I was interested in understanding the cost for storing non-NULL values, after talking to a customer who was using this data type in a staging environment.
Why Learn PowerShell?
Microsoft has bet big time on PowerShell for a number of years and has made it very plain that if you intend to have a career managing Windows-based platforms and infrastructure you really need to know PowerShell.
Data as Defense Against Disruption
Recent disruptions have not all been based first on price, but rather data. For instance, Uber actually started in the high-end luxury car business that was highly fragmented. It was their data-driven platform that allowed them to get into cheaper car markets and disrupt the taxi industry.
Entity Framework Pitfalls: Cascade Deletes
The problem with cascade deletes configuration in EF is, sometimes it cannot be done with attributes, which is a mapping mechanism that most people like and use, and the different associations need different approaches.