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
Webinar: How to get started with DevOps
More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. We’ve invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar.
Andrea Angella considers the Universal Architecture idea in light of the question "How can we prevent code becoming an intricate mess over time?"
Schedulers To Rule Them All
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This results in 32 physical cores or 64 logical cores. Therefore, this particular server should have 4 NUMA nodes available. And yet, I was seeing 3 buffers aligned with 3 NUMA nodes. Where was the fourth buffer? Did it just not show up for work?
Prediction: SQL server DBA role
Long gone are the days where a DBA stays busy backing up databases and creating indexes. Today DBAs need to think about Automation, Powershell, Cloud technologies, SQL Server on Linux.
Basics of Probability
A refresher on some of the basic principles of probability that one needs while dealing with more advanced programming in R and data analysis.
Data breach disclosure 101: How to succeed after you've failed
Organisations rarely plan for how they should handle data breaches and when an incident does happen (and that seems to be a near certainty these days), they're left unprepared; they're in unfamiliar territory, there's enormous stress and pressures on them and frankly, they usually react pretty badly.
SQL Server Replication enhancement in SQL Server 2016
Replication is a widely-adopted feature in SQL Server to copy and distribute data and database objects from one database to another and then synchronizing between databases to maintain consistency. SQL Server 2016 brings a few enhancements that should make it easier to use, and work better with other SQL Server features.